|
View previous topic :: View next topic
|
| Author |
Message |
rohanthengal
Active User
.jpg)
Joined: 19 Mar 2009
Posts: 206
Location: Globe, India
|
|
|
|
I am working on reorg for HALDB having 3 partitions. 2 of its partitions are showing AUTHORIZATION error while doing DELETE.DB.
| Code: |
DELETE.DB DBD(DBXXX)
renders - DSP1095A DATABASE DBXXX IS AUTHORIZED |
So, I went ahead and used CHANGE.DBD UNAUTH with SSID to remove authorization for partitions in HALDB.
| Code: |
CHANGE.DBD DBD(PART_A) UNAUTH SSID(SSID_MAIN)
CHANGE.DBD DBD(PART_B) UNAUTH SSID(SSID_MAIN) |
I am still getting same error while running DELETE.DB for the same HALDB and same partitions.
| Code: |
LIST.DB DBD(DBXXX)
shows... AUTHORIZED SUBSYSTEMS =1
BACKOUT NEEDED =ON |
Any suggestions would be useful. |
|
| Back to top |
|
 |
isakshields
New User
Joined: 09 Aug 2021
Posts: 3
Location: Sweden
|
|
|
|
Hi,
You can use a type-1 or type-2 command
the type-1 command:
/DBR DB xxxxxxxx NOFEOV GLOBAL NOPFA
or the type-2 command:
UPDATE DB NAME(xxxxxxxx) STOP(ACCESS) OPTION(NOFEOV) SCOPE(ALL)
From the manual:
"The /DBRECOVERY command closes and deallocates the databases, and deauthorizes them with DBRC. Once the database or area referenced by /DBRECOVERY is closed, the IMS log switches to the next OLDS (unless you specify the NOFEOV keyword). This switch to the next OLDS is marked as a recovery point for log archiving purposes. IMS issues a simple checkpoint."
Source:
https://www.ibm.com/docs/en/ims/15.2.0?topic=commands-dbrecovery-command
STOP(ACCESS)
Specifies the attributes that are to be stopped.
Starts offline processing of the database. This processing closes and deallocates the database and deauthorizes the database to DBRC. An UPDATE DB START(ACCESS) command is required to reset the effect of an UPDATE DB STOP(ACCESS).
Source: https://www.ibm.com/docs/en/ims/15.2.0?topic=commands-update-db-command
If you need to make the database available again you need to start them with either
/STA DB xxxxxxxx
or
UPDATE DB NAME(xxxxxxxx) START(ACCESS)
//shields |
|
| Back to top |
|
|
rohanthengal
Active User
Joined: 19 Mar 2009
Posts: 206
Location: Globe, India
|
|
|
|
| Thanks for the inputs, things worked out. |
|
| Back to top |
|
|
|
|
