Db2®

About this task

Run the following CREATE commands to create tables spaces that are used for the ODF system tables when using Db2®.

Procedure

  1. Modify the sample CREATE command to create the table spaces listed. The CREATE command must be run multiple times, once for each of the table spaces names. The example shows the CREATE command for the first table space in the list.
  2. Submit the job to run the CREATE commands.
  3. Check the completion status to confirm that the table spaces were created successfully.

Example

Linux only:AIX only:For Content Manager OnDemand for Multiplatforms, use the following sample to create each of the table spaces listed. For example, to create the table space for table ARSDFBDT:
                                                               
# db2 connect to ODinstance 
                                                               
CREATE TABLESPACE ARSDFBDT;
z/OS only:For Content Manager OnDemand for z/OS®, use the following sample to create each of the table spaces listed. For example, to create the table space for table ARSDFBDT:
                                                               
SET CURRENT SQLID='ARCHIVE';                                  
                                                               
CREATE TABLESPACE ARSDFBDT                
       IN         ARSDBASE                
       USING      STOGROUP ARSSGRP        
       PRIQTY     200                     
       SECQTY     40                      
       LOCKSIZE   ANY                     
       CLOSE      NO                      
       BUFFERPOOL BP0;
For Content Manager OnDemand for z/OS, a sample job for creating table spaces is available in SARSINST (ARSTBODF).
Use appropriate sample for your platform to create these table spaces:
  • ARSDFBDT
  • ARSDFDCT
  • ARSDFDRT
  • ARSDFDST
  • ARSDFLIS
  • ARSDFPPT
  • ARSDFUOT
  • ARSDFCRT
  • ARSDFEML

Linux only:AIX only:Verify or replace the following parameter in the CREATE command example for Content Manager OnDemand for Multiplatforms:

ODinstance
The Content Manager OnDemand instance database name to which the ODF tables and table spaces belong.

z/OS only:Verify or replace the following parameters in the CREATE command example for Content Manager OnDemand for z/OS:

SQLID='ARCHIVE'
The SQLID that is specified for the database should be the same as that specified for the SRVR_INSTANCE_OWNER parameter in the ARS.INI file. The default value in the ARS.INI file is ARCHIVE. (See “Verify the ARS.INI file” in the IBM® Content Manager OnDemand for z/OS: Configuration Guide.)
IN ARSDBASE
Specifies 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 ARS.INI file. The default value in the ARS.INI file is ARSDBASE. (See “Verify the ARS.INI file” in the IBM Content Manager OnDemand for z/OS: Configuration Guide.)
USING STOGROUP ARSSGRP
Specifies the name for the storage group.