DB2 Server for VM: System Administration

Starting the Accounting Facility

To start the application server in multiple user mode to collect accounting information:

1. Log on to a database machine. (The database machine must have the ACCT operand specified on its OPTION directory control statement.)
2. If you are reconnecting, IPL CMS to get a fresh machine.
3. Start the SQLSTART EXEC with ACCOUNT=D. You can set all other initialization parameters as you would usually set them. For example:

   
   

   SQLSTART DB(DB010) ID(BOOT1) PARM(PARMID=WARM,NLRBU=1500,ACCOUNT=D)

   The file WARM SQLPARM is referenced in the PARMID parameter. The NLRBU and ACCOUNT parameters are specified on the command itself. The ACCOUNT parameter is a normal initialization parameter, so you can specify it in a CMS parameter file.

The database manager then automatically generates accounting records for all activity involving the database machine.

The database manager can also generate accounting records in single user mode for user programs, the DBS utility, and the preprocessors. Accounting records are not generated for:

• Log reconfigurations (COLDLOG) with the SQLLOG EXEC. The SQLLOG EXEC starts the application server with STARTUP=L.
• Database generations with the SQLDBGEN or SQLDBINS EXECs. These EXECs start the application server with STARTUP=C.
• Adding dbextents with the SQLADBEX EXEC. The SQLADBEX EXEC starts the application server with STARTUP=E.
• Adding dbspaces with the SQLADBSP EXEC. The SQLADBSP EXEC starts the application server with STARTUP=S.
• Catalog index reorganizations with the SQLCIREO EXEC. The SQLCIREO EXEC starts the application server with STARTUP=I.
• Catalog migrations with the ARISMEX EXEC. The ARISMEX EXEC starts the application server with STARTUP=M.
• PROGNAME=ARISEGB, which is the catalog update phase of an ADD DBSPACE operation.

If you specify ACCOUNT=D in any of those situations, the database manager displays a warning message and ignores the ACCOUNT parameter.

To generate accounting records for single user mode programs, specify ACCOUNT=D as you would for multiple user mode. For the DBS utility and the preprocessors, you must use the PARMID(filename) parameter to point to a CMS file that contains the ACCOUNT=D parameter.