12.3 SDM Command Line

The SDM command line functions can be used instead of the GUI. The command line can be used to create a batch file or cron job for SDM operations, but Novell recommends using auto-archiving instead. Auto-archiving can be configured on the Partition Configuration tab of the SDM GUI.

The first step to using the SDM command line is to create a file that stores the connection properties for the database.

12.3.1 General Syntax of the SDM command

[path to SDM] –action [actionname] [action-specific flags] [path to database connection file]

The specific flags for each action are described below.

12.3.2 Starting SDM GUI

startGui (DEFAULT)
-action startGui [-connectFile <filePath>]

12.3.3 Viewing Sentinel Database Space Usage

In Tablespace Management, the command line option allows you to:

  • View Sentinel database space usage

This action (dbstats) displays the Sentinel database usage for all Sentinel tablespaces in Oracle and Sentinel filegroups in MS SQL.

This command uses the following flags:

Table 12-2 Viewing Sentinel Database Space Usage flags

-action

dbstats

-connectFile

<filePath>

To view Sentinel Database Space Usage (Command Line):

  1. Execute the following command:

    -action dbStats -connectFile <filePath>
    

    The following example displays the tablespaces of Sentinel database with their total space, used space and free space available.

    • Oracle Example:

      ./sdm –action dbStats –connectFile sdm.connect
      
    • SQL Server Example:

      Sdm –action dbStats –connectFile sdm.connect