Row Counts

ramudwhelp · Post by **ramudwhelp** » Tue Feb 26, 2008 4:23 am

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

AmeyJoshi14 · Post by **AmeyJoshi14** » Tue Feb 26, 2008 4:42 am

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

MOHAMMAD.ISSAQ · Post by **MOHAMMAD.ISSAQ** » Tue Feb 26, 2008 4:50 am

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

MOHAMMAD.ISSAQ · Post by **MOHAMMAD.ISSAQ** » Tue Feb 26, 2008 4:57 am

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

Govindarajan · Post by **Govindarajan** » Tue Feb 26, 2008 5:24 am

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

AmeyJoshi14 · Post by **AmeyJoshi14** » Tue Feb 26, 2008 5:24 am

Hey "dsjob" command is stored in following directory:
/Ascential/DataStage/DSEngine/bin

ray.wurlod · Post by **ray.wurlod** » Tue Feb 26, 2008 5:56 am

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).