sp_deletesmobj

Description

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

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

Syntax

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

Parameters

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.

Examples

Example 1

Removes all TSM backup objects created at the Adaptive Server “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"

Is the verbage for example 3 correct?

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"

Usage

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

Permissions

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.

Auditing

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.

See also

sp_querysmobj