SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

Contents
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
xvii
5. SQL/MX Utilities
Reuse an Existing Partition of a Range Partitioned Table 5-77
Manage Partitions of Range Partitioned Tables and Indexes 5-79
Manage Partitions of Hash Partitioned Tables and Indexes 5-85
Manage System-Clustered Tables 5-90
Renaming Guardian Location of Partitions of Tables, or Indexes 5-92
Considerations for MODIFY 5-93
Examples of MODIFY 5-99
mxexportddl Utility 5-101
Considerations for mxexportddl 5-104
Examples of mxexportddl 5-104
MXGNAMES Utility 5-105
Considerations for MXGNAMES 5-107
Examples of MXGNAMES 5-107
mximportddl Utility 5-113
Considerations for mximportddl 5-119
Examples of mximportddl 5-120
MXRPM tool 5-121
Guidelines for map file 5-122
Guidelines for module-list-input-file 5-122
Guidelines for log-file 5-122
Considerations 5-123
mxtool Utility 5-124
POPULATE INDEX Utility 5-125
Syntax Description of POPULATE INDEX 5-125
Considerations for POPULATE INDEX 5-126
Examples of POPULATE INDEX 5-127
PURGEDATA Utility
5-128
Syntax Description of PURGEDATA 5-128
Considerations for PURGEDATA 5-130
Examples of PURGEDATA
5-131
RECOVER Utility
5-132
Syntax Description of RECOVER 5-132
Considerations for RECOVER
5-133
Examples of RECOVER
5-133
RECOVER SCHEMA Operation
5-133
Considerations for RECOVER SCHEMA
5-134
Examples of RECOVER SCHEMA 5-134
UPGRADE Utility
5-135
Considerations for UPGRADE 5-136