search cancel

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

book

Article ID: 16768

calendar_today

Updated On:

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 CA Datacom Core - 15.1 sections "Data Area Space Management Options" and "OLREORG (Reorganize a Database Online)

https://docops.ca.com/ca-datacom/15-1/en/administrating/ca-datacom-db-database-and-system-administration/designing-data-areas/data-area-space-management-options-dsop

https://docops.ca.com/ca-datacom/15-1/en/reference/dbutlty-reference/utility-function-summary/olreorg-reorganize-a-database-online

NOTE: for Datacom version 15.1 and above, refer to
KB000131994 "DATACOM DATASCAN instead of RETIX *KEYNAME"
https://comm.support.ca.com/kb/datacom-datascan-instead-of-retix-keyname/kb000131994