Forces Adaptive Server to recognize changes made by alter database. Run this procedure only when instructed to do so by an Adaptive Server message.
sp_dbremap dbname
is the name of the database in which the alter database command was interrupted.
An alter database command changed the database sample_db. This command makes the changes visible to Adaptive Server:
sp_dbremap sample_db
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.
The permission checks for sp_dbremap differ based on your granular permissions settings.
Granular permissions enabled |
With granular permissions enabled, you must be the database owner or a user with own database privilege on the database. |
Granular permissions disabled |
With granular permissions disabled, you must be the database owner or a user with sa_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 |
|
Commands alter database, dump database, dump transaction