DataStage Engine commands

[Creo]

Hi ram,

Welcome to the wonderful world of DataStage! [;)]
If you have the product installed on your computer, you will see there is a bunch of on-line manuals available. I invite you to take a look at them, more particularly the DataStage developper's and DataStage BASIC guides.

Good luck!

Creo

[s_boyapati]

Hi
Can anyone give me a command to get a list of all jobs with their latest run start and end times for those jobs? I want to create a report in Excel to show the times for those jobs. Please help me.

Thanks in advance.

[anupam]

Hello All,

I have list of commands which i am mailing. I hope this will help the forum. All the commands has to be executed from administrator or can be executed once uv is invoked.

DS.TOOLS Menu
Option Text on Screen
1 Report on project licenses
2 Rebuild Repository indices
3 Set up server-side tracing
4 Check integrity of job files
5 Administer processes/locks
6 Adjust job tunable properties

DS.TRACE Menu
Option Text on Screen
1 Query trace status
2 Turn tracing on
3 Turn tracing off
4 List trace records
5 Delete all trace records

DS.PLADMIN Menu
Option Text on Screen
1 List all processes
2 List state of a process
3 List state of all processes in a job
4 List all locks
5 List locks held by a process
6 List locks held by all processes in a job
7 Clear locks held by a process
8 Clear locks held by all processes in a job
9 Logout a process
10 Logout all processes in a job
11 Clear status file for a job


DS.TOOLS Menu
Option Command
1 DSR_LICENSE REPORT
2 DS.REINDEX ALL
3 DS.TRACE
4 DS.CHECKER JOBS
5 DS.PLADMIN
6 DS.TUNEPROPS

DS.TRACE Menu
Option Command
1 TRACE
2 TRACE ON
3 TRACE OFF
4 TRACE LIST
5 TRACE CLEAR

DS.PLADMIN Menu
1 DS.PLADMIN.CMD LIST PIDS
2 DS.PLADMIN.CMD LIST PIDS
3 DS.PLADMIN.CMD LIST PIDS
4 DS.PLADMIN.CMD LIST LOCKS
5 DS.PLADMIN.CMD LIST LOCKS
6 DS.PLADMIN.CMD LIST LOCKS
7 DS.PLADMIN.CMD CLEAR LOCKS
8 DS.PLADMIN.CMD CLEAR LOCKS
9 DS.PLADMIN.CMD CLEAR PIDS
10 DS.PLADMIN.CMD CLEAR PIDS
11 DS.PLADMIN.CMD CLEAR STATUS

Infact i am also not sure whether there are any other administrator commands available or not. If YES then pls let me Know from where i can get the complete list.

[ds_developer]

In a UV session you can type HELP

Can't be done from Administrator.

John

[ray.wurlod]

Hi
Can anyone give me a command to get a list of all jobs with their latest run start and end times for those jobs? I want to create a report in Excel to show the times for those jobs. Please help me.

Thanks in advance.

Don't need a command.

• Use the Director client.
  Choose Status view.
  Uncheck Show Categories from the View menu.
  Double-click on the grid heading to sort by whichever column you prefer.
  Use the Filter (Ctrl-T) to filter as required.
  Choose Print from the File menu and check the Print to File box.
  You now have the report that you can import to Excel. You will probably want to reformat it once there.