Hoai_Truong-Thi-Thu_5649

quick question on DUAS database

Discussion created by Hoai_Truong-Thi-Thu_5649 on Feb 16, 2017
Latest reply on Feb 24, 2017 by bobby_tamayo_automic
Question:
We would like to extract the job details along with source, destination and protocol type for the jobs currently configured in Dollar universe 6.1 version.
Kindly provide the database table details from where we can pull all these information in bulk and also the links to the tables in database.

Answer:

The Dollar Universe database is composed of indexed sequential files.
All data is located in /data directory.
Given that DUAS do not use a external database to save data, you can have some options to extract data:
- Use UVC to view and copy to clipboard (CSV): Monitoring -> Job runs; Activity logging -> Job run history
- Use command uxlst CTL
- Use Reporter

Outcomes