Line commands (Database)
In database views with a line command area, you can use the following line commands.
Line commands | Result |
|---|---|
P PDPG PDG NPA | Stop a database This command issues the IMS /STOP DATABASE command to stop a database. Instead of closing the database, the STOP command prevents subsequently scheduled programs from accessing the database. Programs that were already scheduled are not affected. P and PD stop the database on the target IMS subsystem. PG and PDG stop the database on all IMS subsystems sharing the database. NPA stops database access without unloading the randomizer. This feature prevents a reload of the randomizer into ECSA storage for subsequent START commands, thus preventing ECSA fragmentation. |
S SDSG SDG SDA | Start a database This command issues the IMS /START DATABASE command to start a database. The START command allocates and permits access to the database. Any messages on the suspend queue, for transactions whose programs have access to the database, are moved to the normal queue. S and SD start the database on the target IMS subsystem. SG and SDG start the database on all IMS subsystems sharing the database. SDA starts a DEDB database and all associated areas. |
R RDRG RDG | Recover a database with DBR This command issues the IMS /DBR DATABASE command. DBR closes and deallocates the database and unauthorizes it with DBRC. The command is used to prevent programs or transactions from accessing the database. After closing the database, IMS switches to the next OLDS and issues a simple checkpoint. The /DBD DATABASE will fail for any databases being accessed by a BMP or JBP. R and RD modify the database on the target IMS subsystem. RG and RDG modify the database on all IMS subsystems sharing the database. |
N NDNG NDG | Recover a database with DBR and using the NOFEOV option This command issues the IMS /DBR DATABASE command with the NOFEOV option. The NOFEOV prevents IMS from performing an OLDS switch after completing the database recovery. N and ND modify the database on the target IMS subsystem. NG and NDG modify the database on all IMS subsystems sharing the database. |
L LD | Lock a database This command issues the IMS /LOCK DATABASE command to lock a database. The LOCK command prevents subsequently scheduled programs from accessing the database. Programs already scheduled are not affected. |
U UD | Unlock a database This command issues the IMS /UNLOCK DATABASE command to unlock a database. The UNLOCK command allows programs and transactions to access the database. |
D DDDG DDG | Dump a database This command issues the IMS /DBDUMP DATABASE, which prevents transactions or programs from updating DL/I databases. Message regions that use the database finish processing and terminate, after which the database closes and then reopens for input. D and DD modify the database on the target IMS subsystem. DG and DDG modify the database on all IMS subsystems sharing the database. |
QRY | Query a database This command issues the IMS QUERY DB NAME() SHOW(ALL) command and displays the IMS output from the command. This command is a Type-2 command, which requires an IMSplex environment. |
QXP | Query whether an export to the IMS repository is needed for a resource This command issues the IMS type-2 command QUERY type NAME (name) SHOW(EXPORTNEEDED) and displays the results. |
SQ | Quiesce a database This command issues the IMS UPD DB NAME() START(QUIESCE) OPTION(NOHOLD) command, which quiesces the selected database without placing a hold on the database. |
SQH | Quiesce a database This command issues the IMS UPD DB NAME() START(QUIESCE) OPTION(HOLD) command, which quiesces the selected database and places a hold on the database. |
PQ | Stop a database quiesce This command issues the IMS UPD DB NAME() STOP(QUIESCE) command, which stops the quiesce that is in progress for the selected database. |
ARO | Change the access level for a database to Read-Only on this IMS only (ACCESS=RO) The selected database becomes available for read-only processing; only programs that have a PCB processing option of GO (PROCOPT=GO) can use this database. |
ARD | Change access level for a database to Read on this IMS only (ACCESS=RD) The selected database becomes available for read-only processing. Programs with update intent are scheduled, but they cannot update the database. |
AUP | Change access level for a database to Update on this IMS only The selected database is available for read and update processing. |
AEX | Change access level for a database to Exclusive The selected database is used exclusively by this IMS subsystem. |
Related topic