Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Location
    India
    Posts
    1

    Question Unanswered: Page version of a table in Informix 9.21 UC3

    Hi,

    Other than the option of using oncheck -pT database:tablename for finding the page versions of a table, Is there any querry of using system tables to get the page version info.

    TIA

    Deepak

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    Hi,

    Please run this:
    oncheck -pt youbase:youtable, next look for Physical Address for example 8:2801
    Next run oncheck -pP 0x8 2801 |more
    Then you look
    oncheck -pP 0x8 2801|more
    addr stamp chksum nslots flag type frptr frcnt next p
    rev
    8:2801 535659845 9051 5 2 PARTN 352 1672 0
    0
    slot ptr len flg
    1 24 92 0
    2 116 44 0
    3 160 176 0
    4 336 0 0
    5 336 16 0
    slot 1:
    0: 0 40 1 45 0 0 9 2 0 0 2 64 0 16 0 0 .@.E.......d....
    16: 0 1 0 0 40 67 18 d0 0 0 0 1 0 0 b ea ....@g.P.......j
    32: 0 0 1 31 0 0 b ea 0 0 3 c1 0 0 3 c0 ...1...j...A...@
    48: ff ff ff ff 0 40 1 45 0 0 23 2f 0 0 0 1 .....@.E..#/....
    64: 0 0 0 0 0 1 0 0 0 0 0 1 0 0 0 0 ................
    80: 0 1 0 0 0 0 2 6c 0 47 95 40 .......l.G.@....

    Gustavo.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •