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

Database Management Tasks
Managing an SQL/MX database involves the tasks required to create the database, ensure its
availability to users, and perform required changes. Because the database is an integral part of
the application, measuring application performance and tuning the database configuration to
enhance performance are also database management tasks.
The tasks of SQL/MX database administrators (DBAs) include:
• Installing the SQL/MX software
• Upgrading to later releases of SQL/MX software or downgrade to earlier releases
• Determining database layouts and data dictionary plans
• Planning for database security, integrity, and recovery
• Creating and loading databases
• Querying catalog tables for information about databases
• Altering databases
• Managing databases and programs
• Reorganizing and moving databases
• Managing database applications
• Performing recovery operations
• Managing distributed databases
• Assembling and optimizing queries
• Measuring and enhancing performance
SQL/MX Database Management Tools
NonStop SQL/MX supports these types of SQL/MX statements:
Creates, deletes, or modifies the definition of a catalog, schema, or object, or the
authorization to use an object.
DDL
Queries and modifies database tables.DML
Specifies user-defined transactions and sets attributes for the next transaction.Transaction Control
Compiled once and then executed any number of times within the current session.Prepared SQL
Embedded in SQL programs written in C, C++, COBOL, or Java.Embedded-only SQL/MX
Locks or unlocks tables and their indexes to limit other accesses to the tables during DML
statement execution.
Resource Control and
Optimization
Regulates the execution default options, plans, and performance of DML statements.Control
Sets the value of the NAMETYPE attribute, which in turn determines whether object naming
is ANSI or Guardian for the current session.
Object Naming
Creates, alters, or deletes an SQL/MP alias for an SQL/MP table.SQL/MP alias
The SQL/MX extensions that typically affect attributes of an MXCI session.MXCI commands
Tools that run with NonStop SQL/MX or from the OSS shell and perform such tasks as
importing data, duplicating files, fixing database discrepancies, and migrating metadata.
SQL/MX utilities
SQL/MX statements, Guardian utilities, and SQL/MX utilities are the basic tools of the SQL/MX
database administrator. For more information, see the SQL/MX Reference Manual.
Database Management Tasks 27