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

Using GOAWAY to Delete Damaged Objects..........................................................................263
Recovering From SCF Commands...........................................................................................263
ABORT DISK...................................................................................................................263
ALTER DISK, ALTNAME and ALTER DISK, VOLNAME............................................................264
ALTER DISK, LABEL...........................................................................................................264
INITIALIZE DISK...............................................................................................................265
START DISK and STOP DISK..............................................................................................265
11 Managing an SQL/MX Distributed Database............................................266
Managing a Locally Distributed SQL/MX Database..................................................................266
Managing a Network-Distributed SQL/MX Database................................................................267
SQL/MX Distributed Database Features..............................................................................267
Naming Network Nodes..................................................................................................270
Naming SQL/MX Database Objects..................................................................................270
Using Catalog References in an SQL/MX Distributed Database..............................................271
Managing Network Security..............................................................................................274
Maintaining Local Autonomy in a Network for SQL/MX Release 3.x.......................................274
Creating a Distributed SQL/MX Database...............................................................................278
Creating, Registering, and Unregistering Catalog References.................................................278
Distributing SQL/MX Database Objects..............................................................................279
Altering Distributed Objects...................................................................................................280
Dropping Distributed Objects.................................................................................................280
Enhancing the Performance of a Distributed Database...............................................................280
Using Co-located Indexes in a Distributed Database.............................................................281
Using Remote Application Processes...................................................................................281
Changing Network Environments............................................................................................281
Managing Mixed Versions of NonStop SQL/MX......................................................................282
12 Measuring Performance.........................................................................284
SQL/MX Tools for Gathering Statistics.....................................................................................284
SHOWLABEL Command...................................................................................................284
SET STATISTICS and DISPLAY STATISTICS Commands............................................................286
Measure Performance Measurement Tool.................................................................................287
Statistics and Reports for NonStop SQL/MX........................................................................288
SQL/MX Measurement Models..........................................................................................290
13 Enhancing SQL/MX Database Performance..............................................293
Using Queries in an SQL/MX Database..................................................................................293
Understanding the Implications of Concurrency.........................................................................293
Minimizing Contention.....................................................................................................295
Avoiding Contention Between DDL or Utility Operations........................................................296
Other Operational Considerations.....................................................................................296
Keeping Statistics Current.......................................................................................................297
Managing SQL/MX Buffer Space...........................................................................................297
How DP2 Manages and Reuses Query Plan Fragments.........................................................298
Causes and Symptoms of Query Plan Fragment Reuse Failures...............................................299
Reduction of Plan Fragment Size for Unique Queries.............................................................299
Using SCF STATS DISK to Monitor SQL/MX Statistics and Reuse Failures.................................299
Using SCF ALTER DISK to Resize the SQLMXBUFFER Attribute................................................302
Strategies for Reducing Reuse Failures.................................................................................302
Managing DP2 Data Cache Memory Size...............................................................................303
Maximizing Disk Process Prefetch Capabilities..........................................................................304
Optimizing SQL/MX Memory Management.............................................................................304
Optimizing Index Use...........................................................................................................305
Maximizing Parallel Index Maintenance..............................................................................305
Using Co-located Indexes.................................................................................................305
10 Contents