SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

ManualsBrandsHP ManualsServerHP NonStop G-Series

201

202

203

204

205

206

207

208

209

210

SQL/MX Statements

HP NonStop SQL/MX Reference Manual—523725-004

2-125

Considerations for DROP SCHEMA

In the Guardian environment, update through the SCF facility:

SCF

1-> info $<volume>,detail

STORAGE - Detailed Information Magnetic DISK

\<node>.$<volume> Common Disk Configuration Information:

*BackupCpu............................. 3

*HighPin............................... ON

*PrimaryCpu............................ 2

*Program...............................$SYSTEM.SYSTEM.TSYSDP2

*StartState............................ STARTED

Disk Type Specific Information:

*AuditTrailBuffer/SQLMXBuffer (MB)..... 0

*AutoRevive............................ OFF

*AutoSelect............................ n/a

*AutoStart............................. ON

*CBPoolLen............................. 1000

*FSTCaching............................ OFF

*FullCheckpoints....................... ENABLED

*HaltOnError........................... 1

*LKIDLongPoolLen....................... 8

*LKTableSpaceLen....................... 15

*MaxLocksPerOCB........................ 5000

*MaxLocksPerTCB........................ 5000

*NonAuditedInsert...................... OFF

More text? ([Y],N) n

2-> alter $volume,maxlockspertcb 10000

3-> info $volume,detail

STORAGE - Detailed Information Magnetic DISK \node.$volume

Common Disk Configuration Information: