DSXchange

Thanks, Craig

I tried it again and it worked.

regards,

Azens Chang
MetaEdge Corp.

Hi all,

I can run DataStage Job by using 'dsjob' command in unix command mode. But if this job has been released, the released job cannot be run by using 'dsjob' command in unix command mode. Is there any solution?

regards,

Azens Chang
MetaEdge Corp.

Hi Ray,

Thanks a lot. Finally we found that the reason why DS_JOBOBJECTS is corrupted: disk error by an accidental power surge. I think periodical backup is the only solution.

regards,

Azens Chang
MetaEdge Corp.

I logon DataStage Director but error message box pops up and fail to open it. After close all popped up message boxes, I found there's no job in my project in Director. Then I try to loop up job list in UniVerse but Once I issue LIST command it told me that 'Fail to open DS_JOBOBJECTS'. Later on I t...

Hi all, I use DataStage 5.2r2 on E10K machine with Solaris 8. There are 2 hash files stored surrogate key: 1) 8 millions of records, 430M bytes in size with 36 bytes in average record size. 2) 5.5 millions of records, 280 bytes in size with 32 bytes in average record size. Both of them are static ha...

Hi,

In my experience, static hash file is more stable than dynamic one, especially when you read and write the same hash file in a job or in jobs which run concurrently. I always synchronize thr hash file with the table to guarantee the consistancy and stability.

Azens Chang
MetaEdge Corp.

Hi, You can try this function 'DSMakeJobReport'. It generates a string describing the complete status of a valid attached job. There are some sample codes I wrote in a routine to capture the start time, end time, elapsed time, status and status description for jobs. ** JobHandle = DSAttachJob(JobNam...

Hi, You can do analysis on your hash file first, find out the optimal type and size for your hash file. I have 2 hash files for generating surrogate no.. 1 hash file has 8 millions of records and another has 5.5 millions. Both of them work well. I suggest you using static file and rebuild it after b...

Hi,

Maybe you can try OCI instead of ODBC for Oracle.
EOF error in Oracle sometimes implies the unknown error which is nothing to do with network issue.
If you're using Oracle 8.1.6 on NT, upgrade it, coz it's not a stable version.