DSXchange

Hi,

How and where does DataStage store Annotations and data regarding the "Performance Statistics" ?

When i store the Column definitions in the repository how does DS store them???

The performance information is not stored with the job, it is retrieved at display time from the logs. The annotations are stored in the repository as distinct entities in the DS_JOBOBJECTS.

"Performance" data are stored in the RT_STATUSnnn hashed file for the job.
Annotations are stored in DS_JOBOBJECTS and have repository IDs of the form VnAm (where n and m are integers).
Column definitions imported as table definitions or saved from jobs are stored in DS_METADATA hashed file. Column definitions loaded into jobs are stored in link records in DS_JOBOBJECTS.

This answer pertains only to version 7.5.3 and earlier.

In which guide of DATASTAGE is DS_JOBOBJECTS discussed???

This hashed file is internal to DataStage and is not documented anywhere.

None of the 'internals' like that are documented. How about you give us some idea what you are after or are trying to achieve?

I am trying to learn..... got across this DS_OBJECTS but did not find any documentation related to that.......
checking if someone here has got reference to any documentation regarding the same.

Hi,


I am also trying to learning about DataStage Commands like UVSH, TST_GGS, LOGTO,..etc. And also unable to find documentation for the DataStage Job tables like DS_JOBS, DS_OBJECTS,.. etc. Didn't find any documentation related to this in DS Ver 7.5 & 8.0.1

So, Please help me, where can i find reference documentation's for the same.

Thanks
venkat!

Hi,


I am also trying to learning about DataStage Commands like UVSH, TST_GGS, LOGTO,..etc. And also unable to find documentation for the DataStage Job tables like DS_JOBS, DS_OBJECTS,.. etc. Didn't find any documentation related to this in DS Ver 7.5 & 8.0.1

So, Please help me, where can i find reference documentation's for the same.

Thanks
venkat!

I am trying to learn..... got across this DS_OBJECTS but did not find any documentation related to that.......
checking if someone here has got reference to any documentation regarding the same.

There IS NO documentation.

A Search will reveal the reasons.

Essentially, though, IBM regard the "internals" as their intellectual property.

Is there any possibility to know column names this DS_OBJECTS UV table contains using a query in DataStage Administrator???

I am familiar with IBM DB2 database and found that the functions in DB2 doesn't work UV tables.... where can i find functions which work with UV tables???
For example: In DB2 to get only first 2 rows "fetch first 2 rows only" is used ... so what is the equivalent in UV? and to know the columns in DB2 "describe tabel <table name> is used .... what is the equivalent in UV???

Thanks for the info!!!!!!!!! :D
where can i find information on how to work with universe queries????