DSXchange

what I have had happen in the past when a job that is inserting or updating is just sitting there is that my transaction log is full and cannot grow. After doing a TLOG backup the datastage job continued to process. We set our tlog backups to run quite frequent when we are processing the DW so that ...

I run this code in a batch job. Gives me three different lists in the director job run log. Folder is a param. The Folder option worked in versions prior to 8.0 have not tryed to figure out the issue in 8.xxx yet , to busy but I still get a list of all the jobs FailedOpens = "" tablename =...

I think you need to clarify this question.

And to say it another way. when a DS job runs in spawns an OSH process for each node defined in your config. This process is called the conductor. Each conductor will spawn multiple OSH processes called players for the objects in the job.Due to the pipline parellelism architecture all stages start a...

`e could be a spanish char
The ` for example determines gender of a noun it is used in names and such and removing the char changes the meaning of the word.

Thats one thing to look at.
If so you might need to handle spanish charecters.

I have the same issues with the OLE DB for sql server. It requires values in all the properties, before sql after sql so on. To get around this I just put in a char(32) space. It then compiles I have not contacted IBM on this because I am on 8.5 now and the object is depreciated. We are migrating th...

I would also do inserts then update
less scanning.

[UPDATE] I have two patches coming from IBM One to fix the Heap allocation when using the two new functions GetSavedInputRecord and SavedInputRecord these functions cause memory consumption to soar till it runs out and the job aborts. They have found the issue and are unit testing it now. The surro...

One approach to think about would be using schema files with the job. I had to read 100 differant files from a data mirror CDC output as the files arived. I did not want to have 100 jobs. I wrote one job which when run used a parameter set to define which schema to use. this way I only needed one jo...

Well my 2 cents would go like this. I have been building datastage jobs since version 3 I am currently using 8.5 32bit and 8.5 64 bit. That said Simpler is better, why when it comes time to determine why a job takes so long and you have 50 stages in the job you will understand why. second not only a...

Did you creat a schema?
Did you read the documentation on using the object and how to configure it?
Did you define your repeating element?

Try this stage PxCombineRecords Stage Combine records with identical keys into single record Data restructuring stage for Parallel Extender jobs, which combines rows in which particular key column's values are identical into vectors of subrecords. Or If you are using 8.5 use the new functionality (l...

Try using this to make sure your data is correct. and reject the row that has invalid date conversions IsValidDate Returns whether the given value is valid for the type date. v Input: testdate (date) v Output: result (int8) v Examples. If the column mylink.mydate contains the date 2011-09-13, then t...

There is a new Variable called @ITERATION which you use to controll the number of loops. like @ITERATION <= 5 will take one input row and create 5 output rows. You also have loop variables which you can define and use just like stage variables. Its pretty self explanatory for the basics but does hav...