func=sch

home‎ > ‎table‎ > ‎

Use this function to get performance and sizing information about a table, and the individual parts of that table.

usage

infx table func=sch db tab

display table schema

required:

db - select database

tab - the name of the table or enter owner.table

example

Use this to get schema nformation about a table, reformat and output it.

demo1@bobii:/home/informix>infx table func=sch db=monitor_jgh1 tab=objectdailydetail templ=infx-test-tabsch

info for table: monitor_jgh1:..objectdailydetail

columns

col no=1 name=mon_date attrs=datetime year to day

col no=2 name=sub attrs=char(5) default 'all' not null

col no=3 name=dbname attrs=char(36)

col no=4 name=tabname attrs=char(36)

col no=5 name=object attrs=char(36)

col no=6 name=space attrs=char(36)

col no=7 name=alloc_kb attrs=decimal(20,0)

col no=8 name=used_kb attrs=decimal(20,0)

col no=9 name=rows attrs=decimal(20,0)

col no=10 name=extents attrs=decimal(20,0)

col no=11 name=alloc_delta attrs=decimal(20,0)

col no=12 name=used_delta attrs=decimal(20,0)

col no=13 name=rows_delta attrs=decimal(20,0)

col no=14 name=delta_days attrs=decimal(20,0)

col no=15 name=bufreads attrs=decimal(20,0)

col no=16 name=bufwrites attrs=decimal(20,0)

col no=17 name=pagereads attrs=decimal(20,0)

col no=18 name=pagewrites attrs=decimal(20,0)

col no=19 name=lockreqs attrs=decimal(20,0)

col no=20 name=lockwts attrs=decimal(20,0)

col no=21 name=deadlks attrs=decimal(20,0)

col no=22 name=lktouts attrs=decimal(20,0)

col no=23 name=isreads attrs=decimal(20,0)

col no=24 name=iswrites attrs=decimal(20,0)

col no=25 name=isrewrites attrs=decimal(20,0)

col no=26 name=isdeletes attrs=decimal(20,0)

col no=27 name=seqscans attrs=decimal(20,0)

options: extent size 6998 next size 2500

lock mode page

constraints

index

name=ix1_odd type=D attrs=dbname,tabname,mon_date opt=in idx01

name=ix2_odd type=D attrs=mon_date,dbname,tabname opt=in idx01

name=ix3_odd type=D attrs=dbname,tabname,object,space,mon_date opt=in idx01

notes

Modify the template, or create your own to format the information to your requirements. For example, if you just want constraint information, create your own template that only includes constraints