home‎ > ‎sysadmin‎ > ‎

func=defrag

De-fragment a database table.

usage

infx sysadmin func=defrag db tab [ owner ]
     defragment a table
       required:
         db - select database
         tab - the name of the table or enter owner.table

example

De-fragment the objectdailydetail table in the monitor_jgh1 database.

demo1@bobii:/home/informix>infx sysadmin func=defrag db=monitor_jgh1 tab=objectdailydetail

execute: execute function task('defragment', 'monitor_jgh1:objectdailydetail');

Database selected.

(expression)  OK

1 row(s) retrieved.

Database closed.