System Stored Procedures

New and changed system stored procedures support Tivoli Storage Manager, and in-memory and relaxed-durability databases.

New system stored procedures
System stored procedures Description
sp_deletesmobj Deletes backup objects from the TSM.
sp_querysmobj Retrieves a list of backup objects from the TSM.
Changed system stored procedures
System stored procedures Description
sp_addsegment Updated to manage space in in-memory databases.
sp_addthreshold Updated to manage space in in-memory databases.
sp_bindcache You cannot bind objects or databases to in-memory storage caches, and you cannot bind an in-memory database or objects in an in-memory database to any cache.
sp_cacheconfig Creates, extends the size of, or drops, an in-memory storage cache.
sp_cachestrategy The prefetch and MRU parameters do not apply to tables and indexes in in-memory databases.
sp_dbextend Automatic database expansion is currently not supported for in-memory databases.
sp_deviceattr The directio and dsync device attributes do not apply to in-memory devices.
sp_downgrade Supports downgrading an Adaptive Server containing in-memory or relaxed-durability databases, or databases using templates or minimal logging.
sp_diskdefault You cannot use sp_diskdefault to specify in-memory devices as a default devices.
sp_dropdevice Drops an in-memory device created from an in-memory storage cache.
sp_dropsegment Updated to manage space in in-memory databases.
sp_dropthreshold Updated to manage space in in-memory databases.
sp_extendsegment Updated to manage space in in-memory databases.
sp_help Reports on properties, such as minimal logging attribute, for a table.
sp_helpcache Displays properties of the in-memory storage cache, the in-memory database created on it, and details of free space on this cache.
sp_helpdb Reports on database properties, such as durability, DML logging level, in-memory or not, use, if any, of a template database, or as a template database.
sp_helpdevice Reports the in-memory device properties created from an in-memory storage cache.
sp_modifythreshold Updated to manage space in in-memory databases.
sp_plan_dbccdb Sets up dbccdb for checkstorage execution in an in-memory database.
sp_poolconfig Large I/O buffer pools are not supported in an in-memory database.
sp_post_xpload Supports cross-platform operations for in-memory databases.
sp_tempdb Supports user-created temporary database groups, login or application bindings to temporary database groups and for in-memory databases.
sp_unbindcache, sp_unbindcache_all You cannot unbind objects in or the in-memory database itself from the host in-memory storage cache.

See the Reference Manual: Procedures.