Why is Datacom OLREORG with REFGROUP=00 failing with DB13001E - UNEXPECTED RETURN CODE 94 (173) DSOP NOT 4 OR 5?

Document ID : KB000016768
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

Why is Datacom DBUTLTY feature OLREORG with REFGROUP=00 failing with error:

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

 

Environment:
z/OS
Answer:

Given DBUTLTY Online Reorg:

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

The OLREORG specified with REFGROUP=00 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.  

 

Example DBUTLTY SYSIN with reports before and after, RETIX with KEYNAME=*DATA to rebuild the space index:

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 

Then DBUTLTY with OLREORG with REFGROUP=00 can be run:

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

Additional Information:

Refer to CA Datacom Core - 15.1 section "Data Area Space Management Options"
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