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

book

Article ID: 16768

calendar_today

Updated On:

Products

CA Datacom - DB CA Datacom CA Datacom - AD CA Datacom - Server CA CIS CA Common Services for z/OS CA 90s Services CA Database Management Solutions for DB2 for z/OS CA Common Product Services Component CA Common Services CA Datacom/AD CA ecoMeter Server Component FOC CA Easytrieve Report Generator for Common Services CA Infocai Maintenance CA IPC Unicenter CA-JCLCheck Common Component CA Mainframe VM Product Manager CA Chorus Software Manager CA On Demand Portal CA Service Desk Manager - Unified Self Service CA PAM Client for Linux for zSeries CA Mainframe Connector for Linux on System z CA Graphical Management Interface CA Web Administrator for Top Secret CA CA- 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