SQL/MP Programming Manual for COBOL

Maximizing Local Autonomy
HP NonStop SQL/MP Programming Manual for COBOL—529758-003
C-3
Skipping Unavailable Partitions
your query does not try to retrieve any rows from the unavailable partition. Executing
the UPDATE STATISTICS statement can eliminate both these problems.
Skipping Unavailable Partitions
Use the SKIP UNAVAILABLE PARTITION option of the CONTROL TABLE directive to
cause SQL/MP to skip a partition that is not available and to open the next available
partition that satisfies the search condition of a query. (SQL/MP also returns warning
message 8239 to the SQLCA structure.) The SKIP UNAVAILABLE PARTITION option
applies to static or dynamic SQL statements that refer to partitioned tables and
partitioned indexes of the tables.