SQL/MX 2.x Installation and Management Guide (H06.10+, J06.03+)

HP NonStop SQL/MX Installation and Management Guide—544536-007
11-1
11
Managing Database Applications
Managing an SQL/MX database includes supporting the operating requirements and
access requirements of application programs and maintaining valid application
programs. Providing this support and maintenance can include both
performance-related and operation tasks.
This section addresses these application management tasks:
•
Writing SQL/MX Applications to Recover From Temporary Network or Hardware
Service Interruptions on page 11-1
•
Moving Programs From Development to Production on page 11-3
•
Distributing Programs Across Nodes on page 11-8
•
Ensuring Proper Name Resolution on page 11-10
•
Maintaining Query Execution Plan Validity on page 11-13
•
Managing Modules on page 11-15
•
Backing Up and Restoring Programs on page 11-30
For information about migrating SQL applications from SQL/MX Release 1.8 to
SQL/MX Release2.x or between releases of SQL/MX Releases 2.x, see the SQL/MX
Database and Application Migration Guide.
Writing SQL/MX Applications to Recover From
Temporary Network or Hardware Service
Interruptions
This subsection describes how SQL/MX applications can be written to recover from
temporary network or hardware service interruptions.
The SQL/MX file system automatically retries certain hardware and network errors,
such as those that generate the Guardian errors 200, 201, and 211. Some errors are
retried continuously, whereas others are retried up to three times, as indicated by the
Nonstop Kernel message system.
In general, an SQL/MX application does not receive a Guardian error such as 200,
201, or 211 from NonStop SQL/MX when these conditions are transient and are
Note. If you use NonStop SQL/MX, you cannot mix SQL/MP statements and SQL/MX
statements in the same application. However, you can use SQL/MX statements in the same
application to query both SQL/MP and SQL/MX database objects. For more instructions, see
the SQL/MX Programming Manual for C and COBOL.