home‎ > ‎table‎ > ‎

func=info

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

Output partition information about a specific table

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

partitions:
name=objectdailydetail-ix1_odd, owner=informix, object=ix1_odd, space=idx01, ext=1
name=objectdailydetail-ix2_odd, owner=informix, object=ix2_odd, space=idx01, ext=1
name=objectdailydetail-ix3_odd, owner=informix, object=ix3_odd, space=idx01, ext=1
name=objectdailydetail, owner=informix, object=objectdailydetail, space=dat01, ext=1
name=objectdailydetail-px_odd, owner=informix, object=px_odd, space=idx01, ext=1