onutil

Enterprise Edition Home | Express Edition Home | Previous Page | Next Page Summary of User Interface Enhancements > Command-Line Options >

onutil

XPS 8.51 introduces four new command-line options to the onutil utility:

Table 10. Examples that use new keywords of the **onutil** utility
New Keywords	Example
DISABLE_FILE_CLOSE_ OPTIMIZATION	Use `onutil SET DISABLE_FILE_CLOSE_OPTIMIZATION 1 COSERVER xps.2` to prevent certain files associated with tables in databases of coserver xps.2 from remaining open after DML operations on those tables are aborted.
DS_CLASSINFO	Use `onutil SET DS_CLASSINFO 'DEFAULT:30,50'` to reset the DEFAULT resource class attributes to have access to up to 30% of shared PDQ memory, and to allow up to 50 concurrent queries to use this resource class.
REPACK DATA IN TABLE IN TABLESPACE BATCHSIZE	Use `onutil REPACK DATA IN TABLE stores:'informix'.orders BATCHSIZE 800 COSERVER xps.2,xps.3` to begin consolidating the rows of the orders table on coservers xps.2 and xps.3, in batches of 800 rows.
REPACK_THREAD_MAX	Use `onutil SET REPACK_THREAD_MAX 0` to specify that no more than zero repack threads can run on the server. (This interrupts all currently executing repack threads, and prevents any new repack threads from starting).

For more information about the new feature that the SET DISABLE_FILE_CLOSE_OPTIMIZATION command supports, see Forcing DDL Execution.

For more information about the new feature that the SET DS_CLASSINFO command supports, see Allocating Memory Through Resource Classes.

For more information about the new feature that the REPACK DATA and SET REPACK_THREAD_MAX commands support, see Consolidating Table Storage Spaces Online.

In addition to these new onutil options, the onutil DISPLAY PAGE command can display bitmap pages in text format, rather than in the hexadecimal format to which Extended Parallel Server was restricted before Version 8.51:

Table 11. Examples of **onutil** commands to display the content of bitmap pages
Keywords	Example
DISPLAY PAGE IN TABLE	Use `onutil DISPLAY PAGE 0 IN TABLE gopi.gateleaf;` to display any bitmap on the first page of the gateleaf table.
DISPLAY PAGE IN INDEX	Use `onutil DISPLAY PAGE 2 IN INDEX lulu.idx_times;` to display any bitmap on the third page of the idx_times index.
DISPLAY PAGE IN TABLESPACE	Use `onutil DISPLAY PAGE 0xF IN TABLESPACE 0x10001;` to display any bitmap on page 15 in tblspace 1111.
DISPLAY PAGE	Use `onutil DISPLAY PAGE 1:2345;` to display information from the page whose offset is 2345 from the beginning of chunk 1. In this case of specifying a physical address, rather than a logical page number (like the previous examples provided), onutil can displays 4-bit bitmaps correctly, but not 2-bit bitmaps.

For more information about the new feature that the DISPLAY PAGE command supports, see Displaying Bitmap Pages.