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.
To create the table spaces, do the following steps:
//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;
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: