RORG009E ERROR IN SORT PROGRAM USRPRIA SORT UTILITY ERROR occurs in DB/REORG however no sort messages are displayed?
search cancel

RORG009E ERROR IN SORT PROGRAM USRPRIA SORT UTILITY ERROR occurs in DB/REORG however no sort messages are displayed?

book

Article ID: 18173

calendar_today

Updated On:

Products

IDMS IDMS - Database IDMS - ADS

Issue/Introduction

Description:

DB/REORG job fails with RORG009E ERROR IN SORT PROGRAM USRPRIA SORT UTILITY ERROR however the sort messages are not in SORTMSG. Additional job messages include:

ICE158A jobname.stepname SYSOUT DD STATEMENT MISSING

Solution:

During an execution of DB/REORG, program USRDRVR, the job fails with:

RORG009E ERROR IN SORT PROGRAM USRPRIA SORT UTILITY ERROR

No sort messages are displayed in SORTMSG.

The reason for the error is due to a change in the DB/REORG JCL since IDMS release 18.x. The SORTMSG DD statement has been removed and replaced with a SYSOUT DD statement as documented in apar RI47284 DB/REORG SORT MESSAGES ARE SHOWN IN SYSOUT FILE. The ICE158A SYSOUT DD STATEMENT MISSING message indicates that the SYSOUT DD statement is missing. Sort messages are now located in SYSOUT.

The z/os SAMPLE JCL in the 18.0 and 18.5 DB/REORG User Guides in Chapter 6 operations section is incorrect and a DOCUP to correct the manuals is being written.

Lastly, verify these 17.0, 18.0, or 18.5 SORT apars are applied:

IDMS 18.5 Sort apars:

RO69889 Title: EXTRACT JOURNAL GOES INTO LOOP. 

IDMS 18.0 Sort apars:

RO70014 Title: EXTRACT JOURNAL GOES INTO LOOP. 
RO68414 REORG ABENDS IF SORT FIELD MAX LENGTH SPECIFIED
RI47284 DB/REORG SORT MESSAGES ARE SHOWN IN SYSOUT FILE
RO36603 BATCH PROGRAM REPORTED AS 'SYNCSORT'
RO29320 S0C4 IN EXTERNAL SORT MODULE WHEN IDMS CONTROLS THE SORT
RO26559 PARTIAL OVERLAY OF SORT PARAMETER USING OPT00200

IDMS 17.0 Sort apars:

RO37142 Title: SYNCSORT REPORTED AS PROGRAM/TASK NAME IN STATISTICS 
RO37123 NEW SYSIDMS PARM FOR VSE TO VARY NUMBER OF SORTWK FILES
RO37064 SYNCSORT REPORTED AS PROGRAM/TASK NAME IN STATISTICS
RO29432 S0C4 DURING SORT CALLED FROM IDMS
RO26640 PARTIAL OVERLAY OF SORT PARAMETER USING OPT00200
RO22154 PROCESS PARAMETER LOGIC OUT OF SEQUENCE NESTED USE
RO21005 RELEASE 17.0 VERSION OF QS56063
RO17569 PROGRAM CHECK ERROR HANDLING USING ZIIP
RO15158 POSSIBLE PROBLEMS WITH VARCHAR INDEX KEYS.
RI12747 NEW PRECOMPILER MESSAGE DML084
RO12493 MULTIPLE ABENDS IN REORG PROCESSING OVERFLOW RECORDS
RO11385 INCREASE THE NUMBER OF DIGITS ON THE SIZE= PARM.

Environment

Release: IDADSO00100-18.5-ADS-for CA-IDMS
Component: