SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

Reviewing and Setting System Defaults
HP NonStop SQL/MX Installation and Management Guide—523723-004
6-4
New System Defaults for Release 2.0
NOT_NULL_CONSTRAINT_
DROPPABLE_OPTION
Default for DROPPABLE (ON) or NOT DROPPABLE for
NOT NULL constraint.
PM_OFFLINE_TRANSACTION_
GRANULARITY
Number of rows that are copied in an offline MODIFY
transaction.
PM_ONLINE_TRANSACTION_
GRANULARITY
Number of rows that are copied in an online MODIFY
transaction.
POS_LOCATIONS Physical locations of nonprimary hash partitions to be
automatically created, specified as [\node.]$volume.
You can specify multiple locations separated by
commas. If you enter a space (“ “), NonStop SQL/MX
chooses the locations of the second through last
partitions at random. NonStop SQL/MX does not place
partitions on these types of disks: audit trail volumes,
nonaudited disks, optical disks, phantom disks, SMS
virtual disks, and disks with names that are seven
characters long (for example, $CHAR777).
The default is no specification.
POS_NUM_OF_PARTNS Number of hash partitions to be automatically created. If
the value is greater than 1, NonStop SQL/MX creates
that many partitions, including the primary partition. A
value of 1 or 0 indicates that Partition Overlay Support
(POS) is disabled.
The default is 1.
POS_RAISE_ERROR Determines whether an error should be raised when the
POS feature cannot generate location names for the
partitions to be created, or if a warning should be raised
indicating that POS feature was not applied, and a
simple table is created without partitions. When set to 0
(the default value), a warning indicates that POS is not
applied, and a simple table is created without partitions.
When set to 1, an error indicates that location names
should not be generated.
The default is 0.
PRESERVE_MIN_SCALE Allows you to preserve minimum scale when the
resultant value of an arithmetic operation exceeds the
allowed numeric limit.
PRIMARY_KEY_CONSTRAINT_
DROPPABLE_OPTION
Default for DROPPABLE (ON) or NOT DROPPABLE for
PRIMARY KEY constraint.
REF_CONSTRAINT_NO_
ACTION_LIKE_RESTRICT
Controls how NonStop SQL/MX handles referential
action in ALTER TABLE and CREATE TABLE
statements.
SAVE_DROPPED_TABLE_
DDL
Controls whether definitions of dropped tables are saved
to enable them to be recovered.
Table 6-1. New System Defaults for Release 2.0 (page 2 of 3)
Default Description