DSXchange

attu

I guess DataStage 8.1 will come out in the end of 3rd Quarter and will contain fixes and bugs.

attu

I am executing through Admin Client Command Window.

attu

I am getting this error after executing from TCL
syntax error. Unexpected sentence without filename. Token was ""

attu

I am still confused how to execute the command to see control records.

Code: Select all

LIST.ITEM RT_LOG5276 WITH @ID LIKE // ????

attu

>SELECT * FROM RT_LOG5276 WHERE @ID = 141;

0 records listed.

attu

PLease tell me how to find if event 141 exists ?

And how to verify control records are correct?

attu

I dont think the RT_LOG hashed table is corrupted, I executed count RT_log5276 and it did return records.

attu

What could be the reason of this error.

Code: Select all

RetrieveLogInformationMultipleInstance.I.JobControl (fatal error from DSGetLogEntry): Job control fatal error (-4)
(DSGetLogEntry) Event number 141 not found in RT_LOG5276
(DSGetLogEntry) Cannot find log event with id '141'

Any suggestions please?

Thanks

attu

Just wanted to ask few more things: We were having this issue while we tried to load data in db2 using db2 enterprise stage. When the load fails, the table becomes inaccessible. DBA needs to drop and re-create table and tablespace ( If we do not want to retain the data) If we want to retain data, th...

attu

interestingly the issue was resolved when dba's recycled the database before we restarted this job.
what is the root cause? the dba's think its an issue with PX.
any insights

attu

Reason code = 3 means, check diskspace to run load, database is full, clear the database

attu

A px job keeps failing because of this error target_load,7: SQL0911N The current transaction has been rolled back because of a deadlock or timeout. Reason code "68". SQLSTATE=40001 This is a multi instance job using DB2 EE stage as target (write method:load, write mode:append) , no. of rec...

attu

what version of datastage you are using?

attu

How are the Runtime hashed files (RT_SC, RT_CONFIG,RT_STATUS) are affected when jobs are running and suddenly we run out of disk space?
Just want to go a little deeper, how is it anticipated?

Thanks

attu

Hi DS Gurus, One of our job sequence failed with this error code=-99 [General repository interface 'other error'] Another job in this sequence finished but not showing any status. I tried to clear the status file but no use, it shows it as compiled and when I close the director and re-open it, it do...

DSXchange

Search found 224 matches

Job control fatal error (-4)

DB2 deadlock and timeout Issue

no job status, DSR_EXECJOB (Action=5) error