Oninit cdi / Archive
Talk to an expert →

find oncheck output in the sysmaster tables

Posted in 2006

Topics: Storage & Space Management, Transactions, Locking & Isolation

hoffiman@googlemail.com — — source: Usenet: comp.databases.informix

Hi - i need help, the Output form "oncheck -pt my_database:mytable" is: TBLspace Report for my_database:informix.mytable Physical Address 3:769658 Creation date 11/03/2006 12:33:46 TBLspace Flags 802 Row Locking TBLspace use 4 bit bit-maps Maximum row size 235 Number of special columns 0 Number of keys 1 Number of extents 12 Current serial value 1 First extent size 193 Next extent size 38 ...... I need only the value from Physical Address 3:769658 How can i find this in the sysmaster database tables. I think the " 3:769658 " must stand in the sysmaster database tables, but where ??? thanks a lot

↪ replying to hoffiman@googlemail.com
Captain Pedantic — — source: Usenet: comp.databases.informix

<hoffiman@googlemail.com> wrote in message news:1164622288.702976.46230@h54g2000cwb.googlegroups.com... > > Hi - i need help, > > > the Output form "oncheck -pt my_database:mytable" > > is: > > TBLspace Report for my_database:informix.mytable > > Physical Address 3:769658 > Creation date 11/03/2006 12:33:46 > TBLspace Flags 802 Row Locking > TBLspace use 4 bit > bit-maps > Maximum row size 235 > Number of special columns 0 > Number of keys 1 > Number of extents 12 > Current serial value 1 > First extent size 193 > Next extent size 38 > ...... > > I need only the value from Physical Address 3:769658 > > How can i find this in the sysmaster database tables. > > I think the " 3:769658 " must stand in the sysmaster database tables, > but where ??? Can't remember the exact formula, but the "3" is the chunk number (or is it the dbspace number?), and the remainder is the hex representation of one of the fields in systables. Captain Pedantic Vague University

↪ replying to Captain Pedantic
hoffiman@googlemail.com — — source: Usenet: comp.databases.informix

Captain Pedantic schrieb: > <hoffiman@googlemail.com> wrote in message > news:1164622288.702976.46230@h54g2000cwb.googlegroups.com... > > > > Hi - i need help, > > > > > > the Output form "oncheck -pt my_database:mytable" > > > > is: > > > > TBLspace Report for my_database:informix.mytable > > > > Physical Address 3:769658 > > Creation date 11/03/2006 12:33:46 > > TBLspace Flags 802 Row Locking > > TBLspace use 4 bit > > bit-maps > > Maximum row size 235 > > Number of special columns 0 > > Number of keys 1 > > Number of extents 12 > > Current serial value 1 > > First extent size 193 > > Next extent size 38 > > ...... > > > > I need only the value from Physical Address 3:769658 > > > > How can i find this in the sysmaster database tables. > > > > I think the " 3:769658 " must stand in the sysmaster database tables, > > but where ??? > > Can't remember the exact formula, but the "3" is the chunk number (or is it > the dbspace number?), and the remainder is the hex representation of one of > the fields in systables. > > Captain Pedantic > Vague University Yes - 3 is the chunk number. I like to know the name of the table !

↪ replying to hoffiman@googlemail.com
hoffiman@googlemail.com — — source: Usenet: comp.databases.informix

hoffiman@googlemail.com schrieb: > Captain Pedantic schrieb: > > > <hoffiman@googlemail.com> wrote in message > > news:1164622288.702976.46230@h54g2000cwb.googlegroups.com... > > > > > > Hi - i need help, > > > > > > > > > the Output form "oncheck -pt my_database:mytable" > > > > > > is: > > > > > > TBLspace Report for my_database:informix.mytable > > > > > > Physical Address 3:769658 > > > Creation date 11/03/2006 12:33:46 > > > TBLspace Flags 802 Row Locking > > > TBLspace use 4 bit > > > bit-maps > > > Maximum row size 235 > > > Number of special columns 0 > > > Number of keys 1 > > > Number of extents 12 > > > Current serial value 1 > > > First extent size 193 > > > Next extent size 38 > > > ...... > > > > > > I need only the value from Physical Address 3:769658 > > > > > > How can i find this in the sysmaster database tables. > > > > > > I think the " 3:769658 " must stand in the sysmaster database tables, > > > but where ??? > > > > Can't remember the exact formula, but the "3" is the chunk number (or is it > > the dbspace number?), and the remainder is the hex representation of one of > > the fields in systables. > > > > Captain Pedantic > > Vague University > > Yes - 3 is the chunk number. > I like to know the name of the table ! ok - I found it - the table is sysptntab !!!