Chapter 1: System Procedures

sp_dbremap

Description

Forces Adaptive Server to recognize changes made by alter database. Run this procedure only when instructed to do so by an Adaptive Server message.

Syntax

sp_dbremap dbname

Parameters

dbname: is the name of the database in which the alter database command was interrupted.

Examples

Example 1

An alter database command changed the database sample_db. This command makes the changes visible to Adaptive Server:

sp_dbremap sample_db

Usage

If an alter database statement issued on a database that is in the process of being dumped is interrupted, Adaptive Server prints a message instructing the user to execute sp_dbremap.
Any changes to sysusages during a database or transaction dump are not copied into active memory until the dump completes, to ensure that database mapping does not change during the dump. Running alter database makes changes to system tables on the disk immediately. In-memory allocations cannot be changed until a dump completes. This is why alter database pauses.

When you execute sp_dbremap, it must wait until the dump process completes.
If you are instructed to run sp_dbremap, but do not do it, the space you have allocated with alter database does not become available to Adaptive Server until the next restart.

Permissions

Only a System Administrator or Database Owner can execute sp_dbremap.

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