Difference between revisions of "arsdb"

Jump to navigation Jump to search
219 bytes removed ,  15:59, 24 March 2018
Updated for IBM CMOD v10.1
m (Added paragraph about ARS0013E and ARS0014I error messages during arsdb commands.)
(Updated for IBM CMOD v10.1)
Line 50: Line 50:
This is the online help for arsdb included with CMOD v8.5.0.8:
This is the online help for arsdb included with CMOD v8.5.0.8:


  $ /opt/ondemand/bin/arsdb
$ arsdb  
  Usage: arsdb [options] [table(s)]
ARS4010I Usage: arsdb [options] [table(s)]
        Version:  8.5.0.8
Version:  10.1.0.2
        -c (DB2/MSSQL) Create the OnDemand database
-c (DB2/MSSQL) Create the OnDemand database
        -d Drop the OnDemand system tables
-d Drop the OnDemand system tables
        -e Drop the OnDemand system indexes
-e Drop the OnDemand system indexes
        -f Ignore DB Failures
-f Ignore DB Failures
        -g (DB2/MSSQL) Start the OnDemand database
-F Do not prompt
        -h (DB2/MSSQL) Stop the OnDemand database
-g (DB2/MSSQL) Start the OnDemand database
        -i Import data to the OnDemand system tables
-h (DB2/MSSQL) Stop the OnDemand database
        -I <od_inst> OnDemand instance name
-i Import data to the OnDemand system tables
        -k (DB2) Activate the OnDemand database
-I <od_inst> OnDemand instance name
        -m (DB2/MSSQL) Run Maintenance for the OnDemand system tables
-k (DB2) Activate the OnDemand database
        -o <filename> Output file name
-m (DB2/MSSQL) Run Maintenance for the OnDemand system tables
        -O OnDemand Distribution Facility (ODF)
-o <filename> Output file name
        -r Create indexes for the OnDemand system tables
-O OnDemand Distribution Facility (ODF)
        -R Report Distribution Facility (RDF)
-r Create indexes for the OnDemand system tables
        -s Run statistics on the OnDemand system tables
-s Run statistics on the OnDemand system tables
        -t Create the OnDemand system tables
-t Create the OnDemand system tables
        -u Update the OnDemand system tables
-u Update the OnDemand system tables
        -v Verbose
-v Verbose
        -x Export data from the OnDemand system tables
-x Export data from the OnDemand system tables
        -y <device> (DB2) Backup the OnDemand database offline to the device
-y <device> (DB2) Backup the OnDemand database offline to the device
                    (MSSQL) Complete OnDemand database backup to the device
            (MSSQL) Complete OnDemand database backup to the device
        -Y <device> (DB2) Backup the OnDemand database tablespace(s) offline to the device
-Y <device> (DB2) Backup the OnDemand database tablespace(s) offline to the device
        -X (DB2 only) If -Y or -Z, don't backup tablespace USERSPACE1
-X (DB2 only) If -Y or -Z, don't backup tablespace USERSPACE1
        -z <device> (DB2) Backup the OnDemand database online to the device
-z <device> (DB2) Backup the OnDemand database online to the device
                    (MSSQL) Differential OnDemand database backup to the device
            (MSSQL) Differential OnDemand database backup to the device
        -Z <device> (DB2) Backup the OnDemand database tablespace(s) online to the device
-Z <device> (DB2) Backup the OnDemand database tablespace(s) online to the device

Navigation menu