SQL/MP Installation and Management Guide

Enhancing Performance
HP NonStop SQL/MP Installation and Management Guide—523353-004
14-15
Deleting a Test Database
+> NONEMPTYBLOCKCOUNT = 2
+> WHERE TABLENAME = "\PHOENIX.$VOL.PERSNL.EMPLOYEE";
This example updates the DELIV_DATE column. To update the column statistics, you
must update each column.
>> UPDATE $VOL.PERSNL.COLUMNS
+> SET UNIQUEENTRYCOUNT = 11,
+> SECONDHIGHVALUE = 000000000000004000,
+> SECONDLOWVALUE = 000000000000001500
+> WHERE TABLENAME = "\PHOENIX.$VOL.PERSNL.EMPLOYEE" AND
+> COLNAME = "DEPTNUM";
After completing the update operations, do not forget to use the FUP REVOKE or
DELETE command on the =_SQL_CI2_sys DEFINE to stop using the licensed
SQLCI2 process.
After you have altered the statistics, you should be able to test most of the features of
queries and programs as if they were running on the real database. With this
technique, you cannot test certain locking features that require execution on large
tables if your test database does not have large tables. You should explicitly SQL
compile the programs to use the new statistics.
Deleting a Test Database
During the development and testing cycle, many test databases can be created on
your system. From time to time, you might need to purge obsolete databases or clean
up disk volumes. The SQL DROP statement and the SQLCI PURGE and CLEANUP
utilities can help you perform such operations.
You can use SQLCI PURGE to purge qualified file-set lists of objects to remove tables,
views, indexes, collations, and SQL programs stored in Guardian files. If a test
database is described in a single catalog, this combination of commands will remove
the objects and the empty catalog:
24> SQLCI
>> PURGE *.*.* FROM CATALOG $vol.testcat;
DO YOU WISH TO PURGE THE ENTIRE FILESET
*.*.* FROM CATALOG $vol.testcat
(Y[ES], N[O], S[ELECT], F[ILES]) ?y
TABLE \sys.$vol.testcat
1 OBJECT(S) PURGED
In the PURGE command, $vol.testcat is the name of a test catalog.
You can use DROP statements to drop individual objects from a catalog and then drop
the catalog. These set of statements demonstrates dropping objects and the catalog:
26> SQLCI
>> DROP PROGRAM $vol.objs.prog1;
>> DROP PROGRAM $vol1.objs.prog2;
.
.