Display record counts on links in Designer from the last run

tbtcust · Post by **tbtcust** » Mon Nov 10, 2008 2:49 pm

Hi all.

How do I go to a job in Designer and display the record counts on the links from the last run?

I have a set of jobs that are run in Designer. Currently when I run each job I take a snap shoot of job in Designer to capture the record counts on the links. This is to prove to auditors that the jobs ran successfully.

Is it possible to run these jobs in a sequencer and then go back to each job in Designer and display the record counts on the links from the last run?

Thanks in advance for any help.

chulett · Post by **chulett** » Mon Nov 10, 2008 2:52 pm

Lost. Sure, you can manually go back, right-click on the canvas and 'Show performance statistics' but I can't imagine that's really what you want. Why not use the job's log for the audit?

chulett · Post by **chulett** » Mon Nov 10, 2008 3:22 pm

Yikes. So... you, manually, need to get a snapshot of *every* job after *every* time it runs? If true, then it sucks to be you.

tbtcust · Post by **tbtcust** » Mon Nov 10, 2008 3:32 pm

Yup and on this project it does suck to be me. There are dozens of jobs.

Is it possible to generate theses snapshots in a report from DataStage?

chulett · Post by **chulett** » Mon Nov 10, 2008 3:39 pm

"dsdesign.exe" on a Client machine can print a bitmap of any job's canvas:

Code: Select all

dsdesign.exe /H=%Host% /U=%User% /P=%Password% /SaveAsBmp=%BitmapDir%\%Jobname%.bmp %Project% %Jobname%

No clue, however, if it will include the job statistics or not. I suspect not but give it a shot.

From what I recall, Kim Duke has a batch file to do this for all jobs in a project in his Tips & Tricks section. You could use that as a starting point, I would think.

kduke · Post by **kduke** » Mon Nov 10, 2008 5:12 pm

That is correct. The batch file will run dsjob to get a list of jobs then run this command on every job. I forget the name of the bat file.

kduke · Post by **kduke** » Tue Nov 11, 2008 7:49 am

Post your command line. Change passwords and user names.

tbtcust · Post by **tbtcust** » Tue Nov 11, 2008 8:01 am

D:\IBM\InformationServer\Clients\Classic\dsdesign.exe /H=999.99.99.9 /U=UserName /P=UserName1 /SaveAsBmp=E:\Reports\JobName.bmp ProjectName JobName

chulett · Post by **chulett** » Tue Nov 11, 2008 8:12 am

That looks syntactically correct. Perhaps an 8.x issue? Can you try a different user/password?

tbtcust · Post by **tbtcust** » Tue Nov 11, 2008 8:26 am

I used all the user/password. They all give the same error.

chulett · Post by **chulett** » Tue Nov 11, 2008 8:28 am

Sounds like it's time to open a case with your official support provider, see if that option is still valid in the 8.x release.

tbtcust · Post by **tbtcust** » Tue Nov 11, 2008 8:33 am

I used all the user/password. They all give the same error.

tbtcust · Post by **tbtcust** » Wed Nov 12, 2008 5:39 pm

chulett, the problem was with the /H=999.99.99.9. It should be /D=999.99.99.9.

I have finally got the hang of this command. One other questions. I need the bitmap to display the stats from of the last run in the links. Is it possible to do this with this command?

ray.wurlod · Post by **ray.wurlod** » Wed Nov 12, 2008 11:34 pm

No. The bitmap is taken from the design-time metadata not from the run-time metadata.

chulett · Post by **chulett** » Wed Nov 12, 2008 11:44 pm

Yah, already said I was afraid that would be the case.