How does DataStage store Annotations?
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 730
- Joined: Tue Nov 04, 2008 10:14 am
- Location: Bangalore
How does DataStage store Annotations?
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???
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
"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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 730
- Joined: Tue Nov 04, 2008 10:14 am
- Location: Bangalore
This hashed file is internal to DataStage and is not documented anywhere.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 730
- Joined: Tue Nov 04, 2008 10:14 am
- Location: Bangalore
-
- Participant
- Posts: 94
- Joined: Fri Dec 14, 2007 3:22 am
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 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!
-
- Participant
- Posts: 94
- Joined: Fri Dec 14, 2007 3:22 am
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 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!
-
- Premium Member
- Posts: 730
- Joined: Tue Nov 04, 2008 10:14 am
- Location: Bangalore
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There IS NO documentation.
A Search will reveal the reasons.
Essentially, though, IBM regard the "internals" as their intellectual property.
A Search will reveal the reasons.
Essentially, though, IBM regard the "internals" as their intellectual property.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 730
- Joined: Tue Nov 04, 2008 10:14 am
- Location: Bangalore
-
- Premium Member
- Posts: 730
- Joined: Tue Nov 04, 2008 10:14 am
- Location: Bangalore
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???
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???
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Code: Select all
SELECT column_list FROM tablename FIRST 2;
Code: Select all
LIST.DICT tablename
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 730
- Joined: Tue Nov 04, 2008 10:14 am
- Location: Bangalore