home‎ > ‎sysadmin‎ > ‎

func=shrink

Shrink a database table.

usage

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

example

Shrink the objectdailydetail table in the monitor_jgh1 database.

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

execute: execute function task('table shrink', 'objectdailydetail', 'monitor_jgh1','');

Database selected.

(expression)  Succeeded: table shrink  monitor_jgh1:informix.objectdailydetail

1 row(s) retrieved.

Database closed.