DSXchange

Seriously, looks like a BUG.. In my case, I have DS license for 4 CPUs, 5 users. But dslictool shows something totally wierd: nnj@lpar5m:/dstage/dsadm/Ascential/DataStage/DSEngine:$ ./bin/dslictool Warning License is in effect. Message[PIN0037] 80 CPU's licensed. DSPX package licensed. DSSRV package...

Hi guys,

All the message handler information are stored in "MsgHandlers" directory.
In my project, it's being stored in /dstage/dsadm/Ascential/DataStage/MsgHandlers directory.

Cheers!

I wish DataStage had DEBUGGER, as we have this feature inbuilt in Informatica..

Thanks so much Arnd!
I'll definately trouble my DBA for this issue.

Sorry, forgot to mention that the target table is kinda' housekeeping table.
Nobody/ no program/ no batch/ no processes other than our DS job access that table.
What say?

You can use EXECUTE COMMAND job activity to run the above mentioned command from DS.

Hi Arnd, I am little confused with your explaination :!: If you have 3 processes all updating the same keys in a table and they have a transaction size of 10, meaning they will do 10 changes and then commit their work. If process #1 updates records 1,2, and 3 and then starts working on record 4 whil...

Thanks guys!!
The points are making sense to me.

Hi, I want to know what are the info which are carried by a link from one stage to the next? In one of my jobs, I have a link from Transformer stage to a DB2/UDB API stage. DB2 stage is a target stage. Now when I replaced the existing DB2 stage with a new one, the link carried the Table name also. F...

Hi,

One of my team members deleted a job (using Designer) accidently. There is no backup of the job. Is there any way that I can recover that job? Does DS store any information regarding deleted objects in any kind of buffer?

Thanks in advance!

Hi Ray, When they tried to import a project into a new server, some of the jobs got compiled while some failed. I observed that those jobs where we used Parallel Transformer stages were denying to get compiled. Lets see what other experts from the forum have to say. I was just seeking some suggestio...

I have given the command as /data/name/sh File_Rename.sh

The command should be sh /data/name/File_Rename.sh

Cheers!!

Knock knock.. Anybody there ??

Hi Deepa, ##E TCOS 000003 05:01:25(007) <main_program> Licensing error: could not find a valid license . ##I TFSC 000001 05:01:25(008) <main_program> APT configuration file: /home/dsadm/Ascential/DataStage/Configurations/default.apt ##I TLIC 000002 05:01:25(000) <APT_LicenseCheckOp in APT_LicenseOpe...

Hi Sasi, If you are running the job through command line, then probably you can use following command to capture the log into a file: $DSHOME/bin/dsjob -logsum -max 100 project_name job_name >> logfile where, $DSHOME environmental variable keeps the DS Home directory path 100 - specifies the maximun...