where is the link count stored
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 730
- Joined: Tue Nov 04, 2008 10:14 am
- Location: Bangalore
where is the link count stored
Hi
I was trying to find in which record and field of DS_JOBOBJECTS the link counts are stored.
The issue is with multi-instance jobs where dsjob -linkinfo is returning counts of another instance run. This is happening rarely but is happening.
If some one has faced this issue please guide the resolution implemented.
Thanks
I was trying to find in which record and field of DS_JOBOBJECTS the link counts are stored.
The issue is with multi-instance jobs where dsjob -linkinfo is returning counts of another instance run. This is happening rarely but is happening.
If some one has faced this issue please guide the resolution implemented.
Thanks
- Zulfi
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Link counts are not stored in DS_JOBOBJECTS. Only design-time information is stored in DS_JOBOBJECTS. Run time information is stored in hashed files whose names begin with RT_, in XMETA and, if you have it, in the database that supports the DataStage operations console.
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 730
- Joined: Tue Nov 04, 2008 10:14 am
- Location: Bangalore
Scanned the RT_STATUSnnn for a specific job and found entries where the link count, link start and end times are captured, sample record (RT_STATUSnnn.@RECORD) shown below
In the above record it looks like 45678592 is some sort of key for the link name but did not find a mapping between link name and the above number in DS_JOBOBJECTS (making a guess as this should be a design time information).
Please help.
The one in bold is the link count but this left me wondering where is the link name, how is it mapped to the link name ?"STAGE$2$2013-03-08 06:14:46$2013-03-08 06:14:59$45678592$5699$$$$$12.5$$$$0$25$2"
In the above record it looks like 45678592 is some sort of key for the link name but did not find a mapping between link name and the above number in DS_JOBOBJECTS (making a guess as this should be a design time information).
Please help.
- Zulfi
-
- 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 such thing as a sample record from RT_STATUSnnn - records for different object types have different structures. Enjoy.
You haven't actually shown the key values. Try this query.
You haven't actually shown the key values. Try this query.
Code: Select all
SELECT @ID FMT '50L', F1 AS OBJECTTYPE FROM RT_STATUS97 USING DICT VOC ORDER BY 1;
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 730
- Joined: Tue Nov 04, 2008 10:14 am
- Location: Bangalore
So is the source code for dsjob described in one of the manuals ? Could you please share in which manual as the only reference I have seen is description of dsjob under API chapter which doesnot specify from where (universe or XMETA) the link counts are fetchedchulett wrote:... and is listed in one of the manuals.
Thanks
- Zulfi
-
- Premium Member
- Posts: 730
- Joined: Tue Nov 04, 2008 10:14 am
- Location: Bangalore