NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
B-1
B
BACKUP Utility
BACKUP is a Guardian utility program, executed from TACL, that copies Guardian
files and SQL objects from disk to magnetic tape. (A complementary utility program,
RESTORE, copies Guardian files and SQL objects from magnetic tape to disk.)
See the Guardian Disk and Tape Utilities Reference Manual for more information about
BACKUP.
BASETABS Table
The BASETABS table is a catalog table that describes attributes that apply to tables, but
not to views. The following table describes the contents of the BASETABS table.
The BASETABS table was created in version 1, and there have been no changes in
subsequent versions.
If a table is partitioned, the BASETABS table has one entry for each partition.
Guardian names in the BASETABS table are fully qualified and use uppercase
characters.
Column Name Data Type Description
1 TABLENAME CHAR (34) Name of table (primary key)
2 CONSTRAINTS CHAR (1) Y if table has constraints
N if no constraints
3
ALLINDEXESHERE
CHAR (1)
Y if all indexes for table are described in
the same catalog
N if some indexes are described in other
catalogs
4 FILENAME CHAR (34) Name of file for table
5 STATISTICSTIME LARGEINT
SIGNED
Time when statistics for table were last
updated, in local civil time.
6 ROWCOUNT LARGEINT
SIGNED
Number of rows in table or partition of
table identified by TABLENAME (updated
by UPDATE STATISTICS)
7 ROWSIZE SMALLINT
UNSIGNED
Maximum byte length of a row of the table
on disk (packed record length)
8 VALIDDEF CHAR (1) Y if file has a valid definition, correct file
label, and catalog entries
N if not
9 VALIDDATA CHAR (1) Y if data in table is consistent with data in
indexes and satisfies constraints on table
N if not