DB2 must already be installed and running. Also, you must know the installation directory for DB2.
To configure DB2 and create the database tables on z/OS:
CREATE STOGROUP RAMSTG VOLUMES ('*') VCAT yourHlq ;
yourHlq is the high-level qualifier of your DB2 files.
It must exist on your system, and the Rational Asset Manager user
must have full access to it.Create the following Database for the assets
CREATE DATABASE RAMDB STOGROUP RAMSTG BUFFERPOOL BP16K0
CCSID UNICODE;
COMMIT;
Create the following Databases for the asset lifecycles
CREATE DATABASE RAMJTS STOGROUP RAMSTG BUFFERPOOL BP16K0
CCSID UNICODE;
COMMIT;
CREATE DATABASE RAMCCM STOGROUP RAMSTG BUFFERPOOL BP16K0
CCSID UNICODE;
COMMIT;
As shown in the example, the
databases must be created with UNICODE as the CCSID. BP16K0 is
an example of the buffer pool name. On z/OS,
a 16K page size or larger is required.-- General
GRANT USE OF STOGROUP RAMSTG TO ramuser ;
GRANT SELECT ON SYSIBM.SYSTABLES TO ramuser ;
GRANT SELECT ON SYSIBM.SYSINDEXES TO ramuser ;
GRANT SELECT ON SYSIBM.SYSDATABASE TO ramuser ;
GRANT SELECT ON SYSIBM.SYSTABCONST TO ramuser ;
GRANT SELECT ON SYSIBM.SYSAUXRELS TO ramuser ;
GRANT SELECT on SYSIBM.SYSKEYS TO ramuser ;
-- Grant access to bufferpool. Default bufferpool is used
-- for tablespaces and an additional grant for the default BP
-- may be needed if different from this one
GRANT USE OF BUFFERPOOL BP16K0 TO ramuser ;
-- Grant access to the asset database
GRANT DBADM ON DATABASE RAMDB TO ramuser ;
-- Grant access to the asset lifecycles databases
GRANT DBADM ON DATABASE RAMJTS TO ramuser ;
GRANT DBADM ON DATABASE RAMCCM TO ramuser ;
COMMIT ;
GRANT SYSADM TO ramuser ;
COMMIT ;
GRANT SYSCTRL TO ramuser ;
COMMIT ;