Creating the storage group and database

Procedure

To run the ARSDB2 job to create the storage group and the Content Manager OnDemand database, do the following steps:

Modify the JCL for your environment and replace the symbolic fields. For more information, see Creating the storage group and database . You can find the ARSDB2 member in the SARSINST library.
Submit the job.
Check job completion status in the SDSF output.

Example

The following shows an example of the ARSDB2 job.

//ARSDB2   JOB (account),userid,MSGCLASS=A,REGION=0M 
//*  FUNCTION: CREATE THE DB2 DATA BASE AND STORAGE GROUP                 
//*            TO INSTALL AND RUN OD/MP                                   
//*  NOTES:    ON MULTIPLE CPU SYSTEMS, THIS JOB MUST BE RUN              
//*            ON THE SYSTEM WHERE DB2 EXECUTES.                          
//**************************************************************          
//*                                                                       
//* TO CREATE THE OD/MP DB2 DATABASE AND STORAGE GROUP:                   
//* 1. PROVIDE A SUITABLE JOBCARD FOR YOUR ENVIRONMENT.                   
//* 2. REPLACE THE FOLLOWING SYMBOLIC FIELDS:                          
//*    db2ssid     - DB2 SUBSYSTEM ID                                  
//*    catalog     - EXISTING CATALOG NAME OR CATALOG ALIAS            
//* 3. (OPTIONAL) CHANGE THE FOLLOWING CREATE PARAMETERS:              
//*    STOGROUP   - DEFAULT STORAGE GROUP IS ARSSGRP                   
//*    DATABASE   - DEFAULT DATABASE IS ARSDBASE                       
//*    PLAN       - DEFAULT DB2 PLAN NAME IS DSNTIA91                  
//*    LIB        - DEFAULT DB2 RUNTIME LIBRARY IS                     
//*                 'DB2.RUNTIME.LOADLIB'                              
//*    SQLID      - DEFAULT CURRENT SQLID='ARSUSER'                    
//*                                                                    
//* example entries                                                    
//* account                    =  acct
//* userid                     =  USER
//* db2ssid                    =  DSNA     
//* db2.runtime.loadlib        =  DB2.V10R1M0.DSNA.RUNLIB.LOAD
//* arsuser                    =  ARSSERVR  
//* catalog                    =  DSNACAT  
//* 
//* 4. SUBMIT THE JOB.                                                 
//*                                                                    
//************************* Sample 1 *************************************
//STEP1    EXEC PGM=IKJEFT01,DYNAMNBR=20                               
//STEPLIB DD DISP=SHR,DSN=DB2.V10R1M0.SDSNLOAD           							
//SYSTSPRT DD SYSOUT=*                                                 
//SYSTSIN  DD *                                                        
 DSN SYSTEM(db2ssid)                                                   
 RUN  PROGRAM(DSNTIAD) PLAN(DSNTIA10) -                                
      LIB('DB2.RUNTIME.LOADLIB')                            					
//SYSPRINT DD SYSOUT=*                                                 
//SYSUDUMP DD SYSOUT=*                                                 
//SYSIN    DD *                                                        
 SET CURRENT SQLID='arsuser';                                   				
 CREATE STOGROUP ARSSGRP                                                
        VOLUMES ('*','*')                                    					
        VCAT  catalog;                                                 
 CREATE DATABASE ARSDBASE           .                                  
        STOGROUP ARSSGRP;

Figure 1. Sample ARSDB2 job.

The JCL statements in Figure 1 are explained as follows.

//ARSDB2 JOB (account),userid

Provide a suitable JOB statement for your environment.

//STEPLIB DD

Specifies the DB2® load library, which must be customized for the version and local naming conventions.

//SYSTSIN DD

Specifies the parameters for the ARSDB2 job. Verify and replace the following parameter values:

DSN SYSTEM(db2ssid): Specify the DB2 subsystem ID.
PLAN(DSNTIA10): Specify the PLAN.
LIB('DB2.RUNTIME.LOADLIB'): Specify the DB2 runtime library.

//SYSIN DD

Specifies the parameters for the ARSDB2 job. Verify and replace the following parameter values:

SQLID='arsuser': The SQLID that is specified for the database should be the same as that specified for the SRVR_INSTANCE_OWNER parameter in the /usr/lpp/ars/V9R5M0/config/ars.ini file. The default value in the ars.ini file is ARSSERVR (see Verify the ARS.INI file).
STOGROUP ARSSGRP: Specify the name for the storage group.
DATABASE ARSDBASE: Specify the name for the Content Manager OnDemand database.
Important: The database name that you specify must match the name that you specified for the SRVR_INSTANCE parameter in the /usr/lpp/ars/V9R5M0/config/ars.ini file. The default value in the ars.ini file is ARSDBASE (see Verify the ARS.INI file).