SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
S-79
Considerations—SMF
Considerations—SMF

Most SQL CREATE and ALTER statements have either syntax changes or
considerations for SMF. Syntax changes consist of a new option, PHYSVOL, which
allows you to place an SQL object on a particular physical volume associated with
the specified virtual volume. Some SQL/MP utility commands are also affected, as
are temporary table and file placement.
See also:

On physical volumes, subvolumes named ZYS* are reserved for SMF. Do not
attempt to create objects or files on subvolumes named in this format.

If you specify a logical file name in a FILEINFO, DETAIL command, the
corresponding physical file name is displayed. Similarly, if you execute FILEINFO,
DETAIL for a physical file, its corresponding logical name is displayed.
ALTER CATALOG Statement DROP SYSTEM CATALOG Command
ALTER COLLATION Statement DUP Command
ALTER INDEX Statement FILEINFO Command
ALTER PROGRAM Statement FILENAMES Command
ALTER TABLE Statement GOAWAY Command
ALTER VIEW Statement INVOKE Directive and Command
CLEANUP Command LOAD Command
CONVERT Command Parallel Index Loading
COPY Command PARTITION Clause
CREATE CATALOG Statement PURGE Command
CREATE COLLATION Statement PURGEDATA Command
CREATE CONSTRAINT Statement Qualified Fileset List
CREATE INDEX Statement SECURE Command
CREATE SYSTEM CATALOG
Command
Temporary Tables
CREATE TABLE Statement UPGRADE CATALOG Command
CREATE VIEW Statement VERIFY Command
DISPLAY USE OF Command =_SORT_DEFAULTS DEFINE
DOWNGRADE CATALOG Command =_SQL_EXE_USE_SWAPVOL DEFINE
DROP Statement =_SQL_TM_node_vol DEFINE