Chapter 2. Setting up a Content Manager OnDemand instance 41
A sample ARSLOAD procedure is provided in the SARSINST library. 
Creating the database for the new instance
The new instance uses its own set of tables. A new database must be created for this new 
instance. Perform this task by modifying the ARSDB2 member in the SARSINST library, which 
is used for the initial installation. Several modifications of this job are necessary:
/SM590000Change the SQLID to another user, who must have sysadm authority.
/SM590000Optional: Change the Create Storage Group Statement if you want a new storage group 
for the instance.
/SM590000Change the Create Database Statement.
/SM590000Run the job.
Creating the table space
The new instance uses its own tables, so table space is needed. Y ou can accomplish this task 
by modifying the ARSTSPAC member in the SARSINST library, which is used for the initial 
installation. Make the following modifications:
/SM590000Change the SQLID to the same user that creates the database in ARSDB2.
/SM590000Change the IN parameter of the CREATE TABLESPACE statement to the database name that 
you previously created in ARSDB2.
/SM590000Change the USING parameter to the STOGROUP name that you previously used in 
ARSDB2.
/SM590000Set the appropriate values for the primary and secondary allocation.
/SM590000Run the job.
Creating tables for the new instance
After all of the DB2 objects are created and the configuration files are updated, the database 
for the instance (the system tables) must be created. Use the arsdb program to create the 
database for the instance.
To create the tables, complete the following steps:
1. Go into OMVS to set up the ODBC environment.
2. Switch to the superuser (SU).
3. Set the environment variables to access DB2 on z/OS by running the following command:
export DSNAOINI=“/etc/ars/cli.ini” 
The minimum parameters are the DB2 SSID and the interface (DSNCLI). 
4. Run SET from the OMVS command line.
5. Move to the Content Manager OnDemand executable directory by running the following 
command:
cd /usr/lpp/ars/V9R5M0/bin
Important: Y ou must identify the instance name when you run the Content Manager 
OnDemand programs, such as the arsdb, arsload, and arssockd programs, and when you 
run the database commands.