beautypg.com

Viewing table partition properties – HP Integrity NonStop J-Series User Manual

Page 57

background image

2.

In the right pane, click Attributes.

The following details appear:

Name: — The name of the table.

Metadata UID: — The internal UID number of the table.

Log Inserts Only: — A string value of True or False.

Reorganize Enabled: — A string value of True or False.

Update Statistics Enabled: — A string value of True or False.

Last Updated Statistics: — A string value of Never or a timestamp in the yyyy-MM-dd
HH:mm:ss.FFFFFF

format.

Audit Compressed: — The property indicates whether the compressed audit-checkpoint
messages are generated for Disk Process 2 (DP2) files. It is expressed as True or False.

Clear On Purge: — The property indicates the disk erasure when the file is dropped. It is
expressed as True or False.

Block Size: — The length of a block.

Maximum Size: — The maximum size, expressed in megabytes, to which a table can
grow. If the maximum size is 0, then the string Determined by system appears.

Record Size: — The row size, expressed in bytes, in each logical record.

Creation Time: — The time and date when a table was created. The time and date are
expressed in the yyyy-MM-dd HH:mm:ss.FFFFFF format.

Redefinition Time: — The time and date when a table was last redefined. The time and
date are expressed in the yyyy-MM-dd HH:mm:ss.FFFFFF format.

Viewing table partition properties

To view the partition properties:
1.

In the navigation tree, select the table.

Viewing table properties

57

This manual is related to the following products: