SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
U-11
UPGRADE CATALOG Command

This example updates statistics for columns in the primary key or in indexes for a
table named STUDENTS, directing SQL to calculate the statistics based on the
contents of the first 300 blocks in each partition:
UPDATE STATISTICS FOR TABLE STUDENTS SAMPLE 300 BLOCKS;
UPGRADE CATALOG Command
UPGRADE CATALOG is an SQLCI utility command that converts catalogs to a newer
version so the catalogs can register objects associated with a newer version of the
SQL/MP software.
catalogs
specifies the catalogs to upgrade. It can be a single catalog name, a type
CATALOG DEFINE name, or a name that specifies multiple catalogs by including
these wild-card characters:
For example, these names specify multiple catalogs:
Catalogs specified by catalogs can be either local or remote, but cannot be
system catalogs. (Use UPGRADE SYSTEM CATALOG to convert a system
catalog.)
The default is the current default catalog.
If SMF is installed on your node, catalogs cannot specify any catalog on a
$*.ZYS*. subvolume.
TO version
specifies the catalog format version for the upgraded catalog.
You can express version as an integer (2, 300, 310, 315, 320, 325, or 330) or as
a string (A011, A300, A310, A315, A320, A325, or A330), but the version you
UPGRADE CATALOG[S] [ catalogs ] [ TO version ] ;
? matches any single character
* matches 0 to 8 characters
MYCAT? matches MYCAT1, MYCAT2, and MYCATX (and possibly others),
but not MYCAT48
$DATA.* matches all catalogs on volume $DATA
=APPCAT matches the catalog specified by the =APPCAT DEFINE
(MYCAT?,
=APPCAT)
matches MYCAT1, MYCAT2, MYCATX, (and possibly others) and
the catalog specified by =APPCAT
$*.* matches all catalogs on the current default node except the system
catalog