where is the link count stored

zulfi123786 · Post by **zulfi123786** » Wed Apr 17, 2013 2:13 pm

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

ray.wurlod · Post by **ray.wurlod** » Wed Apr 17, 2013 2:49 pm

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.

zulfi123786 · Post by **zulfi123786** » Wed Apr 17, 2013 9:02 pm

Thanks Ray, Could you please share which of the RT tables has the count stored

ray.wurlod · Post by **ray.wurlod** » Wed Apr 17, 2013 11:49 pm

RT_STATUSnnn

zulfi123786 · Post by **zulfi123786** » Thu Apr 18, 2013 8:17 am

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

"STAGE$2$2013-03-08 06:14:46$2013-03-08 06:14:59$45678592$5699$$$$$12.5$$$$0$25$2"

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

chulett · Post by **chulett** » Thu Apr 18, 2013 8:40 am

FYI - Code tags do not allow bold so I changed you to quote tags which do.

zulfi123786 · Post by **zulfi123786** » Thu Apr 18, 2013 9:18 am

chulett wrote:FYI - Code tags do not allow bold so I changed you to quote tags which do.

Thanks Craig

ray.wurlod · Post by **ray.wurlod** » Thu Apr 18, 2013 4:22 pm

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.

Code: Select all

SELECT @ID FMT '50L', F1 AS OBJECTTYPE FROM RT_STATUS97 USING DICT VOC ORDER BY 1;

zulfi123786 · Post by **zulfi123786** » Fri Apr 19, 2013 5:17 am

Surprise surprise, I was thinking @RECORD fetches all columns from the table but it looks like @ID is not included in @RECORD.

Thanks Ray, Now I can easy identify the link counts in RT_STATUSnnn after including @ID.

zulfi123786 · Post by **zulfi123786** » Mon Apr 22, 2013 4:03 am

Could you please help in understanding if the dsjob -linkinfo picks the count from RT_STATUSnnn or XMETA ?

ray.wurlod · Post by **ray.wurlod** » Mon Apr 22, 2013 4:16 pm

I don't know. However you can research this yourself. Source code for dsjob lives - if I recall correctly - in the sample directory under $DSHOME.

chulett · Post by **chulett** » Mon Apr 22, 2013 4:27 pm

... and is listed in one of the manuals.

zulfi123786 · Post by **zulfi123786** » Mon Apr 22, 2013 10:23 pm

chulett wrote:... and is listed in one of the manuals.

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 fetched

Thanks

zulfi123786 · Post by **zulfi123786** » Mon Apr 22, 2013 11:55 pm

The documentation of source code for dsjob was found in Server job developer guide of version 7.5