Parameters

-d
Drop tables from the database. The default is all tables. To drop a specific table, use the -d tableName form of the command, where tableName is the name of the Content Manager OnDemand system table.
-e
Drops all the indexes for the specified Content Manager OnDemand system table (using -e tableName). The default, if no tableName is specified, is to drop all indexes for all Content Manager OnDemand system tables.
-f
Ignore database manager failures.
-i
Import tables. The default is all Content Manager OnDemand system tables. To import a specific table, use the -i tableName form of the command, where tableName is the name of the Content Manager OnDemand system table (and the name of the file that contains the table to be imported). Content Manager OnDemand reads the file from the directory in which the ARSDB program was invoked.
Important: The -i parameter should only be used to import tables from files that are created with the -x parameter when the system tables exist in multiple table spaces.
-I instance
The name of the Content Manager OnDemand instance to process. The ARSDB program will attempt to locate the specified instance name in the ARS.INI file, to obtain the TCP/IP address, host name or host name alias of the system on which the instance is running. If the ARSDB program cannot locate the instance name in the ARS.INI file, then the specified value is treated as a host name.
You must specify the -I parameter and name the instance if:
  • The name of the default instance is not ARCHIVE
  • You are running more than one instance on the same system and you want to process an instance other than the default instance
Note: If you are running multiple instances of Content Manager OnDemand on the same system, then you should always specify the -I parameter to identify the name of the instance that you want to process. You should also verify that the ARS.INI file is configured with the correct information for all instances of Content Manager OnDemand. See the IBM Content Manager OnDemand for z/OS®: Configuration Guide, for more information about working with multiple instances of Content Manager OnDemand.
-m
Performs maintenance on system tables.
-o <filename>
Create the output file name.
-O
Parameter to identify the Content Manager OnDemand Distribution Facility. With the exception of the -d parameter, parameters specified with the ARSDB program will only be performed on the Content Manager OnDemand Distribution Facility tables if the -O parameter is specified.
-r
Create configuration indexes. The default is all indexes. To configure a specific index, use the -r tablename form of the command, where tableName is the name of the Content Manager OnDemand system table.
-s
Run database statistics. Use this parameter to optimize indexes and tables and make access to information as efficient as possible. The default is all Content Manager OnDemand system tables. To run statistics for a specific table, use the -s tableName form of the command, where tableName is the name of the Content Manager OnDemand system table.
-t
Create configuration tables. The default is all Content Manager OnDemand system tables. To configure a specific table, use the -s tableName form of the command, where tableName is the name of the Content Manager OnDemand system table.
-u
Updates the Content Manager OnDemand system tables with new changes whenever you upgrade Content Manager OnDemand. Use this option only when you are explicitly directed by IBM®.
-v
Enables verbose mode, to display all messages (informational and error). By default, the ARSDB program displays only error messages.
-x
Export tables. The default is all Content Manager OnDemand system tables. To export a specific table, use the -x tablename form of the command, where tableName is the name of the Content Manager OnDemand system table (and also the name of the file that Content Manager OnDemand creates). Content Manager OnDemand writes the file in the directory from which the ARSDB program was invoked.
tableName
Optionally specify the name of one or more Content Manager OnDemand system tables for the drop (-d and -e) and create configuration (-r and -t) parameters. If you do not specify the tableName parameter, then Content Manager OnDemand runs the command for all of the system tables.
-1 trace_file
Specify a fully qualified trace file name as directed by IBM Software Support.
-2 level
Specify a value as directed by IBM Software Support.