Creating database tables for assets in DB2 on z/OS

These are the instructions for manually configuring IBM® DB2® and creating tables for IBM Rational® Asset Manager in DB2 on z/OS®.

Before you begin

DB2 must already be installed and running. Also, you must know the installation directory for DB2.

Procedure

To configure DB2 and create the database tables on z/OS:

  1. Create a storage group that is appropriate to the system. The following example shows a DB2 SQL create statement.
    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.
  2. Create and add the new databases for assets and for asset lifecycles. The following example shows a DB2 SQL create statement.
    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.
  3. Authorize user access to the databases. The user ID has the name ramuser. This user ID is used to provide authority for the server to access the DB2 for z/OS databases. This user ID requires permissions as shown in the following example. A user ID with SYSADM access to the databases has the appropriate access to run the server and create the required tables. If your process does not allow a user ID with SYSADM access, you must grant additional permissions to the user ID. Examples of the GRANT statements are included in the following sample. (Comments are indicated by --.)
    -- 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 ;  
  4. If the value of field DBADM CREATE AUTH is set to NO on panel DSNTIPP during DB2 installation, you must grant SYSADM authorization to the user.
    GRANT SYSADM TO ramuser ; 
    COMMIT ; 
  5. If the value of field DBADM CREATE AUTH is set to YES on panel DSNTIPP during DB2 installation, the user can create the database with DBADM authority, but if you want the user to upgrade the database, you must grant SYSCTRL authorization to the user.
    GRANT SYSCTRL TO ramuser ; 
    COMMIT ;

Feedback