IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

AUTHORIZED database error in HALDB


IBM Mainframe Forums -> IMS DB/DC
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
rohanthengal

Active User


Joined: 19 Mar 2009
Posts: 206
Location: Globe, India

PostPosted: Wed Sep 08, 2021 4:46 pm
Reply with quote

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
View user's profile Send private message
isakshields

New User


Joined: 09 Aug 2021
Posts: 1
Location: Sweden

PostPosted: Thu Sep 09, 2021 4:18 pm
Reply with quote

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
View user's profile Send private message
rohanthengal

Active User


Joined: 19 Mar 2009
Posts: 206
Location: Globe, India

PostPosted: Thu Sep 09, 2021 5:56 pm
Reply with quote

Thanks for the inputs, things worked out.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> IMS DB/DC

 


Similar Topics
Topic Forum Replies
No new posts File Status Error code 39 when Proces... COBOL Programming 2
No new posts VB file copy COBOL program gives erro... COBOL Programming 3
No new posts Issue with CA Copycat-IGD17100I UNEXP... CA Products 5
No new posts Getting error S000 U0016 (Cn Internal... JCL & VSAM 4
No new posts Getting OUTREC - SHORT REC error for ... DFSORT/ICETOOL 12
Search our Forums:

Back to Top