Viewing table partition properties – HP Integrity NonStop J-Series User Manual
Page 56
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.
56
Viewing database objects