The onutil REPACK DATA command

To use this feature, the DBA issues a new onutil command, using the following syntax:

>>-onutil REPACK DATA IN---------------------------------------->
 
>--+-TABLE--dbase--:--+----------+--table--+------------+-+----->
   |                  '-owner--.-'         '-,--dbspace-' |
   '-TABLESPACE--partnum----------------------------------'
 
                                  .-,--------.
                                  V          |
>--+-----------------+--COSERVER----coserver-+-----------------><
   '-BATCHSIZE--size-'
 

Here the input variables have the following definitions:

• dbase specifies the name of the database where the table resides.
• owner specifies authorization identifier of the owner of the table.
• table specifies the name of the table to be repacked.
• dbspace specifies the name of a dbspace of table.
• partnum specifies the hexadecimal partition number of a tablespace.
• coserver specifies the name and coserver number of a coserver, in the format server.number, for number an unsigned integer.
• size specifies the number of rows that will be moved in each batch, for size an unsigned integer.

Only users informix and root can execute this command.

Here are examples of this command:

	onutil REPACK DATA IN TABLE stores_demo:customer
	onutil REPACK DATA IN TABLE db3:user5.tab1 BATCHSIZE 1000 COSERVER xps.2,xps.4
	onutil REPACK DATA IN TABLESPACE 0x50002

Because this onutil command completes execution before the table has been repacked, it prints a message suggesting that the user monitor the progress of the operation using the onstat -g pak command that is described below.