New and changed system stored procedures support Tivoli Storage Manager, and in-memory and relaxed-durability databases.
| System stored procedures | Description |
|---|---|
| sp_deletesmobj | Deletes backup objects from the TSM. |
| sp_querysmobj | Retrieves a list of backup objects from the TSM. |
| 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.