sp_deletesmobj

Deletes specified backup objects from the IBM Tivoli Storage Manager (TSM).

sp_deletesmobj is supported only when the TSM is licensed at your site.

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 Adaptive 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.

Removes all TSM backup objects created at the Adaptive Server “svr1.”

sp_deletesmobj "syb_tsm", "svr1"

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"

Is the verbage for example 3 correct?

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"

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"

For more information about Sybase support for the TSM, see THE TSM BOOK.

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

Granular permissions enabled	With granular permissions enabled, you must be a user with dump any database privilege.
Granular permissions 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:

Event	Audit option	Command or access audited	Information in extrainfo
38	exec_procedure	Execution of a procedure	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.