Hi,
I don't know if this works with all pagesizes but it did with 4k pagesize
when running with DB2 2.1.
- divide the RID by 256, the quotient is the pagenumber, the remainder is
the slotid
- get the tablespace id and table (object) id from the catalog
- run db2dart with the following options:
db2dart <dbname> /DD
and enter the follwing options
${Tableid},${Tablespaceid},${Pagenr}p,1,y"
to print all slots on that page. If you're lucky this still works :)
Kind regards, Gert van der Kooij
----- Original Message -----
From: "Alexandre Efremov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 30, 2001 7:53 PM
Subject: DB2EUG: DB2 UDB Data Page format
> Hi, everyone!
>
> Here's the problem. I have a file SQL0000N.DAT, which
> is a page file for some table OWNER.NAME. I also have
> an update log record that contains certain RID. How do
> I locate the row image in the page file by this RID?
>
> More wide question - is there any documentation that
> describes the page file format for Workstation DB2
> UDB?
>
> Sincerely,
> Alexandre.
>
> __________________________________________________
> Do You Yahoo!?
> Get email alerts & NEW webcam video instant messaging with Yahoo!
Messenger
> http://im.yahoo.com
>
> =====
> To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
> For other info (and scripts), see
http://people.mn.mediaone.net/scottrmcleod
>
>
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
