DBAUTO (NCCF; CNME2008)

Syntax

DBAUTO

Read syntax diagramSkip visual syntax diagramDBAUTO NLDM NPDA EZLSTS TCPCONN,CLEAR,PURGE,days,PEXLSTxx,REORG,SWITCH SAVE,CLEAR,REORG,SWITCH,,password,CYL,TRK,50,primary_space,50,secondary_space,passthru

Purpose of Command

The DBAUTO command enables you to purge entries from your VSAM database, reorganize the database, switch to a secondary database, or clear the database altogether.

Operand Descriptions

NLDM
Session Monitor VSAM database.
NPDA
Hardware Monitor VSAM database. This option purges event, statistic, and GMFALERT records.
EZLSTS
AON status file. This option starts the DBMAINT command to perform maintenance for the AON status file.
TCPCONN
TCP/IP connection management VSAM database.
SAVE
Save/Restore VSAM database.
CLEAR
Erases the contents of the entire VSAM data base. This is done by the RESETDB command. 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 selectively purge entries in your VSAM database. Using the days option, you can automatically purge entries in your VSAM database that are older than a specified number of days. After the database entries are purged, the VSAM database is reorganized (see REORG below).
Note: There is no PURGE option for SAVE.
days
The number of days of activity you want to keep in the VSAM database. This parameter is optional and can be specified only with the PURGE function. This value overrides the common global variables: NLDM PURGE_DAYS, NPDA PURGE_DAYS. The defaults are 2 for NLDM and 5 for NPDA.
PEXLSTxx

Specifies a purge exception list that is defined in the CNMSTYLE member.

The xx corresponds to the CNMSTYLE exception list definition (NLDM.PEXLSTxx.suffix).

Note: PEXLSTxx is valid only with the NLDM keyword.
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.
password
Specifies your VSAM database password. The password can be in the range of 1-8 alphanumeric characters. The default is blank.
CYL
Specifies space allocation-type of cylinder. This is the default.
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. The default is 50, and the minimum allocation is 1 cylinder or track.
secondary_space
Specifies the amount of secondary space allocated to temporarily hold the database contents while REORG is running. The default is 50, and secondary space allocation is optional.
passthru
When used with EZLSTS, specifies parameters which are appended unchanged to the DBMAINT command.

Otherwise, specifies parameters which are appended unchanged to the internal ALLOCATE command which allocates the temporary database used to hold the contents of the VSAM file being reorganized. This ALLOCATE defaults the following parameters if not specified: RECFM(VB) LRECL(8196) BLKSIZE(8200).

Restrictions

The following restriction applies to the DBAUTO command:
  • The DBAUTO command cannot run under the primary program operator interface task (PPT).
  • All keywords are positional. Commas are required as a delimiter between each specified keyword. If a keyword is omitted, indicate its absence with a comma. Trailing commas are not required.

Example: Purging entries

To purge everything in the database except for the last four days of entries, enter: 
DBAUTO NLDM,PURGE,4

Example: Purging session monitor entries using an Exception List

To purge everything in the session monitor database older than two days except for entries with session information between HOST1 and an NCP resource or any CP-CP session, enter: 
DBAUTO NLDM,PURGE,2,PEXLST02
The corresponding CNMSTYLE statements containing the exception lists are: 
NLDM.PEXLST02.A = HOST1 NCP*
NLDM.PEXLST02.B = CP-CP

Example: Reorganizing the database

To reorganize the database, default the password, and designate 30 cylinders for the primary database and 20 cylinders for the secondary database, enter: 
DBAUTO NPDA,REORG,,,CYL,30,20