infx management suite

Search this site
parser library‎ > ‎

table list

Total of partitions (indices and fragments) for a table.

table_list

 column  sysmaster
 table		  description
 dbsname  infx  database table created in
 tabname  infx  the name of the table
 owner  infx  the owner of the table
 created_datetime  infx  the date and time the table was created
     
 lockreqs  sysptprof  number of requests for locks on this partition
 lockwts  sysptprof  number of locks waited for on this partition
 deadlks  sysptprof  number of dead locks on this partition
 lktouts  sysptprof  number of times locks timed out on this partition
 isreads  sysptprof  number of isread calls
 iswrites  sysptprof  number of iswrite calls
 isrewrites  sysptprof  number of isrewrite calls
 isdeletes  sysptprof  number of isdelete calls
 bufreads  sysptprof  number of buffers read
 bufwrites  sysptprof  number of bufferss written
 seqscans  sysptprof  sequential scans on this partition
 pagreads  sysptprof  pages read from this partition
 pagwrites  sysptprof  pages written to this partition
     
 ti_nextns  systabinfo   number of extents allocated
 ti_fextsize  systabinfo   first extent size allocation
 ti_nextsiz  systabinfo   next extent size allocation
     
 ucount  sysactptnhdr   number of user threads using this table 
 ocount  sysactptnhdr   number of uesr threads with this table open 
     
 ownername  infx  who owns the table
 objectname  infx   name of this database object
 dbspacename  infx   name of storage space this partition is in
 hex_partnum  infx   table partnum in hex digits
 created_datetime  infx   date and time partition was created
 fextsiz_kb  infx   infx calculates this
 nextsiz_kb  infx   infx calculates this
 total_kb  infx   infx calculates this
 used_kb  infx   infx calculates this
 free_kb  infx  infx calculates this
 data_kb  infx   amount of data page storage
 idx_kb  infx   amount of index page storage
 tabid  infx   mapped back to systables in original databae
 totio_buf  infx  total number (reads+writes) of buffer i/o
 totio_pag  infx  total number of page i/o
 shortname  infx  abbreviated name for this partition

partition list

Detailed statistics about each partition of a table or index. Use this when you want the complete breakdown of a table.

partition_list

 column  sysmaster
 table		  description
 dbsname  sysptprof  database of the partition
 tabname  infx  the name of the table this partition belongs to
 partnum  sysptprof  internal number
 lockreqs  sysptprof  number of requests for locks on this partition
 lockwts  sysptprof  number of locks waited for on this partition
 deadlks  sysptprof  number of dead locks on this partition
 lktouts  sysptprof  number of times locks timed out on this partition
 isreads  sysptprof  number of isread calls
 iswrites  sysptprof  number of iswrite calls
 isrewrites  sysptprof  number of isrewrite calls
 isdeletes  sysptprof  number of isdelete calls
 bufreads  sysptprof  number of buffers read
 bufwrites  sysptprof  number of bufferss written
 seqscans  sysptprof  sequential scans on this partition
 pagreads  sysptprof  pages read from this partition
 pagwrites  sysptprof  pages written to this partition
     
 ucount  sysactptnhdr   number of user threads using this partition 
 ocount  sysactptnhdr  number of user threads with this partition open
     
 ti_partnum  systabinfo  internal number
 ti_flags  systabinfo   flags describing the table
 ti_rowsize  systabinfo   size, in  bytes of one row
 ti_ncols  systabinfo   number of columns in the partition
 ti_nkeys  systabinfo   number of keys in the partition
 ti_nextns  systabinfo   number of extetns allocated
 ti_pagesize  systabinfo   page size of the storage space where the partition is located
 ti_created  systabinfo   time stamp when partition was created
 ti_serialv  systabinfo   next serial value
 ti_fextsize  systabinfo   first extent size allocation
 ti_nextsiz  systabinfo   next extent size allocation
 ti_nptotal  systabinfo   total number of pages allocated to this partition
 ti_npused  systabinfo   total number of pages used in this partition
 ti_npdata  systabinfo   number of pages that are storing data
 ti_octptnm  systabinfo   octal representation of table partnum
 ti_nrows  systabinfo   number of rows in this partition
     
 ownername  infx  who owns the table
 objectname  infx   name of this table or index
 dbspacename  infx   name of storage space this partition is in
 hex_partnum  infx   table partnum in hex digits
 created_datetime  infx   date and time partition was created
 fextsiz_kb  infx   infx calculates this
 nextsiz_kb  infx   infx calculates this
 total_kb  infx   infx calculates this
 used_kb  infx   infx calculates this
 free_kb  infx  infx calculates this
 data_kb  infx   amount of data page storage
 idx_kb  infx   amount of index page storage
 tabid  infx   mapped back to systables in original databae
 totio_buf  infx  total number (reads+writes) of buffer i/o
 totio_pag  infx  total number of page i/o
 shortname  infx  abbreviated name for this partition