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

Products

• RC/Query for DB2 for z/OS

Issue/Introduction

In RC/Query for Db2 for z/OS (RCQ) executing HDDL (Hierarchial DDL) on a Stored Procedure is successful
when done online, but fails with the following in batch:

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

Resolution

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

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.