The Database Startup and Termination tools are used to view and update the database parameters file and VM storage pool specifications file for a given database; view the database startup parameters used during the last startup of a database; and to start and stop database operation.
Before continuing, you should review these topics:
Shown in Figure 86 is the option selection panel of the Database Parameters tool. It is reached by selecting P - Database Parameters on the Main Menu. The communication path can be changed using Option C from the Control Center Main Menu, whereas the database setting can be changed on this panel. For more information, see Control Center Communication Path and Database Settings.
Figure 86. Database Parameters Selection Panel
+--------------------------------------------------------------------------------+ | mm/dd/yyyy CONTROL CENTER hh:mm:ss | | *--------------------------- Database Parameters ---------------------------* | | | Option ===> CTRLID: MSTRSRV1 | | | | Database ===> SQLDBA NODE: VMSYSTM1 | | | | | | | | | | | | V VIEW View database parameters | | | | | | | | U UPDATE Update database parameters | | | | | | | | S STARTUP Display startup parameters used | | | | during last database startup | | | | | | | | VS VIEW SPECS View Storage Pool Specifications File | | | | (VMDSS Support) | | | | | | | | US UPDATE SPECS Update Storage Pool Specifications File | | | | (VMDSS Support) | | | | | | | | Enter OPTION, select DATABASE, press ENTER to process | | | | | | | *---------------------------------------------------------------SQMDPARM----* | | PF: 1 Help 3 End | | | +--------------------------------------------------------------------------------+
Control Center maintains a set of database startup and control parameters for each database machine it manages. Parameters for each database are saved in separate files named database PARMS, where database is the database machine ID, and are kept on the service machine's 191 A-disk. Database parameters are separated into the groups listed below:
Initially, parameter values are established during the DB2 Server for VM database installation process. Afterwards, they can be updated using the UPDATE U option. Several parameters are updated automatically by Control Center during normal operation and under most circumstances should not be updated manually.
Parameters can be viewed and updated at any time; however, most of the parameters updated will not take effect until the next database startup. The parameters used during the last database startup are available for viewing at any time using the STARTUP S option.
Control Center maintains a set of storage pool specifications for each database machine it manages which allows you to control the DB2 VM Data Spaces feature at the individual storage pool level. Specifications for each database are saved in separate files named "database ARISPOOL", where database is the database machine ID, and are kept on the service machine's 191 A-disk.
Three VMDSS specifications can be specified for storage pools:
Initially, when Control Center creates the storage pool specification file, it uses the information provided by the SHOW POOL operator command to determine the proper settings. Afterwards, they can be updated using the UPDATE SPECS US option.
These settings can also be changed dynamically while the database is running by issuing specific database operator commands. Dynamic changes, however, do not change the settings in the database's storage pool specifications file, the file used at database startup time.
For more information on the VMDSS, refer to the DB2 Server for VSE & VM Performance Tuning Handbook manual.
Select this option to view the current parameter settings saved in the database parameters file.
The display panels used by the VIEW V option are similar to the entry panels used by the UPDATE U option. See UPDATE (U).
| Usage Consideration: | The displayed parameter settings are those that will be used during the next database machine startup; use the STARTUP S option to view the parameters used during the last database startup. |
Select this option to update one or more parameters in the database parameters file. Updated parameters will take effect the next time the database machine is started.
For each of the general parameter groups, a separate data entry panel is presented. Scrolling from one panel to the next is done using PF8 to go forward and PF7 to go backward. You can change existing parameters through normal editing means. Update of the parameters file on the Control Center service machine's 191 A-disk is completed by selecting PF2 to process your changes. You will be prompted to confirm the update action.
The initial data entry panel displayed is that of the Authorization/Notification parameters shown in Figure 87.
Figure 87. Database Parameter Display
+--------------------------------------------------------------------------------+ | mm/dd/yyyy CONTROL CENTER hh:mm:ss | | *------------------------ Database Parameter Display ----------------------* | | | Command ==> CTRLID: SQMSTPD1 | | | | Database => SQLDBA |DBver => 7.1.0 CCver => 7.1.0 NODE: VMSYSTM1 | | | | ************************ Authorization Parameters ********************* | | | | Administrators => |MSTRUSR1 MSTRUSR2 AT VMSYSTM2 MSTRUSR3 MSTRUSR4 AT | | | | |VMSYSTM3 MSTRUSR5 | | | | Operators => |OPERUID | | | | | | | | Users => |USRNICK MSTRUSR6 | | | | | | | | Notify-error => |MSTRUSR1 MSTRUSR3 | | | | | | | | Notify-severe => |MSTRUSR1 MSTRUSR3 | | | | | | | | Notify-dbstatus => |MSTRUSR1 MSTRUSR3 | | | | | | | | Notify-operator => | | | | | | | | Page 1 of 9 | | | | | | | *---------------------------------------------------------------SQMDP10----* | | PF: 1 Help 3 End 7 Bkwd (Data Restore parms) 8 Fwd (Utility parms) | | | +--------------------------------------------------------------------------------+
The data entry field for each Authorization/Notification parameter spans two lines, allowing a list of user IDs to be entered. Each user ID must be separated by a space and a single token should not be split over the two lines (the end-of-line character is translated into a blank by the Control Center).
The syntax for specifying authorization/notification parameters is given below.
Two authorized administrators are shown in Figure 87. MSTRUSR1 is a local user and MSTRUSR2 is a remote user.
Referring to Figure 87, MSTRUSR1 is a local user and USRNICKS is a CMS NICKNAME. USRNICKS must be included in the NAMES file on the Control Center service machine's 191 A-disk. This is the preferred method of specifying many users when using the entry panel, which has a limited amount of space for each parameter value.
Figure 88. Data Entry Panel for Utility Parameters
+--------------------------------------------------------------------------------+ | mm/dd/yyyy CONTROL CENTER hh:mm:ss | | *------------------------ Database Parameter Display -----------------------* | | | Option===> CTRLID: MSTRSRV1 | | | | Database => SQLDBA NODE: VMSYSTM1 | | | | ************************ Utility Parameters **************************** | | | | | | | | S-Disk Userid/Directory => SFSPOOL1:SQLDBA.SQL.SERVICE | | | | ________________________________________________________________________ | | | | ________________________________________________________________________ | | | | | | | | S-Disk Address or SFS => SFS (193 or other, if SFS , specify SFS) | | | | S-Disk Userid/Directory Filemode => V (filemode, enter V or other) | | | | | | | | P-Disk Userid/Directory => SFSPOOL1:SQLDBA.SQL.PRODUCTION | | | | ________________________________________________________________________ | | | | ________________________________________________________________________ | | | | | | | | P-Disk Address or SFS => SFS (195 or other, if SFS, specify SFS) | | | | P-Disk Userid/Directory Filemode => Q (filemode, enter Q or other) | | | | | | | | Page 2 of 9 | | | | | | | *---------------------------------------------------------------SQMDP45-----* | | PF: 1 Help 2 Process 3 End 7 Bkwd (Auth parms) 8 Fwd (Utility parms) | +--------------------------------------------------------------------------------+
Figure 89. Data Entry Panel for Utility Parameters - Part 2
+--------------------------------------------------------------------------------+ | mm/dd/yyyy Control Center hh:mm:ss | | *------------------------ Database Parameter Display -----------------------* | | | Option ===> CTRLID: CCDEMO | | | | Database => ACTCLONE NODE: YOURNODE | | | | ************************ Utility Parameters **************************** | | | | | | | | | | | | Archive-addspace => N ( Y or N, Archive after SQLADBSP) | | | | Archive-addextent => N ( Y or N, Archive after SQLADBEX) | | | | | | | | Sqlend-quick => N ( Y or N, SQLEND QUICK processes) | | | | | | | | Uarchive-enabled => N ( Y or N, User Archiving enable) | | | | Drmstr-enabled => N ( Y or N, Data Restore enable) | | | | | | | | Submit-routine => ________ ( UARCHIVE submit routine) | | | | Cancel-routine => ________ ( UARCHIVE cancel routine) | | | | Spool-console-option => N ( Y or N, Spool Database Console) | | | | | | | | | | | | Page 3 of 9 | | | | | | | *---------------------------------------------------------------SQMDP46-----* | | PF: 1 Help 2 Process 3 End 7 Bkwd (Utility Parms 1) 8 Fwd (Tape Parms) | +--------------------------------------------------------------------------------+
Figure 90. Data Entry Panel for Tape Parameters
+--------------------------------------------------------------------------------+
| mm/dd/yyyy Control Center hh:mm:ss |
| *------------------------ Database Parameter Update ------------------------* |
| | Command ==> CTRLID: MSTRSV1 | |
| | Database => SQLDBA NODE: VMSYSTM1 | |
| | ************************ Tape Parameters **************************** | |
| | | |
| | Tape-density => XF ( e.g. 4K, 38K ) | |
| | | |
| | NOTE: The following parameters apply to DYNAM/T, EPIC and VMTAPE | |
| | | |
| | Tape-retention => ____ ( Tape retention <days> ) | |
| | Scratch-tape-option => N ( Always use SCRATCH Y/N, if DYNOPEN, enter Y ) | |
| | ( archive, log, & trace dataset names for tape label checking | |
| | Tape-archive-dsn => _____________________________________________ | |
| | Tape-log-dsn => _____________________________________________ | |
| | Tape-trace-dsn => _____________________________________________ | |
| | ( scratch pool name for database ) | |
| | Scratch-pool => _____________________________________________ | |
| | Logtape-premount => N ( N with DISK or DMSTVI, Y with DYNAMT ) | |
| | | |
| | Page 4 of 9 | |
| | | |
| *---------------------------------------------------------------SQMDP50-----* |
| PF: 1 Help 2 Process 3 End 7 Bkwd (Utility Parms 2) 8 Fwd (Archive Parms) |
+--------------------------------------------------------------------------------+
These parameters are applicable only when using DYNAM/T, EPIC, or VMTAPE.
| Note: | The "Backup2-scratch-tape" parameter is used to indicate whether scratch is to be used for the secondary BACKUP (BACKUP2). |
By allowing Control Center to issue the tape mount, the log archive tape can be mounted in preparation for a log archive (premounted). During the period of time between when the log mount was issued and when the physical tape drive is attached, normal database activities can continue, including the start of new LUWs.
| Operational Note: | If log archive media is "DISK" you must specify "N". If you are using the exit DMSTVI, specify "N". If you are using DYNAM/T, you must specify "Y". |
Figure 91. Data Entry Panel for Archiving/Tracing Parameters
+--------------------------------------------------------------------------------+ | mm/dd/yyyy CONTROL CENTER hh:mm:ss | | *------------------------ Database Parameter Update ------------------------* | | | Command ==> CTRLID: MSTRSRV1 | | | | Database => SQLDBA NODE: VMSYSTM1 | | | | ********************* Archiving/Tracing Parameters ********************* | | | | | | | | Archive-media => TAPE ( TAPE or DISK ) | | | | Archive-blksize => 28672 ( e.g. 28672 ) | | | | Archive-series => 100 ( e.g. 200 ) | | | | | | | | Logarch-media => TAPE ( TAPE or DISK ) | | | | Logarch-blksize => 28672 ( e.g. 28672 ) | | | | Logarch-series => 100 ( e.g. 100 ) | | | | | | | | Trace-media => TAPE ( TAPE or DISK ) | | | | Trace-blksize => 28672 ( e.g. 28672 ) | | | | Trace-series => 100 ( e.g. 200 ) | | | | | | | | | | | | | | | | Page 5 of 9 | | | | | | | *---------------------------------------------------------------SQMDP55-----* | | PF: 1 Help 2 Process 3 End 7 Bkwd (Tape parms) 8 Fwd (Startup parms 1) | +--------------------------------------------------------------------------------+
| Usage Consideration: | Database archives to DISK are not fully supported by DB2 Server and VM and must be used with caution. |
| Operational Note: | Control Center automatically changes the archive-series after an archive or BACKUP in order to rotate through the available tape series. |
| Usage Consideration: | This value must match the previous value of the Archive-series parameter when a successful full ARCHIVE was performed. Therefore, it must be different from the current Archive-series. For initial setup, the value given here is not significant until the first full archive is done. |
| Operational Note: | Control Center automatically changes this value after an SQLEND in order to rotate through the available tape series. |
Field-specific help is available on this panel by placing the cursor at the first position of an entry field and selecting PF5. Help is displayed near the bottom of the panel.
Refer to the DB2 Server for VM System Administration or DB2 Server for VSE & VM Operation manuals for a complete description of each DB2 Server for VM database startup parameter.
Figure 92. Database Parameter Update Panel - Part 1
+--------------------------------------------------------------------------------+ | mm/dd/yyyy CONTROL CENTER hh:mm:ss | | *------------------------ Database Parameter Update ------------------------* | | | Command ==> CTRLID: MSTRSRV1 | | | | Database => SQLDBA NODE: VMSYSTM1 | | | | | | | | *********************** Environment Parameters ************************* | | | | DBNAME => SQLDBA AMODE => __ SYSMODE => M | | | | STARTUP => W DBMODE => _ PROTOCOL => AUTO | | | | PROGNAME => ________ ACCOUNT => _ SYNCPNT => Y | | | | DCSSID => _______ DSPSTATS => __ | | | | SUMDCSSID => _______ CHARNAME => __________________ | | | | | | | | *********************** Performance Parameters ************************ | | | | NCUSERS => ___ NPACKAGE => _____ NPACKPCT => ___ | | | | NPAGBUF => _______ NDIRBUF => ______ NLRBU => ______ | | | | NLRBS => ______ DISPBIAS => __ NCSCANS => ___ | | | | LTIMEOUT => 0 | | | | | | | | | | | | Page 6 of 9 | | | | | | | | | | | *---------------------------------------------------------------SQMDP60-----* | | PF:1 Help 2 Process 3 End 5 Field Help 7 Bkwd (Archive) 8 Fwd (Startup) | +--------------------------------------------------------------------------------+
Figure 93. Database Parameter Update Panel - Part 2
+--------------------------------------------------------------------------------+ | mm/dd/yyyy CONTROL CENTER hh:mm:ss | | *------------------------ Database Parameter Update ------------------------* | | | Command ==> CTRLID: MSTRSRV1 | | | | Database => SQLDBA NODE: VMSYSTM1 | | | | | | | | ************************* Recovery Parameters ************************** | | | | LOGMODE => Y CHKINTVL => ________ SLOGCUSH => ___ | | | | ARCHPCT => ___ SOSLEVEL => ___ | | | | | | | | ************************* Service Parameters ************************** | | | | DUMPTYPE => _ EXTEND => _ TRACDRRM => ____ | | | | TRACRDS => _______ TRACWUM => _ TRACSTG => _ | | | | TRACDSC => __ TRACCONV => _ | | | | TRACEBUF => _____ TRACDBSS => ___________ | | | | | | | | ************************* Miscellaneous Parameters ******************** | | | | TRACING => OFF TARGETWS => ______ MAPPING => _ | | | | SAVEINTV => ______ SEPINTDB => _ TCPPORT => 0 | | | | TCPPORTR => _____ SECTYPE => DB2|ESM SECALVER => Y|N | | | | PTIMEOUT => 180 PROCMXAB => 0 | | | | Page 7 of 9 | | | | | | | *---------------------------------------------------------------SQMDP61-----* | | PF: 1 Help 2 Process 3 End 5 Field Help 7 Bkwd (Startup 1) 8 Fwd (DRF 1) | +--------------------------------------------------------------------------------+
The VMDSS parameters are explained in the DB2 Server for VSE & VM Performance Tuning Handbook manual.
The output media for trace information is defined by the database Archiving/Tracing parameter settings. See Archiving/Tracing Parameters.
Figure 94. Data Restore Parameters
+--------------------------------------------------------------------------------+ | mm/dd/yyyy CONTROL CENTER hh:mm:ss | | *------------------------ Database Parameter Update ------------------------* | | | Command ==> CTRLID: MSTRSRV1 | | | | Database => SQLDBA NODE: VMSYSTM1 | | | | ************************* Data Restore Parameters ********************** | | | | | | | | Drmstr-enabled => N ( Y or N, Default = N) | | | | Data-restore-machine => ________ ( Machine running Data Restore Userid) | | | | Drtape-premount => N ( Y or N, Default = N ) | | | | Data-restore-lang => S001 ( Default = S001 ) | | | | Dual-backup => N ( Y or N, Default = N ) | | | | Backup-wrksize => 2048 ( Default = 2048 ) | | | | Backup2-media => ____ ( TAPE or DISK ) | | | | Backup2-scratch-tape => N ( Y or N, Default = N ) | | | | | | | | Incbackup-enabled => N ( Y or N, Default = N ) | | | | Incbackup-series => 100.01 ( nnn.nn format ) | | | | Auto-full => N ( Y or N, Default = N ) | | | | Current-increference => ( Date & Time Information ) | | | | | | | | Page 8 of 9 | | | | | | | *---------------------------------------------------------------SQMDP66-----* | | PF: 1 Help 2 Process 3 End 7 Bkwd (Startup parms 2) 8 Fwd (DRF 2 parms) | +--------------------------------------------------------------------------------+
If Y (YES) is chosen, then a DUAL BACKUP or DUAL Incremental Backup will be performed. The BACKUP2 tapes for the current "Archive-series" will be used for the secondary BACKUP and the "INCBK2" tapes for the current "Incbackup-series" will be used for the secondary Incremental Backup. The default value is N.
When "Incbackup-enabled" = "N", Control Center will not execute an Incremental Backup and the "Current-increference" parameter will be set to blank when a normal BACKUP or archive completes. When "Current-increference" is blank, a Full Backup or an ARCHIVE FULL must be executed before Control Center will allow an Incremental Backup.
Only the subseries is incremented after an Incremental Backup successfully completes. The series is incremented and the subseries reset to "01" each time any normal BACKUP, Full Backup, normal archive or ARCHIVE FULL completes. The series portion of the Incbackup-series will be the same as the Logarch-series. The Incbackup-series will exist in the PARMS file even when "Incbackup-enabled" = "N".
This parameter should not be modified by the user. If "Incbackup-enabled" = "N" and a normal BACKUP or archive has completed, then this parameter will be blank. When this parameter is blank, a Full Backup or ARCHIVE FULL must be executed before Control Center will allow an Incremental Backup.
When Auto-full = "N" (No), then the Incremental Backup will be cancelled if the current Incbackup-series does not exist in the database TAPES file. If the "AUTOFULL" option is used with the BACKUP command then it will over-ride the "Auto-full" value in the database PARMS file.
Figure 95. Data Restore Parameters
+--------------------------------------------------------------------------------+ | mm/dd/yyyy Control Center hh:mm:ss | | *------------------------ Database Parameter Update ------------------------* | | | Command ==> CTRLID: MSTRSRV1 | | | | Database => SQLDBA NODE: VMSYSTM1 | | | | ************************* Data Restore Parameters ********************** | | | | | | | | | | | | Translate-media => TAPE ( TAPE or DISK ) | | | | Translate-scratch-tape => Y ( Y or N, Default = N ) | | | | | | | | | | | | ( Data Set Names for Translate, Unload, and Backup tapes ) | | | | Tape-translate-dsn => DB261DBA.TRANSLATE | | | | Tape-unload-dsn => DB261DBA.UNLOAD | | | | | | | | Tape-backup-dsn => DB261DBA.BACKUP | | | | Tape-backup2-dsn => DB261DBA.BACKUP2 | | | | | | | | | | | | Page 9 of 9 | | | | The requested command was issued | | | *---------------------------------------------------------------SQMDP67-----* | | PF: 1 Help 2 Process 3 End 7 Bkwd (DRF Parms 1) 8 Fwd (Auth Parms) | +--------------------------------------------------------------------------------+
Displays the startup parameters that were used by the database when it was last started (which can differ from those in the current database PARMS file if it has been updated since this time). Included will be any default values supplied by the database. 9 The date and time that the database was started will also be shown.
Select this option to view the current settings saved in the storage pool specifications file.
The display panel used by the VIEW SPECS VS option is similar to the entry panel used by the UPDATE SPECS US option. See UPDATE SPECS (US).
Usage Considerations:
Select this option to update one or more parameters in the storage pool specifications file. Updated parameters will take effect the next time the database machine is started.
Update of the specifications file on the service machine's 191 A-disk is completed by selecting PF2 to process your changes. You will be prompted to confirm the update action.
The storage pool specifications data entry panel is shown in Figure 96.
Figure 96. Data Entry Panel for Storage Pool Specifications
+--------------------------------------------------------------------------------+ | mm/dd/yyyy CONTROL CENTER hh:mm:ss | | *--------------------- Storage Pool Specifications File --------------------* | | | CTRLID: MSTRSRV1 | | | | Database => SQLDBA NODE: VMSYSTM1 | | | | | | | | POOL n IO Handling Striping | POOL n IO Handling Striping | | | | /Range DS|Priority/BLK STR/SEQ | /Range DS|Priority/BLK STR/SEQ | | | | ------- --------------- -------- | ------- --------------- -------- | | | | | | | | | 1 DS3 STR | | | | | ------- --- --- | ------- --- --- | | | | 2 DS3 STR | | | | | ------- --- --- | ------- --- --- | | | | 3 DS3 STR | | | | | ------- --- --- | ------- --- --- | | | | | | | | | ------- --- --- | ------- --- --- | | | | | | | | | ------- --- --- | ------- --- --- | | | | Screen 1 of 1 | | | | | | | *-------------------------------------------------------------SQMMENUV------* | | PF: 1 Help 2 Process 3 QUIT 8 Add More Delete: Space Over POOL | | 10 Show POOL 11 Query Dbextents | +--------------------------------------------------------------------------------+
To delete a pool or pool range, space over the pool number or pool range entry.
Possible values are:
Valid Priority range = 1 to 5 (3 is the default). If not indicated, the default will be used.
The priority value should be entered immediately after the DS term as shown in Figure 96.
Possible values are:
Use the Database Startup tool to initiate the immediate startup of a database or to schedule the startup of a database for a later date and time using the Job Scheduling tool.
Select this option to immediately issue a database startup command to the specified database. Startup parameters will be taken from the database parameter file and storage pool specifications file (if it exists), which reside on the service machine's 191 A-disk. The startup command will be rejected by Control Center if the current status of the database is not "Down."
Select this option to schedule the database to start up at a later date and time.
Use the Database Termination tool to stop a database. The Database Termination selection panel, shown in Figure 97, is presented after choosing Option E (SQLEND Database) from the Control Center Main Menu.
Figure 97. Database Termination Option Panel
+--------------------------------------------------------------------------------+ | mm/dd/yyyy CONTROL CENTER hh:mm:ss | | *--------------------------- Database Termination --------------------------* | | | Option ===> CTRLID: MSTRSRV1 | | | | Database ===> SQLDBA NODE: VMSYSTM1 | | | | | | | | N SQLEND NORMAL parms Immediate SQLEND (normal) | | | | | | | | Q SQLEND QUICK Immediate SQLEND QUICK | | | | | | | | S SCHEDULE SQLEND parms Schedule later termination | | | | | | | | SQ SCHEDULE SQLEND QUICK Schedule quick termination | | | | | | | | | | | | Valid Parms: DVERIFY, TRCPURGE | | | | | | | | | | | | | | | | Enter OPTION and PARMS, press ENTER to Process, or | | | | press PF3 to CANCEL the database termination | | | | | | | *---------------------------------------------------------------SQMSQEND----* | | PF: 1 Help 3 End | | | +--------------------------------------------------------------------------------+
Selecting this option will allow all current LUWs to complete prior to stopping the database and prevent any new units of work from beginning. Active LUWs can delay the stopping of the database.
Optional parameters:
Selecting this option will immediately stop the database. Any active LUWs will be rolled back when the database is brought back up.
Select this option to schedule the database to stop at a later date and time. At the scheduled time, all current LUWs will be allowed to complete prior to the database being stopped and any new units of work will be prevented from beginning. Active LUWs can delay the stopping of the database.
Optional parameters:
Select this option to schedule the database to stop at a later date and time. Any active LUWs will be rolled back when the database is brought back up.