sp_querysmobj

(Only when the TSM is licensed at your site) Queries the Tivoli Storage Manager (TSM) for a list of the SAP ASE backup objects.

Syntax

sp_querysmobj “syb_tsm”, “output_file”, “server_name”
	{, “database_name”, “object_name”, “dump_type”,
	“until_time”, “bs_name”}

syb_tsm – is the keyword that invokes the libsyb_tsm.so module that enables communication with TSM.
output_file – is the file to which Backup Server writes the list of TSM backup objects.
server_name – is the name of the SAP ASE server associated with the TSM backup objects.
database_name – is the name of the database associated with the TSM backup objects. An asterisk (*) indicates all databases.
object_name – is the name of theTSM backup object as provided in the dump database or dump transaction command. If this parameter is omitted, all backup objects are queried. An asterisk (*) indicates all backup objects.
dump_type – is the backup object type to be queried. Valid values are:
- DB – database backup objects created by the dump database command.
- XACT – database backup objects created by the dump transaction command.
- * – all database backup objects. This is the default.
until_time – is the date timestamp. All backup objects matching the criteria entered in sp_querysmobj before the specified time are queried. If you omit this parameter, all backup objects matching the specified criteria are queried.
bs_name – is the name of the remote Backup Server. If bs_name is omitted, the default, SYB_BACKUP, is used.

Example 1 – Queries all TSM backup objects for the SAP ASE “demo_svr1” and writes the list to /tmp/qtsm/5_1.out.
```
sp_querysmobj "syb_tsm", "/tmp/qtsm/5_1.out", "demo_srv1"
```
Example 2 – Queries all TSM backup objects for the SAP ASE “demo_svr1” and the database pubs2 and writes the list to /tmp/qtsm/5_2.out.
```
sp_querysmobj "syb_tsm", "/tmp/qtsm/5_2.out", "demo_srv1", "pubs2"
```
Example 3 – Queries all TSM database backup objects for the SAP ASE “demo_svr1” and the database pubs2 and writes the list to /tmp/qtsm/5_3.out.
```
sp_querysmobj "syb_tsm", "/tmp/qtsm/5_3.out", "demo_srv1", "pubs2", "*", "DB"
```

See also Using Backup Server with IBM Tivoli Storage Manager.

The permission checks for sp_querysmobj differ based on your granular permissions settings.

Setting	Description
Enabled	With granular permissions enabled, you must have `dump any database` privilege.
Disabled	With granular permissions disabled, you must be a user with sa_role.

Values in event and extrainfo columns from the sysaudits table are:

Information	Values
Event	38
Audit option	exec_procedure
Command or access audited	Execution of a procedure
Information in `extrainfo`	Roles – Current active roles Keywords or options – NULL Previous value – NULL Current value – NULL Other information – All input parameters Proxy information – Original login name, if set proxy in effect