sp_deletesmobj

(Only when the TSM is licensed at your site) Deletes specified backup objects from the IBM Tivoli Storage Manager (TSM).

Syntax

sp_deletesmob “syb_tsm“, “server_name"{, “database_name”, “object_type”, “dump_type", “until_time", “bs_name"}

syb_tsm – is the keyword that invokes the libsyb_tsm.so module that enables communication with TSM.
server_name – is the name of the SAP ASE server associated with the TSM backup objects to be deleted.
database_name – is the name of the database associated with the TSM backup objects to be deleted. 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 deleted. An asterisk (*) indicates all backup objects.
dump_type – is the backup object type to be deleted. 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 field. All backup objects matching the specified criteria and created before the until_time date are deleted.
bs_name – is the name of the remote Backup Server. If bs_name is omitted, the default is SYB_BACKUP.

Example 1 – Removes all TSM backup objects created at the SAP ASE “svr1.”
```
sp_deletesmobj "syb_tsm", "svr1"
```
Example 2 – Removes all backup objects of the testdb database created by “svr1” before May 20, 2009, 10:51:43:866am. The backup object name is “obj1.dmp.”
```
sp_deletesmobj "syb_tsm", "svr1", "testdb", "obj1.dmp",
    "*", "may 20, 2009 10:51:43:866am"
```
Example 3 – Removes all backup objects of the “testdb” database created by “svr1” of dump database type before May 21, 2009, 10:51:43:866 a.m.
```
sp_deletesmobj "syb_tsm", "svr1", "’testdb", "*", "DB",
    "may 21, 2009 10:51:43:866am"
```
Example 4 – Removes all backup objects of “testdb” created by “svr1” of dump transaction type before May 20, 2009, 10:51:43:866 a.m.
```
sp_deletesmobj "syb_tsm", "svr1", "testdb",
    "/tmp/obj1.dmp", "*", "XACT", "may 21, 2009
    10:51:43:866am"
```

See also Using Backup Server with IBM Tivoli Storage Manager.

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

Setting	Description
Enabled	With granular permissions enabled, you must be a user with `dump any database` privilege.
Disabled	With granular permissions disabled, you must be a user with sa_role or oper_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.