search cancel

Batch HDDL error: HDDL COMPLETED. RC=12,88,156

book

Article ID: 230225

calendar_today

Updated On:

Products

RC/Query for DB2 for z/OS

Issue/Introduction

In RC/Query executing HDDL (Hierarchial DDL) on a Stored Procedure is successful when done online, but fails with the following in
Batch, what is the cause?  

>SSID DB2T
  >LOCATION LOCAL
  >SQLID DBAX
  >OBJTYPE PR
  >NAME "Test Description"
  >SCHEMA "SUTC"
  >VERSION "V1"
  >SQLDLIM ;
  >SPUFIIND Y
  >OBJECTS NNNNNNNNNYNN
  >OWNERIND N
  >RICHAIN  Y
  >GENGRANT N
. RQE02001I - HDDL COMPLETED.  RC=12,88,156.

 

 

  

Environment

Release : 20.0

Component : Batch Processor

Resolution

The message indicates the user needs access to the OMVS segment.  OFS (Object Framework Services) is used when issuing HDDL.

Per the documentation:  Object Framework Services

OFS uses UNIX System Services (USS) provided POSIX services. OMVS access is required. If the NO-OMVS setting in ACF2

 or NOUID setting in RACF is specified, contact an administrator to remove this setting to enable user access to OMVS. To avoid CEE errors, use 64-bit LE options in the CEEOPTS DD statement instead of 31-bit LE options.