Difference between revisions of "arsdb"

Jump to navigation Jump to search
28 bytes added ,  16:00, 24 March 2018
m
Formatting.
(Updated for IBM CMOD v10.1)
m (Formatting.)
 
Line 48: Line 48:
== Usage ==
== Usage ==


This is the online help for arsdb included with CMOD v8.5.0.8:
This is the online help for arsdb included with CMOD v10.1.0.2:


  $ arsdb  
  $ arsdb  
  ARS4010I Usage: arsdb [options] [table(s)]
  ARS4010I Usage: arsdb [options] [table(s)]
Version:  10.1.0.2
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
-F Do not prompt
-F Do not prompt
-g (DB2/MSSQL) Start the OnDemand database
-g (DB2/MSSQL) Start the OnDemand database
-h (DB2/MSSQL) Stop the OnDemand database
-h (DB2/MSSQL) Stop the OnDemand database
-i Import data to the OnDemand system tables
-i Import data to the OnDemand system tables
-I <od_inst> OnDemand instance name
-I <od_inst> OnDemand instance name
-k (DB2) Activate the OnDemand database
-k (DB2) Activate the OnDemand database
-m (DB2/MSSQL) Run Maintenance for the OnDemand system tables
-m (DB2/MSSQL) Run Maintenance for the OnDemand system tables
-o <filename> Output file name
-o <filename> Output file name
-O OnDemand Distribution Facility (ODF)
-O OnDemand Distribution Facility (ODF)
-r Create indexes for the OnDemand system tables
-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