DBINIT (NCCF; CNME2009)

Syntax

DBINIT

Read syntax diagramSkip visual syntax diagramDBINIT NLDMNPDASAVETCPCONN  password CYL TRK  primary_space  secondary_space  automation  action  days  timer_start  timer_action  timer_days  timer_time_of_day  timer_interval  passthru

Purpose of Command

The DBINIT command enables you to set global variables and perform periodic database maintenance using the EVERY timer and the DBAUTO command. This command is started by the CNMSTYLE member when the NetView® program starts.

Operand Descriptions

NLDM
Specifies the session monitor VSAM database.
NPDA
Specifies the hardware monitor VSAM database.
SAVE
Specifies the Save/Restore VSAM database.
TCPCONN
Specifies the TCP/IP connection management VSAM database.
password
Specifies your VSAM database password. This password can be in the range of 1-8 alphanumeric characters. Specify NONE if a password is not used.
CYL
Specifies space allocation-type of cylinder.
TRK
Specifies space allocation-type of track.
primary_space
Specifies the amount of primary space allocated to temporarily hold the database contents while REORG is running.
secondary_space
Specifies the amount of secondary space allocated to temporarily hold the database contents while REORG is running.
automation
Specifies whether to enable the DBFULL function when DBFULL is started by message automation from the automation table:
  • Y: specifies to enable DBFULL
  • N: specifies to disable the DBFULL.
Note: DBFULL is started when the specified database is full. DBFULL calls DBAUTO to perform database maintenance.
action
Specifies the action for DBFULL to perform when starting the DBAUTO command:
CLEAR
Erases the contents of the entire VSAM database.

For NLDM, when the CLEAR request completes, NLDM session recording is started. If NLDM session recording was active before the CLEAR request, it is restarted when the CLEAR request completes. If NLDM session recording was not active before the CLEAR request, it is started when the CLEAR request completes.

PURGE
Enables you to purge entries in your VSAM database.

After the database entries are purged, the VSAM database is reorganized. See the description for the REORG keyword.

Note: PURGE can be used only with NLDM, NPDA, and TCPCONN.
PURGExx
For the NLDM database, you can specify a purge exception list that is defined in the CNMSTYLE member. The xx corresponds to the CNMSTYLE exception list definition (NLDM.PEXLSTxx).
Note: PURGExx can be used only with NLDM.
REORG
Enables you to reorganize your VSAM database, which claims free space and allows this space to be reused.
SWITCH
Enables you to switch from an active to an inactive VSAM database.
days
The number of days of activity to keep in the VSAM database for the PURGE or PURGExx action. For CLEAR, REORG, and SWITCH, specify 0.
timer_start
Specifies whether to initiate a DBAUTO command on an EVERY timer for periodic database maintenance:
  • Y: initiate the DBAUTO command
  • N: do not initiate the DBAUTO command
timer_action
Specifies the action for the timed DBAUTO command:
CLEAR
Erases the contents of the entire VSAM database.

For NLDM, when the CLEAR request completes, NLDM session recording is started. If NLDM session recording was active before the CLEAR request, it is restarted when the CLEAR request completes. If NLDM session recording was not active before the CLEAR request, it is started when the CLEAR request completes.

PURGE
Enables you to purge entries in your VSAM database.
After the database entries are purged, the VSAM database is reorganized. See the description for the REORG keyword.
Note: PURGE can be used only with NLDM, NPDA, and TCPCONN.
PURGExx
For the NLDM database, you can specify a purge exception list that is defined in the CNMSTYLE member. The xx corresponds to the exception list statement (NLDM.PEXLSTxx).
Note: PURGExx can be used only with NLDM.
REORG
Enables you to reorganize your VSAM database, which claims free space and allows this space to be reused.
SWITCH
Enables you to switch from an active to an inactive VSAM database.
timer_days
Specifies the number of days of activity to keep in the VSAM database for the PURGE or the PURGExx timer_action function and the resulting timed DBAUTO command. For CLEAR, REORG, and SWITCH, specify 0.
timer_time_of_day
Specifies the time of day in hours (00-24), minutes (00-59), and seconds (00-59) that DBAUTO performs database maintenance. The format is controlled by the setting of the time operands of the DEFAULTS and OVERRIDE commands. If you specify 24 for hours, specify 00 for minutes and seconds.
timer_interval
Specifies the number of days between DBAUTO invocations for database maintenance.
passthru
Specifies additional parameters that are passed to the timed DBAUTO command.

Restrictions

The following restrictions apply to the DBINIT command:
  • All parameters are positional.
  • All parameters are required except for passthru.

Example: Reorganizing a database

To reorganize the Save/Restore VSAM database, designating 50 cylinders for the primary and secondary databases, enter: 
DBINIT SAVE NONE CYL 50 50 N REORG 0 Y REORG 0 03:30:00 1
This process is repeated at 3:30 every day.

Example: Purging database entries

To purge everything in the NLDM database except for the last 2 days of entries, enter: 
DBINIT NLDM NONE CYL 50 50 Y PURGE 2 Y PURGE 2 02:00:00 1
This process is repeated at 2:00 every day.

Example: Purging Session Monitor database entries using an Exception List

To purge everything in the session monitor database before the last two days, except for entries with session information between HOST1 and NCP resources or CP-CP sessions, enter: 
DBINIT NLDM NONE CYL 50 50 Y PURGE02 2 Y PURGE02 2 02:00:00 1
The corresponding CNMSTYLE statements containing the exception lists are: 
NLDM.PEXLST02.A = HOST1 NCP*
NLDM.PEXLST02.B = CP-CP