RDF/IMP and IMPX System Management Manual (RDF 1.3+)

Maintaining the Databases
Compaq NonStop™ RDF/IMP and IMPX System Management Manual—522204-001
6-7
SQL/MP Databases
physically present in the index on the backup system, SQL/MP does not see them
because the actual key specifier value does not match the expected one. Consequently, a
FUP INFO <index>, STAT display will show the correct number of records for the
index, but a SQLCI SELECT COUNT (*) FROM <index> command will return fewer
rows for the index than indicated by the FUP INFO command. The row count continues
to grow in the base table, but remains the same for the index.
You can avoid this problem by always using the KEYTAG clause in the CREATE
INDEX command to define a meaningful key specifier for each index you create.
If you encounter the problem described above, use SQLCI to DROP and re-CREATE the
offending indexes, doing so in the proper creation order. The following annotated output
illustrates the necessary index creation order:
>SQLCI FILEINFO $DATA.RDFSQL.MASTER, DETAIL
$DATA.RDFSQL.MASTER
SQL BASE TABLE
CATALOG $DATA.RDFSQL
VERSION 2
TYPE K
EXT ( 16 PAGES, 64 PAGES, MAXEXTENTS 160 )
REC 416
PACKED REC 415
BLOCK 4096
KEY ( COLUMN 0, OFFSET 0, LENGTH 4, ASC )
INDEX ( 1, $DATA.RDFSQL.MASTXYZ, <<create this index first
COLUMN 18, OFFSET 54, LENGTH 2, ASC.
COLUMN 19, OFFSET 56, LENGTH 2, ASC.
NOT UNIQUE )
INDEX ( 2, $DATA.RDFSQL.MASTABC, <<create this index second
COLUMN 88, OFFSET 300, LENGTH 15, ASC.
COLUMN 87, OFFSET 285, LENGTH 15, ASC.
NOT UNIQUE )
AUDIT
BUFFERED
AUDITCOMPRESS
SECURITY (RWEP); NCNC
MODIF: 27 Dec 1997, 20:01
CREATION DATE: 02 Dec 1997, 12:37
REDEFINITION DATE: 10 Jan 1998, 14:46
LAST OPEN: 10 Jan 1998, 14:46
EOF 466944 (2.2% USED)
EXTENTS ALLOCATED: 160
INDEX LEVELS: 1
PARTITION ARRAY STANDARD