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. |