Availability Guide for Application Design

Designing Applications for Change
Availability Guide for Application Design—525637-004
10-34
Installing a New Program Version
Installing a New Program Version
The NonStop SQL/MP product allows changes to SQL programs while minimizing the
downtime required to bring the new program version online. The new program version
is either installed with the REGISTERONLY ON option, or compiled with the
NOREGISTER ON option.
Figure 10-5. Increasing Application Availability Through Dynamic Name
Resolution
Develop the program using
static SQL and execution-
time name resolution using
CONTROL QUERY BIND
NAMES AT EXECUTION
Set DEFINE to reference
Table T
Enable the similarity check
for the table using ALTER
TABLE
Compile the program with
SQL
using CHECK INOPERABLE
PLANS
Begin transaction
Change DEFINE to
refer to desired table
Execute static SQL
statement
(No automatic recompilation
if similarity check passes)
End transaction
Execute the
program
Development System
Production System
Table T
Table T1
Table T2
Table Tn
. . .
VST905.vdd