86 IBM Content Manager OnDemand Guide
4.6.1  System tables for Content Manager OnDemand z/OS
For the Content Manager OnDemand z/OS DB2 database environment, standard database 
backup and recovery procedures can be used for the databases, table spaces, and tables that 
are created by Content Manager OnDemand. To minimize the effort of creating and 
monitoring the Content Manager OnDemand data tables, several automated table creation 
and space allocation procedures are part of the product. 
All system tables are created by the arsdb program. Each table is created in its own table 
space. During the installation, the table space is created by member ARSTSPAC in dataset 
V9R5M0.SARSINST. The size of each table space is specified in dataset 
V9R5M0.SARSINST. Before you run ARSTSPAC to create the Content Manager OnDemand 
table spaces, you must create the storage group and the database. The CREATE for the 
storage group and database is in member ARSDB2 in dataset V9R5M0.SARSINST. The 
owner of the database (the submitter of the job or the user ID that is set by the “Set current 
SQLID =‘username’) must match the entry SRVR_INSTANCE_OWNER in the ARS.INI file.
The arsdb program provides an interface between the database manager and Content 
Manager OnDemand. Several parameters are used in the creation and dropping of tables. 
For more information about arsdb, see the IBM Content Manager OnDemand for z/OS - 
Configuration Guide, SC19-3363.
The arsdb program is in the UNIX System Services file system /usr/lpp/ars/V9R5M0/bin. 
When you create the Content Manager OnDemand tables or indexes, the arsdb command 
can build the tables and indexes in the default table space or in table spaces that you create 
by using the ARSTSPAC member. 
When you run the arsdb command, Content Manager OnDemand validates the existence of 
the table space. If the table space does not exist, the arsdb command creates the Content 
Manager OnDemand system tables in the default table space. After you create the Content 
Manager OnDemand table spaces, if changes are required, the best way to change the table 
space is by running the ALTER TABLESPACE command. 
4.6.2  Data tables for Content Manager OnDemand z/OS
The data tables in Content Manager OnDemand are created under the control of DB2 on 
z/OS. Like the system tables, the data tables in Content Manager OnDemand are created 
dynamically during the arsload process. It is important to understand how Content Manager 
OnDemand on z/OS allocates space for these tables because they can grow large. 
During the creation of an application group, a parameter limits the maximum rows for a data 
table. If this limit is reached, Content Manager OnDemand creates another data table during 
the arsload process. By using the Administrative Client, you can set the maximum row value 
for an application group data table. This value is on the Advanced section of the General tab 
in the application group configuration. The field is called Maximum Rows. 
The space allocation is performed automatically. No further action needs to be performed by 
the DBA except to set up the backup of the newly created tables and plan for the new 
resources that are needed for the next couple of months.
For more information about space requirements, see the IBM Content Manager OnDemand 
for z/OS - Introduction and Planning Guide, SC19-3651.