IBM Support

IT20925: EXTENT MOVEMENT WITH NATIVE ENCRYPTION COULD LEAD TO CORRUPTED PAGE ONLY IN-MEMORY

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • With native encryption enabled and extent movement running
    (ALTER TABLESPACE [REDUCE MAX|LOWER HIGH WATER MARK]) it is
    possible to have part of a page corrupted in-memory only. The
    permanent on-disk data remains consistent.
    
    To diagnose the problem:
    
    1) Make sure the permanent on-disk data remains consistent by
    extracting the problematic page using db2dart with DATA #5.
    
    2019-09-27-00.06.42.792621+540 I2436E6282            LEVEL:
    Severe
    PID     : 22100                TID : 140026121807616 PROC :
    db2sysc 0
    INSTANCE:             NODE : 000            DB   :
    APPHDL  : 0-52641              APPID:
    10.132.216.16.37796.190926141342
    AUTHID  :               HOSTNAME:
    EDUID   : 2504                 EDUNAME: db2agent
    FUNCTION: DB2 UDB, Common Trace API, sqlbfix, probe:104
    DATA #1 : String, 25 bytes
    bfix detected an error -
    DATA #2 : Boolean, 1 bytes
    false
    DATA #3 : Boolean, 1 bytes
    false
    DATA #4 : String, 20 bytes
    Current Descriptor =
    DATA #5 : Buffer page descriptor, PD_TYPE_SQLB_BPD, 256 bytes
        Pagekey: {pool:4;obj:544;type:1} PPNum:715345
      objectPageNum:                    715345
      bucketGroupHashIndex:              71041
      hashnext:             0x0000000000000000
      hashprev:             0x0000000000000000
     ...
    DATA #6 : String, 18 bytes
    Current PageHead =
    DATA #7 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
    pageHead: {tbspSeed:2386498927;obj:544;type:1}
    bphPPNum:3130724290 bphOPNum:3130724290
      begoff:                   53610
      datlen:                   13476
      revnum:                   27252
      pagelsn:     000000040B11B370
      flag:                         d
      future32:                    0
      cbits1to31:            334f457b
      cbits32to63:           2fa8154e
    
    2) Ensure that native encryption is enabled on the database
    manager configuration:
    (KEYSTORE_TYPE) = PKCS12
    (KEYSTORE_LOCATION) = keystore.p12
    

Local fix

  • Either:
    1) Turn off native encryption
    2) Do not run extent movement
    3) Get the code fix
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 10.5 Fix Pack 9 or higher                     *
    ****************************************************************
    

Problem conclusion

  • First fixed in Db2 10.5 Fix Pack 9
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT20925

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A50

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-06-07

  • Closed date

    2020-06-28

  • Last modified date

    2020-06-28

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

    IT20923

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RA50 PSN

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.5","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
12 January 2022