Datacom OLREORG RC 94 (173) DSOP NOT 4 OR 5?

Products

• Datacom
• DATACOM - AD
• CIS
• COMMON SERVICES FOR Z/OS
• 90S SERVICES
• DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS
• COMMON PRODUCT SERVICES COMPONENT
• Common Services
• CA ECOMETER SERVER COMPONENT FOC
• Easytrieve Report Generator for Common Services
• INFOCAI MAINTENANCE
• IPC
• UNICENTER JCLCHECK COMMON COMPONENT
• Mainframe VM Product Manager
• CHORUS SOFTWARE MANAGER
• CA ON DEMAND PORTAL
• CA Service Desk Manager - Unified Self Service
• PAM CLIENT FOR LINUX ON MAINFRAME
• MAINFRAME CONNECTOR FOR LINUX ON MAINFRAME
• GRAPHICAL MANAGEMENT INTERFACE
• WEB ADMINISTRATOR FOR TOP SECRET
• Xpertware

Issue/Introduction

Why is Datacom DBUTLTY feature OLREORG failing with error:

DB13001E - UNEXPECTED RETURN CODE 94 (173) DSOP NOT 4 OR 5 WITH REFGROUP 00

 

Environment

z/OS

Resolution

Given DBUTLTY Online Reorg:

    OLREORG DBID=dbid,TABLE=tbl,REFGROUP=00  

The OLREORG will result in the Datacom RC 94(173) when the table (tbl) being reorganized DSOP value is not 4 or 5.

 

To determine the DSOP, run a full CXX report against the specific database.

Run DBUTLTY with: 

       REPORT AREA=CXX,DBID=dbid

In the CXX report, find the table (tbl).

   TABLE NAME - tbl

...then find the DSOP MODE for that table in the CXX report.

 

In the CXX report...

DSOP 4 would show value:

       DSOP MODE    - RANDOM FOR OLREORG 

 

DSOP 5 would show value:

       DSOP MODE    - SEQUENTIAL FOR OLREORG 

 

 

If not DSOP 4 or 5, then CXXMAINT ALTER and CLOSE would need to be done before any OLREORG.  

NOTE: The CLOSE requires then exclusive access to the database.  

Update the DSOP value:
CXXMAINT OPTION=ALTER,DBID=dbid,AREA=area,DSOP=dsop

Then rebuild the space index:
RETIX KEYNAME=*DATA,DBID=dbid

Example DBUTLTY SYSIN with reports before and after:
//SYSIN   DD  *
REPORT AREA=CXX,DBID=dbid
COMM OPTION=CLOSE,DBID=dbid
CXXMAINT OPTION=ALTER,DBID=dbid,AREA=area,DSOP=dsop
RETIX KEYNAME=*DATA,DBID=dbid
REPORT AREA=CXX,DBID=dbid 

After above completes successfully and the CXX report after confirms the new DSOP,  DBUTLTY with OLREORG can be run:

OLREORG DBID=dbid,TABLE=tbl,REFGROUP=00
 

Additional Information

Refer to Datacom Core - 15.1 sections "Data Area Space Management Options" and "OLREORG (Reorganize a Database Online)

https://techdocs.broadcom.com/us/en/ca-mainframe-software/database-management/ca-datacom/15-1/administrating/ca-datacom-db-database-and-system-administration/designing-data-areas/data-area-space-management-options-dsop.html


NOTE: for Datacom version 15.1 and above, refer to
Article: 131994 DATASCAN instead of RETIX *KEYNAME"