SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
R-4
Examples—REPORT Option
option does not specify an EMS collector, messages go to $0, the default EMS
collector.
CREATE INDEX $DK.REG1.IREL2 ON $DK.APPL.RECORDS(COL1, COL6)
WITH SHARED ACCESS NAME CREATE_INDEX_IREL2
REPORT ON
COMMIT WHEN READY
ONCOMMITERROR COMMIT BY REQUEST;

The sample report in Example R-1 is produced from EMS messages sent by the
operation started with the CREATE INDEX statement in the previous example. The
actual report also includes the date and time to the left of the process identification
that begins each messages, but the date and time columns are not shown here
because of the width of the report.
Example R-1. Report Example (page 1 of 2)
\SQ.3,49 TANDEM.SQL.D30 000001
CREATE_INDEX_IREL2 command started
\SA.3,49 TANDEM.SQL.D30 000002 Target
\SA.DK.REG1.IREL2 created
\SA.3,49 TANDEM.SQL.D30 000003 All target
partitions have been created
Time to create targets: 0 secs
\SA.$X314 TANDEM.SQLAUDIT.D30 000002 ** Audit Fixup
Status **
Time since last status: 0 secs
Distance to audit EOF : ? kbytes
Records read : 0 recs
Records redone : 0 recs
Read rate : 0 bytes/sec
Redo rate : 0 bytes/sec
Progress rate : ? bytes/sec
\SA.3,49 TANDEM.SQLAUDIT.D30 000001 Audit Fixup
Initialized
Time to perform initialization: 6 secs
\SA.3,49 TANDEM.SQL.D30 000004 Data Copy
Started
\SA.3,49 TANDEM.SQL.D30 000006 Data Copy
Completed
Time since last status: 6 secs
\SA.3,49 TANDEM.SQL.D30 000007 Online dump
allowed for \SA.DK.REG1.IREL2
\SA.3,49 TANDEM.SQLAUDIT.D30 000003 Audit Fixup 1
started
\SA.3,49 TANDEM.SQLAUDIT.D30 000004 Audit Fixup 1
completed
Duration: 2 secs
\SA.3,49 TANDEM.SQLAUDIT.D30 000003 Audit Fixup 2
started
\SA.3,49 TANDEM.SQLAUDIT.D30 000004 Audit Fixup 2
completed
Duration: 2 secs
\SA.3,49 TANDEM.SQL.D30 000017
CREATE_INDEX_IREL2 command returning to
caller
SQLCODE returned: 1618
Message Text:
- WARNING from SQL [1618]: The
CREATE_INDEX_IREL2 statement is ready to
- commit.