SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—540440-003
5-73
POPULATE INDEX Utility
POPULATE INDEX Utility
Considerations for POPULATE INDEX
Examples of POPULATE INDEX
POPULATE INDEX is a syntax-based utility that can be executed through MXCI. The
POPULATE INDEX utility loads SQL/MX indexes.
Syntax Description of POPULATE INDEX
index-name
is the name of the index to populate.
An error is returned if index-name cannot be found.
[[catalog.]schema.]table-name
is the name of the base table that owns the index. You can specify delimited or
regular identifiers. If you do not specify the catalog and schema parts of the
table-name, POPULATE INDEX uses the default catalog and schema values for
that session. POPULATE INDEX returns errors if the catalog name does not exist,
if the schema name is invalid, if the table name does not exist, or if the object
name specifies an invalid table such as views and SQL/MP aliases.
Considerations for POPULATE INDEX
•
You must be the super ID, the schema owner, or have ALL privileges on the table.
•
If the remote node is visible to the local node, the table and index can be defined
on a remote node. Partitions of the table and or index can also reside on remote
nodes that are visible to the current node.
•
POPULATE INDEX does not check disk space before running the request. You
must confirm that enough disk space is available before running the request.
•
MAXEXTENTS is automatically increased to handle the data.
•
POPULATE INDEX returns an error if the index is partially populated. An index is
partially populated if a previous POPULATE INDEX command failed before
completion. You need to run RECOVER to correct this failure. See RECOVER
Utility on page 5-80.
•
If POPULATE INDEX fails in response to a process, CPU, or system error, you can
use the RECOVER utility to recover the operation. If the operation fails after the
index has been successfully loaded, specify RECOVER with the RESUME option to
complete the operation. If the operation fails before the index is successfully
loaded, specify RECOVER with the CANCEL option to roll back the operation. If you
POPULATE INDEX index-name ON
[[catalog.]schema.]table-name