NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
P-20
PARTNS Table
•
You can partition tables of any file organization but you cannot partition a key-
sequenced table that has a system-defined primary key (as opposed to a user-defined
primary key) unless it also has a clustering key.
•
For relative and entry-sequenced tables, SQL determines the set of rows in a
partition, depending on the size of the partitions and the size of the rows. For key-
sequenced tables and for indexes, you specify the set of rows in each partition with
the FIRST KEY clause of the PARTITION clause.
PARTNS Table
The PARTNS table is a catalog table that describes the partitions of a table. The
following table describes the contents of the PARTNS table.
The PARTNS table was created in version 1. There have been no subsequent changes.
A partitioned table has a primary partition (the first partition of the table) and one or
more secondary partitions. Each partition has the same subvolume and object name, but
a different node or volume name than every other partition of the table (because each
partition resides on a different node or volume than every other partition of the table).
Each partition must be registered in a catalog on the node on which that partition
resides. For each partition registered in a catalog (the FILENAME column of the
PARTNS table), the PARTNS table for that catalog contains one entry for each partition
of the table (the PARTITIONNAME column of the PARTNS table). You can register all
partitions of a table on a node in a single catalog if you want, or put them in separate
catalogs.
Values in FIRSTKEY are in ASCII format, separated by commas. For example, a key
composed of a character and an integer column might have a FIRSTKEY value such as:
“A”,1234.
Guardian names in the PARTNS table are fully qualified and use uppercase characters.
PERUSE Command
PERUSE is an SQLCI command that invokes the Guardian PERUSE program. PERUSE
lets you examine and change the attributes of your spooled jobs as well as monitor such
Column Name Data Type Description
1 FILENAME* CHAR (34) Name of this partition
2 PRIMARYPARTITION * CHAR (1) Y if primary partition
N if secondary partition
3 PARTITIONNAME* CHAR (34) Name of another partition of the table
4 CATALOGNAME CHAR (25) Name of catalog in which partition is
registered
5 FIRSTKEY VARCHAR
(3000)
Starting values for each column in primary key
* Indicates primary key