DSXchange

Hello,

One of my jobs have got a huge log of DSD.RUN_3659_13610 of size 800mb in the &PH& directory.
Can anybody foresee any problem like project corruption or job corruption if I delete this file from unix box manully.


Thanks

Mukund

Hi All, We are trying to do following (93000000000000000(93 followed with 15 zeros) + variable) in the datastage transformer where variable = 1,2,3....... However datastage transformer is not giving proper result for this. Typically the result we are getting is - Variable value Result 1 930000000000...

We need to install datastage version 7.1 Enterprise edition on a Sun Solaris Unix box. Can anybody throw light on the following queries: Whether machine with SMP architecture is better or MPP architecture is better for EE. We want to use extensively the parallel extender facility available with EE. ...

Please see below the code that gets RT log and copies it to a unix log file I want to know how do I change the read loop so as to pick up instance Id was log details of a job: ******************************************************************************** * open DS log file ************************...

I have enabled 'Auto-purge of job log' (upto previous 1 job runs) in dastage administrator. But it is not Autopurging log entries in the already existing jobs. When I checked in 'Ascential Datastage Administrator's Guide' ,it's saying that log entries can be Autopurged using settings in Datastage ad...

Which query should I write to get the Log information from RT_LOG file for particular instance_id ??

Thanks

Mukund

In our application job is coded presently such that a control job clears RT_LOG file for a job J1 and then runs the job J1 . After J1 is run successfully the control job copies the log in RT_LOG_nnnn file of job J1 to a xxx.log file for monitoring/archive purpose. Due to new requirements we are need...

If you are planning to uninstall 5.2 and install 7.x, then it's better to change the jobs which have hash file to use directory path instead of Datastage Universe. As a special care you can take backup of all the appendable hash files in sequential files. Especially Customer Master application is us...

I appreciate Mr.TRobinsons suggestion to put constraint on second output link for REJECTEDCODEof first output link. It will work when first output links fails. However if second output link fails , then how do I rollback first output link.

Thanks

If I enable transaction grouping , (the datastage help says "A transaction group cannot use a Rows per transaction value other than 1."), then I will have to make rows per transaction value as 1. That means all the transactions before current transaction have been comitted. After failure i...

I have a job which has 2 parallel streams of database DML: Transformer ------> Update table 1 with transaction handling as 0 | -----------> Insert Table 2 with transaction handling as 0 I want the job not to do the commit (for database operations) unless both the database operations are completed. I...

Thanks. Will it not work on Windows XP Home Editition ??

Can Datastage windows NT server for 5.x or 7.x work on Windows XP system. The installation manual informs that it can be installed on windows NT or windows 2000

Thanks

Mukund

I have tried ORAOCI 8 with 9i client . It doesn't work. I checked with forum on this and got the reply for ORAOCI 8 we should use 8 i client even if database is 9i.
Try doing that. I should work.

Thanks
Mukund

Any body has any idea about it.. please comment...
Thanks

Mukund