Access to DataStage Universe

Although DataStage is going to abandon Universe as its repository, it is still useful if you have not yet migrate to version 8. You may also found some useful utilities in the universe admin interface. Here is the details :

(1) To retrieve job information …
$DSHOME/bin/uvsh “select * from DS_JOBS;”

(2) To list and unlock all present lock ….
LIST.READU EVERY
UNLOCK ALL

(3) Invoke admin tool …
DS.TOOLS

(4) To delete and recreate a log file …
DELETE.FILE DATA RT_LOG182
CREATE.FILE DATA RT_LOG182 30

the number in “RT_LOGxxx” can be found using (1) …