PH46034: CEE0374C CONDITION=CEE0802C unloading encrypted TS in native mode and/or memory issues if VUM037/CRYPTUSR not CURRENT_USER

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A Db2 HPU step intermittently terminates in abend after having
  issued the following message :
  
  CEE0374C CONDITION=CEE0802C
  
  This can occur when the following conditions are fulfilled :
  - the unload is processed in native mode
  - the LDSes of the involved partitions are encrypted
  - the parmlib variable VUM037/CRYPTUSR is set to a specific
  userid that differs from the userid that submitted the job.
  
  The root cause of the issue is a not compliant call to RACF
  services during the userid-switching mechanism that Db2 HPU
  requires to performed some specific operations. This incorrect
  call leads to a memory leak which tends to exhaust common
  resources (e.g. ESQA memory) which can affect any job,
  including a job  that does not run Db2 HPU. An ABENDS822 is one
  of the referenced symptom that might occur.
  
  When parallelism for reading the LDSes from the tablespace
  involved in the unload  is put into action, more
  userid-switching operations are performed. Therefore, the issue,
  the related memory leak and its impacts are more acute when a
  bigger number of partition and a greater LDS parallelism degree
  is enabled.
  

Local fix

• if applicable, consider either of the following solutions:
  
  
  - fix 1) set the parmlib variable VUM037/CRYPTUSR to
  CURRENT_USER and make sure the user that submits the job has the
  privilege to read the encrypted VSAM datasets from the
  tablespaces involved in the unload
  
  
  - fix 2) run the unload in SQL mode by specifying the DB2 FORCE
  option
  
  
  Fix 1 solves the issue for any unload and has no impact on the
  performance. Fix 2 avoids changing the privileges layout but
  might have important impact on the unload performance.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload         *
  *                 for z/OS                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: A Db2 HPU step intermittently           *
  *                      terminates in abend after having issued *
  *                      the following message :                 *
  *                      CEE0374C CONDITION=CEE0802C             *
  *                                                              *
  *                      This can occur when the following       *
  *                      conditions are fulfilled:               *
  *                      - the unload is processed in native     *
  *                        mode                                  *
  *                      - the LDSes of the involved partitions  *
  *                        are encrypted                         *
  *                      - the parmlib variable VUM037/CRYPTUSR  *
  *                        is set to a specific userid that      *
  *                        differs from the userid that          *
  *                        submitted the job.                    *
  *                                                              *
  *                      The root cause of the issue is a not    *
  *                      compliant call to RACF services during  *
  *                      the userid-switching mechanism that     *
  *                      Db2 HPU requires to performed some      *
  *                      specific operations. This incorrect     *
  *                      call leads to a memory leak which tends *
  *                      to exhaust common resources             *
  *                      (e.g. ESQA memory) which can affect any *
  *                      job, including a job  that does not run *
  *                      Db2 HPU. An ABENDS822 is one of the     *
  *                      referenced symptom that might occur.    *
  *                                                              *
  *                      When parallelism for reading the LDSes  *
  *                      from the tablespace involved in the     *
  *                      unload  is put into action, more        *
  *                      userid-switching operations are         *
  *                      performed. Therefore, the issue, the    *
  *                      related memory leak and its impacts are *
  *                      more acute when a bigger number of      *
  *                      partition and a greater LDS parallelism *
  *                      degree is enabled.                      *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  CEE0374C CONDITION=CEE0802C unloading encrypted TS in native
  mode and/or memory issues if VUM037/CRYPTUSR not CURRENT_USER
  

Problem conclusion

• Code has been changed to fix this problem
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

• INZ$$PRM INZMQRY  INZPARM  INZTDSC  INZTOOLS INZTVAR  INZUTIB1
  INZUTIB2 INZUTILC INZUTILD INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R510 PSY UI82184

     UP22/09/03 P F209

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.