find the page(s)

Shields Michael

find the page(s)
Is there a way (utility/sql/etc.) to determine what page(s) an index or data
row is on?
We're getting a -913 and I'm trying to determine where the data is located
for the order that succeeded vs. where the one is that was attempting to
update before the -913.

Thanks,
Mike



Steen Rasmussen

Re: find the page(s)
(in response to Shields Michael)
Michael - if you have access to CA/PLATINUM Database Analyzer (PDA), you can
use the Page Display Facility to display the page shown in db2MSTR. Just
type in the Database and pageset to get a hex-display. Then you can type the
pagenumber being shown in the DSNT501, og you can PNEXT browse your way
through.

Kind regards
Steen Rasmussen
Computer Associates



-----Original Message-----
From: Shields Michael [mailto:[login to unmask email]
Sent: 7. januar 2003 17:37
To: [login to unmask email]
Subject: find the page(s)


Is there a way (utility/sql/etc.) to determine what page(s) an index or data
row is on?
We're getting a -913 and I'm trying to determine where the data is located
for the order that succeeded vs. where the one is that was attempting to
update before the -913.

Thanks,
Mike






James Campbell

Re: find the page(s)
(in response to Steen Rasmussen)
Try reinserting the row. If you have at least one unique index, the
insert will fail with a -803 - giving the original row's RID (ie page
and index entry).

James Campbell

On 7 Jan 2003 at 10:37, Shields Michael wrote:

> Is there a way (utility/sql/etc.) to determine what page(s) an index or data
> row is on?
> We're getting a -913 and I'm trying to determine where the data is located
> for the order that succeeded vs. where the one is that was attempting to
> update before the -913.
>
> Thanks,
> Mike
>
>
>