DSXchange

Thanks for the reply.

The output for Change Capture is containing some records but those records are not being written to Sequential file. When I used Dataset, records were populated.

Hi All, Please let me know if Sequential File stage or Oracle Enterprise stage can be used as output stage for Change Capture stage or is it that only Dataset stage can be used to capture output records. I tried using Sequential File for capturing output records from Change Capture. The job got fini...

I tried the query which u suggested.Actually datafile path is set but the job is not pointing to that path.

The entire filesystem is changed but datastage is pointing to the old filesystem path. Even DBA is confused what to do

Thanks for the reply Datastage and Oracle database are in different server.In the dsenv file, the oracle home path is mentioned which is the oracle client path in the datastage server.In administrator, I am just giving the database name,schema name and password for connection. Nowhere I could find t...

Hi All, The DBA has moved the oracle schema attached to my project to a different file system due to some memory issues. The schema name is the same as the old one but the data file name and path is changed. Now when I am trying to load database table from datastage job, I am getting fatal error as ...

After executing UVFIXFILE i tried again scheduling the job but then it was not working. Than I closed all the instances of datastage and reopened and tried. Hopefully it worked then. I guess refreshing of the Datastage director was required after command execution which i didnt do earlier.

I havent recompiled the job as this error was not coming only for a particular job. It was occuring when i was trying to schedule any job. If UVFIXFILE has not worked then I dont know how it got rectified but now everything is fine.

Thanks once again

Thanks a lot,

Now I am able to schedule the job. That UVFIXFILE command has worked.

I tried to execute the command in Administrator client and got the below output. Beginning TRACE of RT_CONFIG62. TRACE of RT_CONFIG62 completed. Scanning overflow buffers. Scan complete. 2 group (s) processed. 2 group buffer (s) processed. 6 record (s) processed. Number of data bytes = 2508 But stil...

Thanks for your help.I am sorry but I am not able to understand your point. How can I run the command on the client when file is on the server....

Can you pls explain how to do this?

try to execute dsjob command in the below path:

/data1/Ascential/DataStage/DSEngine/bin

This might work for you

I tried with the below command: $DSHOME/bin/uvfixfile RT_CONFIG62 The output of the command was: "No filename specified." Actually RT_CONFIG62 is a directory in which 3 files are there: DATA.30, OVER.30 and one hidden file .Type30. When I am using the same command for these files then also...

Hi All, I want to schedule the job through crontab. I have given the entry in crontab file in the path "/var/spool/cron/crontabs" as: 20 16 * * * $DSHOME/bin/dsjob -server <server> -user <user> -password <password> -run <project> <sequence name> But the job is not getting scheduled. What s...

Hi All , when I am trying to schedule the job from datastage director, I am getting the below error. "Cannot find record JOBPARAMINSTS in executable job file RT_CONFIG62 " I tried to recompile the job but still the same problem persists. This problem is only in one project. In other projec...