SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
2-305
Examples of POPULATE INDEX
initial and the data movement phases are retried individually and may include retry
counts.
•
Errors can occur if the source base table or target index cannot be accessed, or if
the load fails due to some resource problem or problem in the file system.
•
POPULATE INDEX does not work with SQL/MP alias names.
•
POPULATE INDEX need sufficient memory to copy the table and to create the
index respectively.
•
POPULATE INDEX records the status in the DDL_LOCKS metadata table. You can
query this table to determine the progress of POPULATE INDEX operation.
Examples of POPULATE INDEX
•
This example loads the specified index from the specified table:
POPULATE INDEX myindex ON mycat.myschema.mytable;
•
This example loads the specified index from the specified table, which uses the
default catalog and schema:
POPULATE INDEX index2 ON table2;
•
This is an example for online operation which loads the specified index from the
specified table, and uses the default catalog and schema:
POPULATE INDEX index2 ON table2 with-shared-access;
COMMIT BEFORE '2007-04-05 16:25:40'
ONCOMMITERROR COMMIT WORK AFTER '2007-04-05 25:19:00';
Status Description
1 The DDL Lock row is created.
3 File Labels of index are updated.
4 Load of index has started.
5 Load of index has completed.
7 Index is online. POPULATE INDEX operation has completed.