IBM Support

IT14238: EXTEND DB MIGHT CRASH A V71 SERVER DB IF THE CONDITIONS FOR DB2 APAR IT14021 ARE MET

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • The Tivoli Storage Manager server "EXTEND DB" command uses the
    DB2 "ALTER DATABASE ADD STORAGE" command which is deprecated for
    DB2 10.5.
    Because of this, the server is still exposed to DB2 APAR  DB2
    APAR IT14021:
    "DB2 MIGHT TRAP ON "ALTER DATABASE ADD STORAGE" IF FILE SYSTEM
    DISK SECTOR SIZE IS NOT OF 512 BYTES"
    
    
      Tivoli Storage Manager Versions Affected: 7.1
      Customer/L2 Diagnostics (If Applicable)
    Under the APAR condition, there is no error returned upon the
    "EXTEND DB" initiated "ALTER DATABASE ADD STORAGE" when NO FILE
    SYSTEM CACHING and disk sector size is not 512 bytes.
    This can result in the DB2 trap with similar output in
    db2diag.log:
    2016-01-15-11.24.20.512691+060 I51880018E702       LEVEL: Error
    PID     : 12100                TID  : 140716554577664PROC :
    db2sysc 0
    INSTANCE: db2inst1             NODE : 000          DB   : SAMPLE
    APPHDL  : 0-38160              APPID:
    *LOCAL.db2inst1.160115102312
    AUTHID  : db2inst1
    EDUID   : 435                  EDUNAME: db2agent (SAMPLE) 0
    FUNCTION: DB2 UDB, buffer pool services,
    sqlbDMSAddContainerRequest, probe:840
    MESSAGE : ZRC=0x870F0002=-2029060094=SQLO_BPSE "Debug logic
    error detected"
              DIA8501C A buffer pool logic error has occurred.
    DATA #1 : <preformatted>
    Error acquiring container 7
    (/home/db2inst1/db2inst1/NODE0000/SAMPLE/T0000004/C0000011.LRG)
    for tbsp 4.  Rc = 870F0002
    2016-01-15-11.24.20.512835+060 I51880721E3090      LEVEL: Severe
    PID     : 12100                TID  : 140716554577664PROC :
    db2sysc 0
    INSTANCE: db2inst1             NODE : 000          DB   : SAMPLE
    APPHDL  : 0-38160              APPID:
    *LOCAL.db2inst1.160115102312
    AUTHID  : db2inst1
    EDUID   : 435                  EDUNAME: db2agent (SAMPLE) 0
    FUNCTION: DB2 UDB, buffer pool services,
    sqlbDMSAddContainerRequest, probe:0
    DATA #1 : String, 18 bytes
    SQLB_CONTAINER_TAG
    DATA #2 : Hexdump, 512 bytes
    0x00007FFAEEB82400 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x00007FFAEEB82410 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x00007FFAEEB82420 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x00007FFAEEB82430 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x00007FFAEEB82440 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x00007FFAEEB82450 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x00007FFAEEB82460 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x00007FFAEEB82470 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x00007FFAEEB82480 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x00007FFAEEB82490 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x00007FFAEEB824A0 : 0000 0000 0000 0000 0080 ECF9 1F00 0000
    ................
    0x00007FFAEEB824B0 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x00007FFAEEB824C0 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x00007FFAEEB824D0 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x00007FFAEEB824E0 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x00007FFAEEB824F0 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x00007FFAEEB82500 : 0000 0000 0000 0000 0000 0000 0B00 0000
    ................
    0x00007FFAEEB82510 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x00007FFAEEB82520 : E0E5 B8EE FA7F 0000 A0FA B8EE FA7F 0000
    ................
    0x00007FFAEEB82530 : 9820 0000 9920 0000 9A20 0000 9B20 0000
    . ... ... ... ..
    0x00007FFAEEB82540 : 9C20 0000 9D20 0000 80EB AEFF 0700 B0FA
    . ... ..........
    0x00007FFAEEB82550 : 0000 0000 0000 0000 A8FD B8EE FA7F 0000
    ................
    0x00007FFAEEB82560 : C03E 0000 0000 0000 7334 342F 3000 0000
    .>......s44/0...
    0x00007FFAEEB82570 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x00007FFAEEB82580 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x00007FFAEEB82590 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x00007FFAEEB825A0 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x00007FFAEEB825B0 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x00007FFAEEB825C0 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x00007FFAEEB825D0 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x00007FFAEEB825E0 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x00007FFAEEB825F0 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    2016-01-15-11.24.20.532478+060 E51883812E1269      LEVEL: Error
    (OS)
    PID     : 12100                TID  : 140716554577664PROC :
    db2sysc 0
    INSTANCE: db2inst1             NODE : 000          DB   : SAMPLE
    APPHDL  : 0-38160              APPID:
    *LOCAL.db2inst1.160115102312
    AUTHID  : db2inst1
    EDUID   : 435                  EDUNAME: db2agent (SAMPLE) 0
    FUNCTION: DB2 UDB, oper system services, sqloseekread64,
    probe:20
    MESSAGE : ZRC=0x870F0002=-2029060094=SQLO_BPSE "Debug logic
    error detected"
              DIA8501C A buffer pool logic error has occurred.
    CALLED  : OS, -, pread                            OSERR: EINVAL
    (22)
    DATA #1 : File handle, PD_TYPE_SQO_FILE_HDL, 8 bytes
      File Handle              = 526
      File System Block Size   = 0 bytes
      File System Type         = UNKNOWN
      File Handle Flags :
        Require Sector Align   = No
        DIO/CIO Mode           = Yes
        Raw Block Device       = No
        Reserved Handle        = No
        Flush On Close         = Yes
        Thread-Level Lock      = No
        Write-through Mode     = No
        File Not Tracked       = No
    DATA #2 : unsigned integer, 8 bytes
    512
    DATA #3 : File Offset, 8 bytes
    512
    DATA #4 : String, 105 bytes
    Search for ossError*Analysis probe point after this log entry
    for further
    self-diagnosis of this problem.
    
      Initial Impact: Medium
      Additional Keywords: ZRC=0x870F0002 IBM Spectrum Protect TSM
    IT14237
    

Local fix

  • only use file systems with 512 file system disk sector size for
    the Tivoli Storage Manager database containers.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Tivoli Storage Manager server users.                     *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See error description.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply fixing level when available. This problem is currently *
    * projected to be fixed in level 7.1.6. Note that this is      *
    * subject to change at the discretion of IBM.                  *
    ****************************************************************
    

Problem conclusion

  • This problem was fixed.
    Affected platforms:  AIX, HP-UX, Solaris, Linux, and Windows.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT14238

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    71L

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-03-10

  • Closed date

    2016-03-18

  • Last modified date

    2016-03-18

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

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

Fix information

  • Fixed component name

    TSM SERVER

  • Fixed component ID

    5698ISMSV

Applicable component levels

  • R71A PSY

       UP

  • R71H PSY

       UP

  • R71L PSY

       UP

  • R71S PSY

       UP

  • R71W PSY

       UP



Document information

More support for: Tivoli Storage Manager

Software version: 7.1.3

Reference #: IT14238

Modified date: 18 March 2016