How to LIST DataStage Objects (Non-JOB) from Administrator

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
satish_valavala
Participant
Posts: 123
Joined: Wed May 18, 2005 7:41 am
Location: USA

How to LIST DataStage Objects (Non-JOB) from Administrator

Post by satish_valavala »

How to LIST DataStage Objects (Non-JOB objects like Shared containers Routines, etc.,) from Administrator.
I have tried LIST DS_JOBS and LIST DS_JOBOBJECTS. No Luck with DS_JOBS but got some info with DS_JOBOBJECTS(but limited). We are looking to find shared containers.
Regards
VS
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Why would you expect anything other than job objects to be in a table called DS_JOBOBJECTS ?!!

Other things have other tables - you can search DSXchange to learn the table names. For example table definitions are stored in DS_METADATA and routines are stored in DS_ROUTINES.

Shared containers, not surprisingly, are stored in DS_CONTAINERS.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply