DISPLAY PAGE

>>-DISPLAY PAGE--+-pagenum--| TABLE |--------------+------------>
                 +-pagenum--IN TABLESPACE--partnum-+
                 +-chunk_number--:--offset---------+
                 '-pagenum--| INDEX |--------------'

>--+------------------------------------------------+----------><
   | .----------------.                             |
   | V                |                             |
   '---+------------+-+--+------------------------+-'
       +-COUNT--nbr-+    '-SAVE--+--------------+-'
       +-HEADER-----+            '-IN--filename-'
       '-HEX--------'

TABLE:

|--IN TABLE--database--:--+----------+--table_name-------------->
                          '-owner--.-'

>--+-----------------+------------------------------------------|
   '-,--dbspace_name-'

INDEX:

|--IN INDEX--database--#--+----------+--index_name-------------->
                          '-owner--.-'

>--+-----------------+------------------------------------------|
   '-,--dbspace_name-'

Element	Purpose	Restrictions	Syntax
pagenum	An integer value that you use to indicate a particular page in a tblspace	Value must be an unsigned integer between 0 and 16,777,215, inclusive.	Unsigned integer.
partnum	The tblspace number that you want to display	Value must be an integer between 0 and 208,666,624, inclusive.	Unsigned integer.
chunk_ number	The number of the chunk that you want to display	The chunk number must exist.	Unsigned integer.
offset	The number of pages into the chunk where you want to start the display		Unsigned integer.
nbr	The number of pages that you want to display		Unsigned integer.
filename	The filename that you want to contain the output of the onutil command.
database	The name of the database where the table resides	The database must exist. You cannot check databases on remote database servers.	See the IBM Informix: Guide to SQL Syntax.
owner	The name of the owner of a table	Owner that you specify must be current owner of table. Owner is mandatory for ANSI databases.	The user name must conform to the conventions of your operating system.
dbspace_name	The name of the dbspace where the page resides	The dbspace must exist.	See Dbspace Name.
table_name	The name of the table that you want to display	Table must exist.	See Identifiers in onutil Commands.
index_name	The name of the index that you want to display	The index must exist.	See Object Name in the IBM Informix: Guide to SQL Syntax.

The onutil DISPLAY PAGE and DISPLAY PAGE IN TABLESPACE commands display the contents of a single page on the terminal.

You use the onutil DISPLAY PAGE pagenum IN TABLESPACE or onutil DISPLAY PAGE chunk_number:offset command in offline mode.

The DISPLAY PAGE command, when run without the HEX keyword, displays the page header whether it recognizes the page type. It attempts to display the body of the page in the appropriate format. If it does not recognize the page type, it does not print anything after the header. Use the HEX keyword to display the entire page in hexadecimal format with an ascii translation of each byte on the right side.

The following example shows the onutil DISPLAY PAGE command to display page information in tblspace 1111:

% onutil
1> DISPLAY PAGE 0xF IN TABLESPACE 0x10001;

You can use the onutil DISPLAY PAGE and DISPLAY PAGE IN TABLESPACE commands in offline mode. You must specify a local single coserver name, as in the following example:

% onutil
1> DISPLAY PAGE 5:4 COSERVER eds.3;

DISPLAY PAGE

Syntax

Usage