Interpreting resource information

Resource information is displayed in hexadecimal (28 digits). If multiple resource information items are specified, they are displayed consecutively in the order of their specification. If the resource information is fewer than 28 digits, the extra digits are zero-filled. All characters are in ASCII codes, and one byte is output as two digits.

Note: For the HP-UX, Solaris, and AIX editions of HiRDB, resource information is output in big endian format. For the Linux edition of HiRDB, resource information is output in little endian format.

The following figure shows a resource information output example (when the resource type is 0007).

Figure 8-11 Resource information output example (when the resource type is 0007)

[Figure]

Organization of this subsection: (1) Determining the RDAREA name from an RDAREA number; (2) Determining the index name from an index number; (3) Determining the table name (view table name) from a table number (view table number)

(1) Determining the RDAREA name from an RDAREA number

The following shows how to determine the RDAREA name from the RDAREA number that is output in the resource information.

Procedure

If the output information is in little endian format, convert it to big endian format. Suppose that 03000000 is output as the RDAREA number. Convert it to big endian format as shown in the following:

The RDAREA number becomes 3.
Because the RDAREA number that is output in the resource information is in hexadecimal, convert it to decimal.
Use the pddbls command to determine the RDAREA name that corresponds to the RDAREA number.

(2) Determining the index name from an index number

The following shows how to determine the index name from the index number that is output in the resource information.

Procedure

If the output information is in little endian format, convert it to the big endian format. Suppose that 0a010300 is output as the index number. Convert it to big endian format as shown in the following:

The index number becomes 3010a.
Because the index number that is output in the resource information is in hexadecimal, convert it to decimal.
Retrieve the INDEX_ID column of the SQL_INDEXES dictionary table and determine the index name that corresponds to the index number.
For details about how to retrieve the SQL_INDEXES dictionary table, see the HiRDB Version 9 UAP Development Guide.

(3) Determining the table name (view table name) from a table number (view table number)

The following shows how to determine the table name (view table name) from the table number (view table number) that is output in the resource information.

Procedure

If the output information is in little endian format, convert it to big endian format. Suppose that 7c000200 is output as the table number. Convert it to big endian format as shown in the following:

The table number becomes 2007c.
Because the table number (view table number) that is output in the resource information is in hexadecimal, convert it to decimal.
Retrieve the TABLE_ID column of the SQL_TABLES dictionary table and determine the table name (view table name) that corresponds to the table number (view table number).
For details about how to retrieve the SQL_TABLES dictionary table, see the HiRDB Version 9 UAP Development Guide.

8.6.5 Interpreting resource information

(1) Determining the RDAREA name from an RDAREA number

(2) Determining the index name from an index number

(3) Determining the table name (view table name) from a table number (view table number)