LOAD CXX selected DBIDs DB00501E OPEN ERROR RETURN CODE 68 (001)
Article ID: 374636
Updated On:
Products
Issue/Introduction
After a Datacom BACKUP and INIT of the CXX, a CXX LOAD for selected DBIDs is getting return code 68 (1) MULTI-USER IS NOT UP.
The DBUTLTY command being used is:
LOAD AREA=CXX,DBID=nnn
Error message:
DB00501E OPEN ERROR RETURN CODE 68 (001)
In job output:
DB13001E - UNEXPECTED RETURN CODE 68 (1) MULTI-USER IS NOT UP (OR EOJ IN PROCESS)
Tried using SET OPTION1=MUF_NOT_ENABLED in DBUTLTY but it still fails with the same error.
The MUF will not come up because the CXX was initialized, it's getting error:
DB00501E - OPEN ERROR - RETURN CODE 25 (020) CXX=aaaaaaa (CBS00006)
Environment
Release: 19.0
Cause
The RC 68 (001) is returned because this is a secured MUF and DBUTLTY needs to check security for the LOAD function, article 130659 - Resolving a Datacom RC 68(001) error explains this:
You could also have received this return code if you have implemented external security and are attempting to execute a DBUTLTY function that needs to communicate through the MUF to determine, from the security package, whether the client is authorized to execute the action. The needed communication cannot occur, however, because the MUF is not up.
You can do a full DBUTLTY LOAD AREA=CXX without the MUF being up but when you specify DBID=nnn on the CXX LOAD the MUF needs to be up.
This is explained in documentation section DBUTLTY Functions and Multi-User Facility Not Active:
If the Multi-User Facility (MUF) is not active and non-SQL security is installed, most DBUTLTY functions are denied with a return code 68. The following functions execute and run as if security is not installed:
Resolution
To resolve the problem you will need to start up the MUF with startup option LIMITED_INSTALL_MUF. This option allows the MUF to start with limited functionality to allow DBUTLTY jobs to run.
Follow this procedure:
- Run a DBUTLTY job to INIT the CXX - INIT AREA=CXX,CXXNAME=cxx_name,DATACOM=DB
- Start the MUF using this new CXX with startup option LIMITED_INSTALL_MUF YES
- Run DBUTLTY to load individual the DBIDs - LOAD AREA=CXX,DBID=nnn,DDNAME=aaaaaaaa
- Shut down the MUF and remove startup option LIMITED_INSTALL_MUF YES
If you are also renaming the CXX you will have to run a DBUTLTY LINK for any areas you will be using from the previous CXX name.
Additional Information
See Datacom documentation section BUTLTY Functions and Multi-User Facility Not Active, LIMITED_INSTALL_MUF and Return Code 68.
See article 130659 - Resolving a Datacom RC 68(001) error.
Feedback
