Network Error Warning System › Maintain the NEWS Database

Maintain the NEWS Database

The NEWS Control Functions let you set NEWS parameters and tune the various features of NEWS after you have installed NEWS.

You can improve the capacity of the NEWS database by deleting database records or by reclaiming unused VSAM space.

The Database Maintenance panel lets you delete specific records from the database, delete all records, or perform a manual reorganization of the database to reclaim VSAM space.

Implement CNMPROC Logging Options

The CNMLOGGING parameter group lets you turn logging on and off for the NEWS database and to define what is to happen if the NEWS database is filled:

• Logging a reminder message after a specified number of lost records
• Whether to automatically reorganize the NEWS database

To implement the CNMPROC logging options

1. Enter /PARMS at the prompt.

   The Parameter Groups panel appears.

2. Enter U beside the CNMLOGGING parameter group.

   The CNMLOGGING - NEWS Database Logging Options panel appears. This panel has two pages that you can scroll through to define CNMPROC logging options.

3. Complete the following fields:

   Logging Active?

   Enter NO to suspend logging, or YES to resume logging.

   Lost Record Reminder

   Specify what is to happen if the NEWS database is full.

   Auto-reorg?

   Specify what is to happen if the NEWS database is full.

   For more information about the fields, press F1 (Help).

4. Press F6 (Action).

   The entries are actioned.

5. Press F3 (File).

   The settings are saved.

Access Database Maintenance

The NEWS : Database Maintenance panel lets you do the following:

• Delete specified records
• Delete all records
• Perform a reorganization of the NEWS database.

To access Database Maintenance

1. Enter /SNADBA at the prompt.

   The NEWS : Database Maintenance menu appears.

2. Specify the parameters that you want to delete.

Delete Records Generically by Date and Node

To delete specified records generically from the NEWS : Database Maintenance menu

1. Choose option 1 - Delete Records Generically by Date and/or Node.
2. Complete the following fields:

   Keep Date

   Specify a date to delete any records that arrive before the specified date. For more information about date formats, press F1 (Help).

   Node Name

   Specify one of the following:

   • A node name
   • A generic node name, by typing a generic node name and the wild character *
   • All nodes, by typing the wild character *

   Delete Masters

   Type Y to delete master and detail records, or N to delete detail records only.

   The Master record contains information, in a record category for a specific node, about when detailed records were collected, the record count, and the record collection period.

   Detail records contain detailed information for a specific node.

   A panel appears showing the number of detail records deleted, the number of master records updated, and the number of master records deleted.

   Note: If you deleted large numbers of records, we suggest that you perform a database reorganization to reclaim unused VSAM space.

Delete All Records

To delete all records from the NEWS database

1. From the NEWS : Database Maintenance menu, choose option 2 - Delete All NEWS Database Records.

   A confirmation message appears.

Note: After clearing the database, it is recommended that you perform a database reorganization to reclaim unused VSAM space.

Reorganize the NEWS Database

Reorganizing the NEWS database lets you reclaim any unused VSAM space.

Note: NEWS can perform automatic database reorganization if you enable the Auto Re-org facility by using the CNMLOGGING - NEWS Database Logging Options panel.

Before you reorganize the database, ensure you have appropriate VSAM definitions.

To reorganize the NEWS database

1. Review the VSAM cluster definition of NEWSFILE on the NEWS - NEWS File Specifications parameter group panel and ensure that the NEWSFILE is defined with the REUSE option. For some levels of VSAM, this is possible where the data set has been sub-allocated only.
2. Review the backup file (NEWSBKP) definition on the NEWS - NEWS File Specifications panel and ensure that the backup data set is large enough to contain all database records.
3. Go to OCS (=O) and enter SHOW UDBUSERS to check that the NEWSFILE ID is not being used.

Release the NEWSFILE from CNMPROC

The NEWSFILE file ID would normally be in use by CNMPROC and any users currently using NEWS options involving access to the database. Certain options, such as the System Support Services menu, are entered without allocating the file until a specific requests required its use.

You can release the NEWSFILE from CNMPROC by suspending database logging, using the CNMLOGGING parameter group.

Reorganize the Database Manually

This action invokes NCL procedure $NWCNMRO, which builds IDCAMS control statements and calls the utility program UTIL0007 to attach IDCAMS and perform the actual reorganization.

To manually reorganize the NEWS database

1. From the NEWS : Database Maintenance menu, choose option 3 - Perform Re-org of the NEWS Database.

   A confirmation message appears.

   Note: If the reorganization is unsuccessful, determine the reason for the failure by referring to the message issued to the activity log.

2. Restart CNMPROC or reactivate database logging by using the CNMLOGGING - NEWS Database Logging Options parameter group panel.