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

Related SQL/MP Manuals
Describes the SQL/MP language elements,
expressions, predicates, functions, and statements.
SQL/MP Reference Manual
Describes how to plan, install, create, and
manage an SQL/MP database. Describes
SQL/MP Installation and Management Guide
installation and management commands and
SQL/MP catalogs and files.
New and Changed Information
This manual (691120–002) includes the following changes:
• Updated the following tables to include sequence generator object type:
Table 2 (page 24)◦
◦ Table 5 (page 62)
◦ Table 8 (page 150)
◦ Table 9 (page 151)
◦ Table 10 (page 162)
◦ Table 11 (page 163)
◦ Table 12 (page 169)
◦ Table 13 (page 169)
• Updated the “Backing Up Catalogs” (page 64) section and added a Note.
• Added the “Sequence Generator” (page 65) section to “SQL/MX Objects Backed Up Implicitly”
(page 65).
• Updated the “Access Privileges for SQL/MX Database Objects” (page 79) section.
• Added the “Creating Sequence Generators” (page 102) section.
• Added the “Displaying Information About Sequence Generators” (page 147) section.
• Added the “Adding Sequence Generators” (page 159) section.
• Added the “Altering Sequence Generators” (page 167) section.
• Added the “Dropping Sequence Generators” (page 174) section.
• Added the “Using MODIFY to Change the Location of a Sequence Generator” (page 193)
section.
Document Organization
Provides an introduction to managing an SQL/MX
database.
“Introduction to SQL/MX Database Management”
(page 18)
Presents conceptual information about SQL/MX tables and
describes how to plan for them.
“Understanding and Planning SQL/MX Tables” (page 29)
Describes security and planning.“Planning Database Security and Recovery” (page 42)
Describes system defaults.“Reviewing and Setting System Defaults” (page 68)
Describes how to create an SQL/MX database.“Creating an SQL/MX Database” (page 73)
Describes how to query SQL/MX metadata.“Querying SQL/MX Metadata” (page 105)
14