|
You use the DEACT command to deactivate online extensibility for DBTTs and realms.
Deactivating online DBTT extensibility for a record type (DEACT DBTT-INCR)
dbname | Name of the database comprising the record type or types for which online DBTT extension is to be deactivated. The database and the corresponding realm must already be attached at the time the DAL command is issued. |
recordref | |
Number of the user record type for which online DBTT extension is to be deactivated. If it is to be deactivated for all record types then this specification can be omitted. You can display the recordrefs of the record types using the DAL command DISPLAY DBTT-INCR or take them from the BPSIA log. recordref=1 is used internally by UDS/SQL and cannot be specified here. | |
The DEACT DBTT-INCR command is used either to note a request for the deactivation of online DBTT extension or to cancel a preceding ACT DBTT-INCR request.
The request is not executed until the PERFORM command has been issued. The message UDS0722 informs you about command execution as follows
If a deactivation request has been executed for all record types then a single message is output for the database.
If deactivation request has been executed for a single record type then a record typespecific message is output.
If deactivation requests have been executed for individual record types as well as for all record types then a single message is output for the database.
If, on the deactivation of an online DBTT extension for all the record types in a database, a realm with DBTTs is not attached, then the deactivation is not carried out for the corresponding record types. The message UDS0744 informs you of the realm in question.
With DEACT DBTT-INCR, extent size, specified previously in ACT DBTT-INCR EXT=extnmbr is reset.
The command DEACT DBTT-INCR is immediately rejected with the message UDS0209 if
the specified record type number does not exist.
the specified database is not attached or is attached in SHARED-RETRIEVAL mode.
the corresponding DBTT realm is not attached for a specified record type. The message UDS0745 informs you of the realm in question.
a deactivation request for online DBTT extension for all record types in a database does not result in deactivation or the cancellation of a contrary request for any record type.
Deactivating online extensibility for a realm (DEACT INCR)
dbname
Name of the database of the realm or realms for which online extensibility is to be deactivated. The database must be active when the command is issued. The database must not be in SHARED-RETRIEVAL mode.
realmref
Number of the realm for which online extensibility is to be deactivated. The realm must be active when the command is executed. The numbers of the active realms can be displayed with DISPLAY INCR.
The numbers of all user realms and of the DBDIR are permitted. It is not permissible to specify the number of the DBCOM.
The command DEACT INCR can note a request to deactivate online extensibility, for the realm realmref of the database dbname. If RR=realmref is not specified, the command is executed for all user realms which have just been activated and for the DBDIR of the database dbname.
DEACT INCR can also cancel a previously entered ACT INCR command, provided that the commands have not already been executed with PERFORM. DEACT INCR is only ever executed once PERFORM has been specified.
DAL requests pending in addition to DEACT INCR may also contain requests to drop the relevant realms or databases. It does not matter whether these DROP requests are entered before or after the DEACT INCR. When PERFORM is issued, the DEACT INCR requests for a database are always processed first. For information on executing pending DAL commands, see also "Command execution" in chapter "The Database Administrator Language DAL".
If the specified realm(s) cannot be extended online, DEACT INCR is ignored.
Any outstanding EXTEND-DBTT requests that have not yet been executed since no record has been stored since the request was noted are canceled without any notification to the user when DEACT INCR is run.
The command DEACT INCR is immediately rejected, if:
the database dbname has not been activated or has been activated in SHARED-RETRIEVAL mode.
the specified realm number realmref does not exist.
the DBCOM realm number was specified as the realm number realmref.
the specified realm has not been activated.
at least one online DBTT extension is activated for the realm or an online DBTT extension request has already been noted for the realm. Message UDS0738 informs you of the realm in question.