DSXchange

Hi, Currently I'm having the surrogate key generation logic in datastage. The jobs queries the max Surrogate Key from the database and increments for every new source dimension records. One of my collegue is debating that if we put the surrogate key generation logic into the database stored procedur...

Hi, I'm getting the following error in one of the jobs connecting to Mainframe Db2 database. [IBM][CLI Driver] SQL1224N A database agent could not be started to service a request, or was terminated as a result of a database system shutdown or a force command. SQLSTATE=55032 This job has 6 lookup sta...

I need DSXChange community's various thoughts about establishing a connection to Mainframe DB2 database. Currently, We are using DB2-UDB API to do this. Is there any other stage/ways to establish this connection, since i heard that DB2-UDB API stage is based server technology? This is first time i'm...

Hi, We recently upgraded to DS 7.0.1 from DS 7.0. We also got the same errors (mutex error / Expecting n columns Y columns found). Thanks to Tony's suggestion we turned off row buffering, our jobs ran fine but it is taking long time to complete. Is there any fix so that our jobs will run fine using ...

One of our sequencer job is waiting even after the job it called finished successfully (i have noticed in some cases, the sequencer finishes after 1 hr). Even though this is happening occassionally, the dw load programs are crossing our batch process window whenever this happens which creates proble...

Thanks Guys.

We are using Datastage 7.0 which has the Basic Transformer in PX. But i'm reluctant to use since we are getting some performance issues (sometime fatal errors ). Oracle is the database.

Is there anyway to check the format of a char column having dates for valid date format prior to conversion ? let me explain within an example. We are getting Date value in various formats (dd-mm-yy, dd-mm-yyyy, yyyymmdd totally about 6 fixed formats ) in a char column. Now the code needs to validat...

Hi, Why the number of the records from Dataset (that gets displayed in monitor window) reference link in a dataset lookup always match the the primary link's number of records ? I created a dataset with 20,000 records in Job X. In Job Y, i use this dataset as a reference link. Primary link has about...

At what kind of situation it is used?

Documentation says use Spare Lookup whenever the primary source records are very less compared to Lookup (Reference) records.

There are so many posts related to this in this forum. Check them if the following didn't release the job. Log into "DataStage Administrator" and execute following commands. Get the jobno for the job. (SELECT JOBNO FROM DS_JOBS WHERE NAME = 'JobName' ; Then, Administrator -> execute DS.TOO...

Hi, How to do Date Arithmetic in Parallel ? Say Incrementing Input Date Fields by 1. When i tried to use DateFromDaysSince i got the following compiler error... ##E TFCP 000007 11:48:30(001) <transform> Error when checking composite operator: Parsing parameters "" for conversion "date...

Hi,

Whenever we overlay an existing job using import, the datastage generated log (Director -> logs) is getting cleaned up. Is there any way (any setting while importing or something similar) to restrict this clean-up on log files ?

Thanks.

Raj.

Hi, We are using only "Auto" Partitioning Method in our loads. And all of them are working as expected. Is there any project level settings that takes care of the issue Johnman is referring ? When i checked the log messgages in director, our loads initializes "orchsort" operator....

Hi, When we tried initially, we were also getting this error "Referenced Symbol Not Found". After compiling again with CC (C++) Compiler (Datastage Documentation says the external library should be shared library created by using CC compiler) , the code worked. I'm not sure whether you can...