PM54509: THE DATA FROM THE TABLE SPACE IS NOT LOCKED ALTHOGH THE LOCK YESOPTION IS SPECIFIED ON PHYSICAL UNLOAD

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The data from the table space is not locked althogh the
  LOCK YES option is specified.
  This occurs where only a physical unload is requested as in the
  following example:
  
  UNLOAD  TABLESPACE DBTLS00.FLB9A985
  QUIESCE YES LOCK YES
  UNLDDN  SYSREC00
  
  PB11387
  

Local fix

• Require an extra (and useless) logical unload against one of the
  tables of the table space as shown in the example hereafter:
  
  UNLOAD  TABLESPACE DBTLS00.FLB9A985
  QUIESCE YES LOCK YES
  UNLDDN  SYSREC00
  SELECT 'LOCALFIX' FROM MZLFLB.TBDZ9AFLB98502
  OUTDDN  DUMMY
  OUTMAXROWS 1
  
  where DUMMY should be allocated as follows:
  //DUMMY   DD DUMMY.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of High Performance Unload.            *
  ****************************************************************
  * PROBLEM DESCRIPTION: The data from the table space is not    *
  *                      locked although the LOCK YES option     *
  *                      is specified. This occurs where only    *
  *                      a physical unload is requested as in    *
  *                      the following example:                  *
  *                      UNLOAD  TABLESPACE DBTLS00.FLB9A985     *
  *                      QUIESCE YES LOCK YES                    *
  *                      UNLDDN  SYSREC00                        *
  *                      Local fix: Requires an extra (and       *
  *                      useless) logical unload against one of  *
  *                      the tables of the table space as shown  *
  *                      in the example hereafter:               *
  *                      UNLOAD  TABLESPACE DBTLS00.FLB9A985     *
  *                      QUIESCE YES LOCK YES                    *
  *                      UNLDDN  SYSREC00                        *
  *                      SELECT 'LOCALFIX' FROM                  *
  *                       MZLFLB.TBDZ9AFLB98502                  *
  *                      OUTDDN  DUMMY                           *
  *                      OUTMAXROWS 1                            *
  *                      where DUMMY should be allocated as      *
  *                      follows: //DUMMY   DD DUMMY.            *
  *                      PB 11387                                *
  *                                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  oddldb2 and oddldb2  modules were changed to so that all the
  objects involved in a physical unload are locked whenever
  applicable (i.e. the LOCK YES option is specified or
  VUU012/ULLOCK is set to YES and the LOCK NO option is not
  specified).
  

Problem conclusion

• APPLY the PTF.
  

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:

  UK77136 UK77137

Modules/Macros

•    INZQRYV8 INZQRYV9 INZTPMEM INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R320 PSY UK77136

     UP12/03/22 P F203

• R410 PSY UK77137

     UP12/03/22 P F203

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.