Batch Processing & Reporting › The Parameter Files › CAIKSPAR Parameter File › Database-Related Keywords

Database-Related Keywords

The following four parameters are used to specify the database product your installation uses. CA PMA Chargeback supports CA Datacom and IBM's DATABASE2. Note that DATABASE_NAME is defined during installation and that the following values are defaults. Use the table below as a guide in specifying the following parameters:

       ___________________ ______________ ______________
       | Parameter       | | DATABASE2  | | CA Datacom |
       |_________________| |____________| |____________|
       | DATABASE_NAME = | |  PMACB     | |  CBASEPMA  |
       |_________________| |____________| |____________|
       | PLAN_ID =       | |  _ _ _ _   | |    N/A     |
       |_________________| |____________| |____________|
       | SQL_TYPE =      | |  DB2       | |  Datacom   |
       |_________________| |____________| |____________|
       | SUBSYSTEM_ID =  | |  DB23      | |  executing |
       |                 | |            | |  userid    |
       |_________________| |____________| |____________|

DATABASE_NAME =

This parameter tells CA PMA Chargeback which database to use for documentation purposes only. Up to eight characters are permitted.

PLAN_ID =

This is a DB2 1-8 character parameter which is site dependent.

• If you are using DB2 and require the PLAN_ID, uncomment the PLAN_ID and enter the 1-8 character PLAN_ID.
• If you are using DB2, but do not use the PLAN_ID, the PLAN_ID must remain as a comment.
• If you are using Datacom, the PLAN_ID must remain as a comment.

SQL_TYPE =

This parameter tells CA PMA Chargeback the type of SQL statements that will be used.

SUBSYSTEM_ID =

This 1-4 character SSID or driver is used when DB2 links to data. For CA Datacom, the SUBSYSTEM_ID should be any executing userid.