command line‎ > ‎

oncheck

informix oncheck

infx oncheck params [ space db owner tab frag idx tbls chunk rowid page ] fork=no

Run the Informix oncheck utility. See the Informix Administrator's Guide for details of the parameters. All oncheck output is stored in the service log.

 option
 description

 example
 params  options to pass to oncheck  params=pr
 space  name of database space  space=root
 db  specify name of database, for database checks  db=database1
 owner  if required, owner specified with table name    owner=dbo
 tab  specify name of table, for table checks  unbuff=db1
 frag  a specific fragment of a table be checked  frag=dat01
 idx  a specific index of a table to be checked  idx=key1
 tbls  a specific table space number to be checked  tbls=100001
 chunk  a specific chunk file to be checked  chunk=dat01.001
 rowid  a specific row to be checked  rowid=100
 page  a specific page number to be checked  page=125
 fork  specify fork=no to have the cli wait until the fork completes  fork=no

examples

infx oncheck params=pe space=dat01

Print extents report of the dat01 space.

infx oncheck params=ce space=dat01

Check the extents of the dat01 space.

infx oncheck params=pt db=database1 tab=table1

Print table space utilization for table1 in database1.