DSXchange

Hi All, I am facing the error as below without any other warnings or fatals. I could not find any post related to the error code 720907. Error: Parallel job reports failure (code 720907) My job does the below: I am reading sequential file through sequential file stage with 25 columns. In the transfo...

Hi All, I have been asked to evaluate Datastage candidates for the development project. I'd like to know what are all the criteria's that i have to look upon from the technical perspective for a 5 years experience candidate? This stroke me because I have not been convinced with the candidates who co...

Hi All, I was stuck in one of the job design and i had to split the job to serve the purpose. The initial design was as below. Seqfile | | \/ Transformer ----> Dataset | | \/ Teradata Connector Dataset - Overwrite Teradata stage - Table is recreated RCP is enabled in all stages. In Trasformer stage ...

Hi All, My current job design is, DB2 Enterprise ---> Transformer ---> Sequential file My requirement is to populate hardcoded value '&#' for the Nulls coming from the Database. The input column (say COL1) is read as char and the same is written to the file as varchar. Hence, I have made use of ...

Yeah. Thanks all.

Thanks Eric. The job certainly worked after keeping the record count to 1.So, my assumption about the issue would be, The DB2 connector for the z/OS table requires each record to be put in array when write method is set as "Insert then Update". (Here i mentioned array size as 1 which has d...

Hi All, Thanks for the valuable replies. But, I forgot to mention that the table is DB2 z/OS which is catalog in DB2 environment and i am loading it using DB2 connector stage. The fatal mentioned is with respect to DB2 connector stage while loading MF table. I had tried all the options that are disc...

Hi Pandeesh, Thanks for the quick reply. My Connector stage settings are Write Mode : Insert then Update Record Count : 5000 Isolation Level : Cursor stability Auto commit : On Array size : 5000 Failed on size mismatch : Yes Failed on type mismatch : Yes Dropped unmatched fields : Yes Lock wait mode...

Hi All, I am also facing this problem with mentioned fatal below. An insert, update, or delete statement failed to run. (CC_DB2DBStatement::processRowStatusArray, file CC_DB2DBStatement.cpp, line 1,984). I am using the target as DB2 connector and had set the write mode as Insert then Update. Curious...

Thanks All.

I shall try your valuable inputs as
1. Getting patch for 8.1
2. Using staging datasets.

Any further updates are welcome.

Hi All, My job design is as follows. DB2 Connector (fetch from DB2 table) ----> Aggregator ----> DB2 Connector ( to load Mainframe table). The problem i am facing here is the below error SQLExecute reported: SQLSTATE = 08506: Native Error Code = -30,108: Msg = [IBM][CLI Driver][DB2] SQL30108N A conn...

Hi All, I was also facing the similar kind of error message in one of my job development in transformer stage as below. Transformer_113: When checking operator: On output data set 0: Dropping component "keyChange" because of a prior component with the same name. I tried all options that we...

Hi All, We are using DataStage 8.0.1 and Database is Teradata on Unix platform. As a code review, I want to find all the jobs in my project that have a Target TD Connector stage and in which the Write Mode is not "Truncate". I tried taking two test jobs in which I have one target TD connec...

Hello All, I am facing a problem in deleting a job in Datastage Release 8.0.1. I tried deleting the job through DataStage designer, it did not work. It was showing some RT_CONFIG5 error. I deleted the job from DataStage Administrator using command: "DELETE DS_JOBS JOBNAME" The output of th...

please check if this can help you.

http://datastage.wordpress.com/2007/05/02/orchadmin/

Regards,
Amit