RQE02001I 12,999,0 on DDL or HDDL command

book

Article ID: 39479

calendar_today

Updated On:

Products

CA RC/Migrator CA Endevor SCM Interface DB2 Administration CA RC Compare for DB2 for z/OS CA RC Extract for DB2 for z/OS CA RC/Query CA RC Secure for DB2 for z/OS CA RC Update for DB2 for z/OS

Issue/Introduction

Problem: 

In RC/Query the DDL or HDDL command on a table receives:

RQE02001I - DDL COMPLETED.  RC=12,999, 0

Environment:  

DB2 Tools R18

Cause: 

The region size is insufficient for OFS (Object Framework Services).  

Resolution:

If you are running z/OS 1.12 or 1.13 PTF RO79636 should be applied.

Increase the TSO logon Region Size.  The Install Guide recommends the following region sizes for the HDDL command:

Recommended Region Sizes for Executing the HDDL Command

The IEALIMIT or IEFUSI exit routine modules provide IBM-supplied default limits. If these defaults are not changed, the following region sizes

are recommended to execute HDDL successfully:

Region Size                                DB2 Object Size

0 KB or 0 MB                               Unlimited storage available. Any object with any number of dependencies.

< 0 MB < REGION < 16 MB           Small and medium sized objects:

                                                    ? Small (objects that have up to 100 dependent objects).

                                                    ? Medium (objects that have up to 1000 dependent objects).

< 16 MB < REGION < 32 MB          Large objects (objects that have more than 1000 dependent objects).

<32 MB < REGION < 2047 MB        Any DB2 object with more dependencies.

 

Additional Information:

R18 has the documentation on the Bookshelf and the new docops platform below.

R18 and later - https://docops.ca.com (enter CA DB Management Solutions for DB2)

Environment

Release:
Component: RCQ