Prepare the DB2 Database

If you are using CA Datacom as your database, this section can be skipped.

Have the DB2 database administrator authorize the ID being used to install CA PMA Chargeback for DATABASE CREATE, TABLE CREATE, and GRANT authority.
Create a database, buffer pool, and storage group to be used by CA PMA Chargeback.
Grant access to the database and buffer pool to the ID being used to install CA PMA Chargeback.
The following SQL commands can be used as a guide for setting up DB2 to prepare for CA PMA Chargeback.
```
CREATE DATABASE PMA490
STOGROUP SGPMA490
BUFFERPOOL BP0
CREATE STOGROUP SGPMA490 VOLUMES (“*”,”*”,”*”) VCAT xxxx;
```
The above SQL statements will create and identify the PMACB database to DB2 using storage group SGPMA490 and buffer pool zero. The xxxx represents the four-character database subsystem id.
```
GRANT DBADM ON DATABASE PMA490 TO userid;
GRANT USE OF BUFFERPOOL BP0 TO userid;
GRANT USE OF STOGROUP SGPMA490 TO userid;
GRANT EXECUTE ON PLAN CAISSQL2,CAISSQL3,CAISSQL9 TO userid;
```
The SQL statements above grant database administrator authority and use of the buffer pool and storage group to the user ID specified.