Creating the table spaces

About this task

After you create the storage group and the database by running the ARSDB2 job, run the ARSTSPAC job to create table spaces that are used for the Content Manager OnDemand system tables.

Procedure

To create the table spaces, do the following steps:

Modify the JCL for your environment and replace the symbolic fields. For more information, see Creating the table spaces. The ARSTSPAC member can be found in the ODADMIN.V9R5M0.SARSINST library.
Submit the job.
Check job completion status in the SDSF output.

Example

Figure 1 shows an example of the ARSTSPAC job.3

Figure 1. Sample ARSTSPAC job.

//ARSTBSPC JOB (account),userid,MSGCLASS=A
//**************************************************************
//*
//*  FUNCTION: CREATE THE DB2 TABLESPACES REQUIRED TO INSTALL
//*            AND RUN ONDEMAND. THE FOLLOWING IS A LIST OF THE
//*            TABLESPACES THAT WILL BE CREATED.
//*
//*  FMID:     H272950
//*
//*  NOTES:    ON MULTIPLE CPU SYSTEMS, THIS JOB MUST BE RUN
//*            ON THE SYSTEM WHERE DB2 EXECUTES.
//*
//**************************************************************
//*
//* TO CREATE THE ONDEMAND TABLESPACE:
//*
//* 1. PROVIDE A SUITABLE JOBCARD FOR YOUR ENVIRONMENT.
//*
//* 2. REPLACE THE FOLLOWING SYMBOLIC FIELDS:
//*    db2ssid  - DB2 SUBSYSTEM NAME
//*    LIB      - DB2 RUNTIME LOAD LIBRARY
//*    PLAN     - DEFAULT DB2 PLAN NAME IS DSNTIA10
//*    ARSUSER  - DEFAULT SQLID IS ARSUSER
//*
//* 3. (OPTIONAL) CHANGE THE FOLLOWING CREATE PARAMETERS:
//*    DATABASE   - DEFAULT DATABASE IS ARSDBASE
//*    STOGROUP   - DEFAULT STORAGE GROUP IS ARSSGRP
//*    PRIQTY     - PRIMARY TABLESPACE ALLOCATION
//*    SECQTY     - SECONDARY TABLESPACE ALLOCATION
//*    BP32K      - 32K BUFFERPOOL NAME
//*    BP0        - 4K BUFFERPOOL NAME
//*    STEPLIB    - SPECIFIES THE SDSNLOAD DATA SET
//*
//* 4. SUBMIT THE JOB.
//*
//**************************************************************
//* STEP1: CREATE THE ONDEMAND TABLESPACES
//**************************************************************
//STEP1    EXEC PGM=IKJEFT01,DYNAMNBR=20
//STEPLIB  DD DISP=SHR,DSN=?db2qual?.SDSNLOAD
//SYSTSPRT DD SYSOUT=*
//SYSTSIN  DD *
 DSN SYSTEM(db2ssid)
 RUN  PROGRAM(DSNTIAD) PLAN(?DB2PLAN?) -
      LIB('?db2run?')
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSIN    DD *
 SET CURRENT SQLID='ARSUSER';
 CREATE TABLESPACE ARSAGT
      IN ARSDBASE
      USING STOGROUP ARSSGRP
      PRIQTY 220
      SECQTY 110
      SEGSIZE 64
      LOCKSIZE ROW
      BUFFERPOOL BP0;
 CREATE TABLESPACE ARSAGFLT
      IN ARSDBASE
      USING STOGROUP ARSSGRP
      PRIQTY 292
      SECQTY 146
      SEGSIZE 64
      LOCKSIZE ANY
      BUFFERPOOL BP0;
 CREATE TABLESPACE ARSAGFAT
      IN ARSDBASE
      USING STOGROUP ARSSGRP
      PRIQTY 184
      SECQTY 92
      SEGSIZE 64
      LOCKSIZE ANY
      BUFFERPOOL BP0;
 CREATE TABLESPACE ARSAG2FT
      IN ARSDBASE
      USING STOGROUP ARSSGRP
      PRIQTY 100
      SECQTY 50
      SEGSIZE 64
      LOCKSIZE ANY
      BUFFERPOOL BP0;
 CREATE TABLESPACE ARSAGPET
      IN ARSDBASE
      USING STOGROUP ARSSGRP
      PRIQTY 320
      SECQTY 120
      SEGSIZE 64
      LOCKSIZE ANY
      BUFFERPOOL BP0;
 CREATE TABLESPACE ARSAGIDT
      IN ARSDBASE
      USING STOGROUP ARSSGRP
      PRIQTY 320
      SECQTY 120
      SEGSIZE 64
      LOCKSIZE ANY
      BUFFERPOOL BP0;
 CREATE TABLESPACE ARSANNT
      IN ARSDBASE
      USING STOGROUP ARSSGRP
      PRIQTY 2656
      SECQTY 1328
      SEGSIZE 64
      LOCKSIZE ANY
      BUFFERPOOL BP0;
 CREATE TABLESPACE ARSAPPT
      IN ARSDBASE
      USING STOGROUP ARSSGRP
      PRIQTY 3648
      SECQTY 1824
      SEGSIZE 64
      LOCKSIZE ANY
      BUFFERPOOL BP0;
 CREATE TABLESPACE ARSAPPUT
      IN ARSDBASE
      USING STOGROUP ARSSGRP
      PRIQTY 288
      SECQTY 144
      SEGSIZE 64
      LOCKSIZE ANY
      BUFFERPOOL BP0;
 CREATE TABLESPACE ARSCABT
      IN ARSDBASE
      USING STOGROUP ARSSGRP
      PRIQTY 122
      SECQTY 61
      SEGSIZE 64
      LOCKSIZE ANY
      BUFFERPOOL BP0;
 CREATE TABLESPACE ARSCABFT
      IN ARSDBASE
      USING STOGROUP ARSSGRP
      PRIQTY 100
      SECQTY 50
      SEGSIZE 64
      LOCKSIZE ANY
      BUFFERPOOL BP0;
 CREATE TABLESPACE ARSCABNT
      IN ARSDBASE
      USING STOGROUP ARSSGRP
      PRIQTY 210
      SECQTY 55
      SEGSIZE 64
      LOCKSIZE ANY
      BUFFERPOOL BP0;
 CREATE TABLESPACE ARSCABPT
      IN ARSDBASE
      USING STOGROUP ARSSGRP
      PRIQTY 160
      SECQTY 80
      SEGSIZE 64
      LOCKSIZE ANY
      BUFFERPOOL BP0;
 CREATE TABLESPACE ARSCFSWT
      IN ARSDBASE
      USING STOGROUP ARSSGRP
      PRIQTY 160
      SECQTY 80
      SEGSIZE 64
      LOCKSIZE ANY
      BUFFERPOOL BP0;
 CREATE TABLESPACE ARSCMFWT
      IN ARSDBASE
      USING STOGROUP ARSSGRP
      PRIQTY 210
      SECQTY 55
      SEGSIZE 64
      LOCKSIZE ANY
      BUFFERPOOL BP0;
 CREATE TABLESPACE ARSFOLT
      IN ARSDBASE
      USING STOGROUP ARSSGRP
      PRIQTY 122
      SECQTY 61
      SEGSIZE 64
      LOCKSIZE ANY
      BUFFERPOOL BP0;
 CREATE TABLESPACE ARSFOLFT
      IN ARSDBASE
      USING STOGROUP ARSSGRP
      PRIQTY 200
      SECQTY 100
      SEGSIZE 64
      LOCKSIZE ANY
      BUFFERPOOL BP0;
 CREATE TABLESPACE ARSFOLNT
      IN ARSDBASE
      USING STOGROUP ARSSGRP
      PRIQTY 210
      SECQTY 55
      SEGSIZE 64
      LOCKSIZE ANY
      BUFFERPOOL BP0;
 CREATE TABLESPACE ARSFOLUT
      IN ARSDBASE
      USING STOGROUP ARSSGRP
      PRIQTY 100
      SECQTY 50
      SEGSIZE 64
      LOCKSIZE ANY
      BUFFERPOOL BP0;
 CREATE TABLESPACE ARSFOLPT
      IN ARSDBASE
      USING STOGROUP ARSSGRP
      PRIQTY 40
      SECQTY 20
      SEGSIZE 64
      LOCKSIZE ANY
      BUFFERPOOL BP0;
 CREATE TABLESPACE ARSFTIWT
      IN ARSDBASE
      USING STOGROUP ARSSGRP
      PRIQTY 210
      SECQTY 55
      SEGSIZE 64
      LOCKSIZE ANY
      BUFFERPOOL BP0;
 CREATE TABLESPACE ARSGROUT
      IN ARSDBASE
      USING STOGROUP ARSSGRP
      PRIQTY 16
      SECQTY 8
      SEGSIZE 64
      LOCKSIZE ANY
      BUFFERPOOL BP0;
 CREATE TABLESPACE ARSHLDT
      IN ARSDBASE
      USING STOGROUP ARSSGRP
      PRIQTY 16
      SECQTY 8
      SEGSIZE 64
      LOCKSIZE ANY
      BUFFERPOOL BP0;
 CREATE TABLESPACE ARSHLDMT
      IN ARSDBASE
      USING STOGROUP ARSSGRP
      PRIQTY 16
      SECQTY 8
      SEGSIZE 64
      LOCKSIZE ANY
      BUFFERPOOL BP0;
 CREATE TABLESPACE ARSHLDNT
      IN ARSDBASE
      USING STOGROUP ARSSGRP
      PRIQTY 210
      SECQTY 55
      SEGSIZE 64
      LOCKSIZE ANY
      BUFFERPOOL BP0;
 CREATE TABLESPACE ARSHLDPT
      IN ARSDBASE
      USING STOGROUP ARSSGRP
      PRIQTY 16
      SECQTY 8
      SEGSIZE 64
      LOCKSIZE ANY
      BUFFERPOOL BP0;
 CREATE TABLESPACE ARSHLDWT
      IN ARSDBASE
      USING STOGROUP ARSSGRP
      PRIQTY 16
      SECQTY 8
      SEGSIZE 64
      LOCKSIZE ANY
      BUFFERPOOL BP0;
 CREATE TABLESPACE ARSLOADT
      IN ARSDBASE
      USING STOGROUP ARSSGRP
      PRIQTY 348
      SECQTY 174
      SEGSIZE 64
      LOCKSIZE ANY
      BUFFERPOOL BP0;
 CREATE TABLESPACE ARSLDWKT
      IN ARSDBASE
      USING STOGROUP ARSSGRP
      PRIQTY 16
      SECQTY 8
      SEGSIZE 64
      LOCKSIZE ANY
      BUFFERPOOL BP0;
 CREATE TABLESPACE ARSNAMET
      IN ARSDBASE
      USING STOGROUP ARSSGRP
      PRIQTY 224
      SECQTY 112
      SEGSIZE 64
      LOCKSIZE ANY
      BUFFERPOOL BP0;
 CREATE TABLESPACE ARSNODET
      IN ARSDBASE
      USING STOGROUP ARSSGRP
      PRIQTY 12
      SECQTY 12
      SEGSIZE 4
      LOCKSIZE ANY
      BUFFERPOOL BP0;
 CREATE TABLESPACE ARSPRTT
      IN ARSDBASE
      USING STOGROUP ARSSGRP
      PRIQTY 20
      SECQTY 10
      SEGSIZE 4
      LOCKSIZE ANY
      BUFFERPOOL BP0;
 CREATE TABLESPACE ARSPRTOT
      IN ARSDBASE
      USING STOGROUP ARSSGRP
      PRIQTY 12
      SECQTY 12
      SEGSIZE 4
      LOCKSIZE ANY
      BUFFERPOOL BP0;
 CREATE TABLESPACE ARSPRUST
      IN ARSDBASE
      USING STOGROUP ARSSGRP
      PRIQTY 24
      SECQTY 12
      SEGSIZE 4
      LOCKSIZE ANY
      BUFFERPOOL BP0;
 CREATE TABLESPACE ARSREST
      IN ARSDBASE
      USING STOGROUP ARSSGRP
      PRIQTY 188
      SECQTY 94
      SEGSIZE 64
      LOCKSIZE ANY
      BUFFERPOOL BP0;
 CREATE TABLESPACE ARSSEGT
      IN ARSDBASE
      USING STOGROUP ARSSGRP
      PRIQTY 172
      SECQTY 86
      SEGSIZE 64
      LOCKSIZE ROW
      BUFFERPOOL BP0;
 CREATE TABLESPACE ARSSETT
      IN ARSDBASE
      USING STOGROUP ARSSGRP
      PRIQTY 12
      SECQTY 12
      SEGSIZE 4
      LOCKSIZE ANY
      BUFFERPOOL BP0;
 CREATE TABLESPACE ARSSYST
      IN ARSDBASE
      USING STOGROUP ARSSGRP
      PRIQTY 96
      SECQTY 96
      SEGSIZE 8
      LOCKSIZE ANY
      BUFFERPOOL BP0;
 CREATE TABLESPACE ARSUSERT
      IN ARSDBASE
      USING STOGROUP ARSSGRP
      PRIQTY 344
      SECQTY 172
      SEGSIZE 64
      LOCKSIZE ANY
      BUFFERPOOL BP0;
 CREATE TABLESPACE ARSUSRGT
      IN ARSDBASE
      USING STOGROUP ARSSGRP
      PRIQTY 24
      SECQTY 12
      SEGSIZE 4
      LOCKSIZE ANY
      BUFFERPOOL BP0;
 CREATE TABLESPACE ARSUSGIT
      IN ARSDBASE
      USING STOGROUP ARSSGRP
      PRIQTY 24
      SECQTY 12
      SEGSIZE 4
      LOCKSIZE ANY
      BUFFERPOOL BP0;
 CREATE TABLESPACE ARSSLUT
      IN ARSDBASE
      USING STOGROUP ARSSGRP
      PRIQTY 16
      SECQTY 8
      SEGSIZE 64
      LOCKSIZE ANY
      BUFFERPOOL BP32K;

The following list describes the JCL statements in Figure 1:

//ARSTSPAC 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 ARSTSPAC job. Verify the following parameter values:

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

//SYSIN DD

Specifies the parameters for the ARSTSPAC job. Verify the following parameter values:

SQLID='arsuser'

Specify the SQLID for the database. The value for arsuser must be the same as the value 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. For information about specifying values in the ars.ini files, see Verify the ARS.INI file.

TABLESPACE name_of_table_space

Specify the name of the table space where the ARSTPAC job stores the Content Manager OnDemand system tables it creates. If you want to use the default names, use the values specified in the ARSTPAC member. If you want to create custom names, specify the custom names for each table space in name_of_table_space and see Building tables and indexes into custom table spaces.

IN ARSDBASE

Specify the name of the Content Manager OnDemand database.

Note:

The database name must match the value 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. For information about specifying values in the ars.ini files, see Verify the ARS.INI file.
The database name must match the value that you specified when you created the database in Creating the storage group and database.

STOGROUP ARSSGRP

Specify the name for the storage group. This value must match the value that you specified when you created the storage group in Creating the storage group and database).

PRIQTY

Specify the primary table space allocation.

SECQTY

Specify the secondary table space allocation.

BUFFERPOOL

Specify the name of the bufferpool.

What to do next

Existing installations that are using a single tablespace are not required to migrate to multiple table spaces. However, if you choose to, you can migrate using the following steps:

Shutdown the ARSSOCKD server.
Backup the ARSDBASE database.
Run /usr/lpp/ars/V9R5M0/bin/arsdb to export the Content Manager OnDemand system tables.
DROP TABLESPACE ARSTSPAC.
Run the ARSTSPAC job.
Run /usr/lpp/ars/V9R5M0/bin/arsdb -trs to create the tables in the new table spaces.
Run arsdb -i to import the Content Manager OnDemand system tables.
Restart the ARSSOCKD server.