How does DataStage store Annotations?

zulfi123786 · Post by **zulfi123786** » Wed Aug 26, 2009 3:28 am

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???

ArndW · Post by **ArndW** » Wed Aug 26, 2009 4:07 am

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.

ray.wurlod · Post by **ray.wurlod** » Wed Aug 26, 2009 8:24 am

"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.

zulfi123786 · Post by **zulfi123786** » Thu Aug 27, 2009 1:39 am

In which guide of DATASTAGE is DS_JOBOBJECTS discussed???

ArndW · Post by **ArndW** » Thu Aug 27, 2009 3:38 am

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

chulett · Post by **chulett** » Thu Aug 27, 2009 5:41 am

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

zulfi123786 · Post by **zulfi123786** » Thu Aug 27, 2009 11:04 pm

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.

chvenkat.v · Post by **chvenkat.v** » Thu Aug 27, 2009 11:16 pm

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!

chvenkat.v · Post by **chvenkat.v** » Thu Aug 27, 2009 11:17 pm

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!

zulfi123786 · Post by **zulfi123786** » Thu Aug 27, 2009 11:24 pm

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.

ray.wurlod · Post by **ray.wurlod** » Fri Aug 28, 2009 1:57 am

There IS NO documentation.

A Search will reveal the reasons.

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

zulfi123786 · Post by **zulfi123786** » Sat Sep 05, 2009 11:13 pm

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

zulfi123786 · Post by **zulfi123786** » Sat Sep 05, 2009 11:26 pm

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???

ray.wurlod · Post by **ray.wurlod** » Sun Sep 06, 2009 2:40 am

Code: Select all

SELECT column_list FROM tablename FIRST 2;

Code: Select all

LIST.DICT tablename

zulfi123786 · Post by **zulfi123786** » Sun Sep 06, 2009 12:01 pm

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