U0987 and SDC2 abends executing Fast Unload against encrypted tables.

book

Article ID: 220967

calendar_today

Updated On:

Products

CA Fast Unload for DB2 for z/OS CA Database Management for DB2 for z/OS - Utilities Suite

Issue/Introduction

Executing CA Fast Unload for Db2 for z/OS (PFU) against tables which were recently encrypted and encountering
the following abends:

USER COMPLETION CODE=0987                                            
 PSW AT TIME OF ERROR  078C1000   A6D47AAA  ILC 2  INTC 0D             
  ACTIVE MODULE           ADDRESS=00000000_26D41000  OFFSET=00006AAA  
  [email protected]                                                       
  DATA AT PSW  26D47AA4 - 00181610  0A0DEB0F  A4A80096                

SYSTEM COMPLETION CODE=DC2  REASON CODE=4A001620          
 PSW AT TIME OF ERROR  070C5000   81971C20  ILC 2  INTC 0D
   NO ACTIVE MODULE FOUND                                 
   NAME=UNKNOWN                                           
   DATA AT PSW  01971C1A - 00181610  0A0DB24D  001CE31D   


The specific PFU execution include 10 SELECT statements against partitioned
objects with 100+ partitions each.                                    

Environment

Release : 20.0
Component : CA Fast Unload for DB2 for z/OS

Resolution

The following is the Db2 tools for z/OS r20 maintenance located related to encryption
which should be verified as implemented:

SO08313 - OVERALLOCATION OF MEDIA MANAGER'S ENCRYPTION BUFFERS
SO08406 - OVERALLOCATION OF ENCRYPTION STORAGE IN 64-BIT MM INTERFACE
SO08407 - OVERALLOCATION OF ENCRYPTION STORAGE IN 64-BIT MM INTERFACE
SO15937 - USER ABEND 987 (X'3DB') WITH ENCRYPTED DATA SETS
SO15938 - USER ABEND 987 (X'3DB') WITH ENCRYPTED DATA SETS
SO15939 - USER ABEND 987 (X'3DB') WITH ENCRYPTED DATA SETS  


Based on the above maintenance, it appears that there is additional storage
requirements for encryption buffers.

The SYSTEM COMPLETION CODE=DC2  REASON CODE=4A001620 abend indicates:

A DC2 abend can be issued for a valid request which cannot be successfully    
processed by RSM. DC2 abend are only generated when an IARV64 request is      
issued.                                                                       
                                                                              
An IARV64 macro invocation to manage storage above 2 gigabytes failed. The 4  
byte hexadecimal reason code is in the format xxrrrryy, where rrrr describes  
the error. The following are the rrrr values and their meanings:              

0016                      
   Memory limit exceeded. 

- If the reason code is memory limit exceeded (0016), determine if the      
  MEMLIMIT value for the address space can be raised to accommodate its     
  storage needs.          


Recommended specifying a MEMLIMIT=nnnnnG in the JOBCARD.  
Possibly try MEMLIMIT=4G or MEMLIMIT=8G on the more complex Fast Unload
jobs with multiple SELECT statements where encryption is in place.