SQL/MP Installation and Management Guide

Contents

HP NonStop SQL/MP Installation and Management Guide—523353-004

C. Format 2 Partitions

Planning for SQL Format 2-Enabled Tables and Format 2 Partitions C-1

General Planning Considerations C-5

Operational Considerations for SQL

Format 2-Enabled Table Use C-7

Fallback Considerations C-8

Fallback Scenario 1 C-8

Fallback Scenario 2 C-8

Fallback Scenario 3 C-9

Interoperability Considerations C-12

Third-Party Provider Considerations C-13

Index

Figures

Figure 1-1. Typical Use of the Data Dictionary 1-4

Figure 3-1. Key-Sequenced B-Tree Structure 3-8

Figure 3-2. Entry-Sequenced File Structure 3-10

Figure 3-3. Relative File Structure 3-11

Figure 5-1. Catalog Structure 5-3

Figure 5-2. Ordering Columns Within an Index 5-44

Figure 10-1. Name Resolution For SQL Statements 10-14

Figure 13-1. Measure Entities and Program Structures 13-6

Figure 14-1. Generic Locking Example 14-22

Figure C-1. Migration and Fallback Planning, G06.03 Through G06.12 C-2

Figure C-2. Migration and Fallback Planning, G06.03 and Earlier RVUs C-3

Figure C-3.

Migration and Fallback Planning, pre G06.03 RVU C-4

Tables

Table 1-1. SQL/MP Statements and Commands for Database Management 1-11

Table 1-2. NonStop Tools for Database Management 1-14

Table 4-1. Authorization Requirements 4-6

Table 5-1. Summary of Corresponding Data Types 5-29

Table 10-1. Behavior of the SQL Executor for an Invalid Statement or a Changed

DEFINE Detected at SQL Load Time 10-20

Table 10-2. Behavior of the SQL Executor for an Invalid Statement Detected After

Load Time 10-22

Table 11-1. SQL/MP Operations That Invalidate TMF Online Dumps 11-16