DSN1PRNT is the way to do it, do you give it the page number? The RID
relates to that page. Use the FORMAT option as well.
Then you use the diagnostic guide to figure out what is where.
It's not fun .... good luck.
-----Original Message-----
From: thodge
[mailto:db2udbdba-ezmlmshield-x21650272.[Email address protected]
Sent: 27 October, 2005 21:03
To: LazyDBA Discussion
Subject: Mapping RID to the actual row on the table.
All,
We have a job that has abended on Z/os DB2 V7. The abend tells me
the following info
DBID 346
PSID 4
RID 0000AF0F49
Ident BDD269EDA087
MemID 1
With the DBID and PSID I was able to find the database and table affected.
But I don't know how to map the RID to the actual row on the table.
I was hoping DSN1PRNT would show me this info, but If it does I haven't
figured out how yet. How can we take a RID and map it to the row on the
table?
We have Platinum tools if that helps?
Thanks
Troy
__________________________________________________________________________________________________________________________________
Standard Bank Disclaimer and Confidentiality Note
This e-mail, its attachments and any rights attaching hereto are, unless the context clearly indicates otherwise, the property of Standard Bank Group Limited
and/or its subsidiaries ("the Group"). It is confidential, private and intended for the addressee only. Should you not be the addressee and receive this e-mail by
mistake, kindly notify the sender, and delete this e-mail, immediately and do not disclose or use same in any manner whatsoever. Views and opinions
expressed in this e-mail are those of the sender unless clearly stated as those of the Group. The Group accepts no liability whatsoever for any loss or
damages whatsoever and howsoever incurred, or suffered, resulting, or arising, from the use of this email or its attachments. The Group does not warrant the integrity
of this e-mail nor that it is free of errors, viruses, interception or interference. Licensed divisions of the Standard Bank Group are authorised financial services providers
in terms of the Financial Advisory and Intermediary Services Act, No 37 of 2002 (FAIS).
For information about the Standard Bank Group Limited visit our website http://www.standardbank.co.za
___________________________________________________________________________________________________________________________________
DB2 & UDB email list listserv db2-l LazyDBA home page