DSXchange

i talked DBA Guys they confirm on that no lock on those tables. is there any way to change the my SQL code. i am using the following SQL then updating into the MCY.PAPERWORK_HEADER using the db2 stage. SELECT col1,col2,col3,table1.col4,tabl1.PWH_ID FROM schema.tabl2,schema.table2 WHERE INT(ORIGINAL_...

Hi, I am getting the below error while reading the data and writing into same table in db2 stage at db2 database. IBM][CLI Driver][DB2/AIX64] SQL0911N The current transaction has been rolled back because of a deadlock or timeout. Reason code "68". SQLSTATE=40001 SQLFetch: Error retrieving ...

Hi, i am getting the below error so how can i sove the issue can you please suggest to me From previous run DataStage Job 399 Phantom 16990 Job Aborted after 1 errors logged. Program "DSD.WriteLog": Line 201, Abort. Attempting to Cleanup after ABORT raised in stage GPITOFMEFMCHTATJOB..JobC...

Hi,

am getting the blow error while exportng the from one environement to another environment.

Record J\753\V9S0P1 in file DS_JOBOBJECTS does not exist

How can i resolve this issue!!!

kumar_s wrote:You never described your job desing.
Search for "Fault type is 11" you ll get similar issues been resolved. ...

Give me sample example please

What is you job design. Reset your job. And lookup for "from previous run..." in your log and post the same. ... Please find the below error: Message:: From previous run DataStage Job 114 Phantom 21158 Abnormal termination of DataStage. Fault type is 11. Layer type is BASIC run machine. F...

Sainath.Srinivasan wrote:Post the full unedited error you receive in your production environment.

I am getting the below warning message:

Abnormal termination of stage JobName.U2.CodaDateFile.IDENT1 detected

Hi,

Here one of my Datastage job getting the AS400 Data and referincing with sybase data then lods into files.

Here this hob has failed in production but uisng same data and job has passed in development environmennt.

Coould you suugest on thsi why this job failed in production?

Hi,

Can anybody suggest on this how can i check the configuration in Datasatge V8.

Hi,

How much value can i put the Administrator.

Here IBM has suggested "set these value to match the record length which should be greater than any value reported in the log"

So could you please tell me where can i get this value?

But i am not able to add it again via the administrator it showing message already exists. In Administrator no variable in userdefined. where can i see the above environment variable othere than administrator and how can insert? What do you mean by "can't" in your post? If you removed it y...

i have one quick question i set up APT_AUTO_TRANSPORT_BLOCK_SIZE as 1 in Administrator previously to solve the db2 load issue. yseterday i removed the above variable one of another isnvestigation then again i try to set the same above variable but i can't. why am not able to inserting the same varia...

From previous run DataStage Job 233 Phantom 8518 DataStage Phantom Finished. From previous run DataStage Job 233 Phantom 4216 Abnormal termination of DataStage. Fault type is 11. Layer type is BASIC run machine. Fault occurred in BASIC program DSP.Open at address 574. Reset your job in the director ...

Here my job has reading the Sybase database using Sybase stage then referencing AS400 Db using ODBC stage then using transfermer then loads into the files. Here it showing the below warining message: "Abnormal termination of stage JOBNAME..XXXX.IDENT1 detected" can u give me an idea how to...

While inserting the same varible in Administrator it showing message variable already exists.

can you please give me an idea where we can edit the user defined environment varaibles other than administrator.