Database Utilities

Document ID : KB000010134
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

VM:Spool provides four utilities that create a database of information about the spool-space activity of your system. 

Instructions:

These utilities optionally generate accounting records that are based on the data. If you include the DATABASE record in the VMSPOOL CONFIG file, the utilities run automatically.

A summary of the database utilities and what they do follows:

  • VMLDBU
    Generates the database and updates it periodically with new information about spool files.
  • VMLDBB
    Uses the information that is stored in the database to create a file containing type C0/AB accounting records.
  • VMLDBA
    Sends the accounting records created by VMLDBB to CP.
  • VMLDBP
    Purges database records that contain obsolete spool-file information.
Additional Information:

How the utilities work can be found here:

https://docops.ca.com/ca-vm-spool/1-8/en/administrators/database-utilities#DatabaseUtilities-HowtheUtilitiesWork