Page 1 of 1
Row Counts
Posted: Tue Feb 26, 2008 4:23 am
by ramudwhelp
Hi,
Is there any way to capture the how many rows updated,inserted and rejected to the target.Source is CSV file and target is DB2.
Regards,
Ramakrishna.M
Posted: Tue Feb 26, 2008 4:42 am
by AmeyJoshi14
Yes you can get all this info in DatastageDirector Logs.
You can also get this information through unix by using folloeing command:
dsjob -logsum -type INFO -max 5 PROJECT_NAME JOB_NAME
Posted: Tue Feb 26, 2008 4:50 am
by MOHAMMAD.ISSAQ
In which directory can i able to run the dsjob command in UNIX.
I tried to run it but it's throwing an error as "command not found"
Please help me out
Posted: Tue Feb 26, 2008 4:57 am
by MOHAMMAD.ISSAQ
In which directory can i able to run the dsjob command in UNIX.
I tried to run it but it's throwing an error as "command not found"
Please help me out
Posted: Tue Feb 26, 2008 5:24 am
by Govindarajan
You may need to run this program from bin directory. The bin directory location may differ based on the server. e.g /opt/Ascential/DataStage/DSEngine/bin
Posted: Tue Feb 26, 2008 5:24 am
by AmeyJoshi14
Hey "dsjob" command is stored in following directory:
/Ascential/DataStage/DSEngine/bin
Posted: Tue Feb 26, 2008 5:56 am
by ray.wurlod
You can run it from any directory if you use its full pathname ${DSHOME}/bin/dsjob or if you have ${DSHOME}/bin in your command directory search list (the PATH environment variable).