IBM Support

IT30561: SERVER MAY HANG AT BACKUP DB RUNTIME BECAUSE OF DB2 APAR IT27943

Direct links to fixes

8.1.10.000-IBM-SPOC-WindowsX64
8.1.10.000-IBM-SPOC-Linuxx86_64
8.1.10.000-IBM-SPOC-Linuxs390x
8.1.10.000-IBM-SPOC-LinuxPPC64le
8.1.10.000-IBM-SPOC-AIX
8.1.10.000-IBM-SPCMS-WindowsX64
8.1.10.000-IBM-SPCMS-WindowsI32
8.1.10.000-IBM-SPCMS-Linuxx86_64
8.1.10.000-IBM-SPSRV-WindowsX64
8.1.10.000-IBM-SPSRV-Linuxx86_64
8.1.10.000-IBM-SPSRV-Linuxs390x
8.1.10.000-IBM-SPSRV-Linuxppc64le
8.1.10.000-IBM-SPSRV-AIX
IBM Spectrum Protect Server V8.1 Fix Pack (V8.1.10) Downloads

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When performing an online backup,  the IBM DB2 may unexpectedly
hang because of a known issue addressed in the DB2 apar IT27943:
https://www-01.ibm.com/support/entdocview.wss?uid=swg1IT27943



Customer/L2 Diagnostics:
Forcing a dump of the dsmsvc process at hang time, the dump
stack on Windows may show the following exception:

KERNELBASE!WaitForSingleObjectEx+0x8f
sechost!ScSendResponseReceiveControls+0x138
sechost!ScDispatcherLoop+0x138
sechost!StartServiceCtrlDispatcherA+0x58
dsmsvc+0x1fbc
dsmsvc+0x3993
kernel32!BaseThreadInitThunk+0x14
ntdll!RtlUserThreadStart+0x21 2:35:14 PM

and the db2fodc_hang diagnostic data may show the following
stack trace:


1. =========================================
2. ******** LATCHWAIT DETECTED ( #1 ) ***********
3. Printing LatchWait information
4. =========================================
5. <<<< Holder Information (Address = 0000013994FE7A80) >>>>
6. File Information:
7. Line: 6475, File: XXXXX HoldCount: 1
8. ----------------------------
9. PID(s):
10. Pid:23476 Tid:21948 stack1.fmt (Pid:23476 Tid:21948
stack1.fmt) -- Line: 6475, File: XXXXX HoldCount: 1
11. (SQLO_LT_SQLB_POOL_CB__readLotch)
12. Agent Type:
13.
14. *** Stack ***
15. &#160;41.
42. <<< Stack >>>
43.
44. Timestamp: 2019-09-04-14.21.55.555000
45. 00007FFF4F154334 <SQLO_SLATCH_CAS32::getConflict>
46. 00007FFF18B81C15 <sqlbLatchPoolR_inline>
47. 00007FFF18D96CBB <sqlbDirtyTbspaceFlagsForBackup>
48. 00007FFF18D48966 <sqlbTrackModifications>
49. 00007FFF18E4F650 <sqlbUnfixPage>
50. 00007FFF19367C20 <sqldReplaceRow>
51. 00007FFF19366201 <sqldUpdateRow>
52. 00007FFF22466575 <sqldRowUpdate>
53. 00007FFF1BFADED6 <sqlriupd>
54. 00007FFF1BD47CF3 <sqlriSectInvoke>
55. 00007FFF1B89B1A5 <sqlrr_process_execute_request>
56. 00007FFF1B75CA62 <sqlrr_execute>
57. 00007FFF19B44E4C <sqljs_ddm_excsqlstt>
58. 00007FFF19B20239 <sqljsParseRdbAccessed>
59. 00007FFF19B21403 <sqljsParse>
60. 00007FFF19AB728E <sqljsSqlam>
61. 00007FFF19ABF69C <sqljsDrdaAsInnerDriver>
62. 00007FFF19AC0D93 <sqljsDrdaAsDriver>
63.
64. ******** LATCHWAIT DETECTED ( #2 ) ***********
65. Printing LatchWait information
66. =========================================
67. <<<< Holder Information (Address = 0000014EB24CE860) >>>>
68. File Information:
69. Line: 6475, File: HoldCount: 1
70. ----------------------------
71. PID(s):
72. Pid:23476 Tid:38500 stack1.fmt (Pid:23476 Tid:38500
stack1.fmt) -- Line: 6475, File: XXXXX HoldCount: 1
73. (SQLO_LT_SQLB_POOL_CB__readLotch)
74. Agent Type:
75.
76. *** Stack ***
77.
78. Timestamp: 2019-09-04-14.21.55.900000
79. 00007FFF4F3266CC <sqloWaitInterrupt>
80. 00007FFF4F33E7A6 <sqloCSemP>
81. 00007FFF18E48923 <sqlbPFFindAndLatchFreelist>
82. 00007FFF18E4B787 <sqlbPFGetMultipleFreeRequests>
83. 00007FFF18E49AFC <sqlbpfParallelDirectReadV>
84. 00007FFF18DDCFCE <sqlbDirectReadBlock>
85. 00007FFF1D04EFB8 <sqlubReadDMS>
86. 00007FFF1CFAAA58 <sqlubBMProcessData>
87. 00007FFF1CFA91E0 <sqlubbuf>
88. 00007FFF19730D8D <sqleSubCoordProcessRequest>
89. 00007FFF195A895D <sqeAgent::RunEDU>
90. 00007FFF1CAAF58F <sqlzRunEDU>
91. 00007FFF4F321DA6 <sqloEDUEntry>
92.
93. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~
94. <<<< Waiter Information (Address = 0000014EB24CE860) >>>>
95. TOTAL WAITERS >> 16
96. File Information:

.....
101. ----------------------------
102. PID(s):
103. Pid:23476 Tid:1516 stack1.fmt (Pid:23476 Tid:1516
stack1.fmt) -- Line: 2001, File: XXXXX
(SQLO_LT_SQLB_POOL_CB__readLotch)
104. Agent Type:
105.
106. <<< Stack >>>
107.
108. Timestamp: 2019-09-04-14.21.55.743000
109. 00007FFF4F154334 <SQLO_SLATCH_CAS32::getConflict>
110. 00007FFF18B81C15 <sqlbLatchPoolR_inline>
111. 00007FFF18D3BDBB <sqlbReadPageInternal>
112.
113. ...



IBM Spectrum Protect versions affected:
Server 8.1.x on supported platforms



Initial Impact:
Medium



Additional Keywords:
TSM "Spectrum Protect" DB2 hang IT27943 "backup db"  TS002277541

Local fix

  • Apply the same workaround as for DB2 apar:
https://www-01.ibm.com/support/entdocview.wss?uid=swg1IT27943

Here are detailed steps to apply it:

    db2set DB2BPVARS=<file>

    Replace <file> with a fully qualified file name, such
    as /home/db2inst1/bpvars.cfg

    Place the following line in the stated file:

    NOREADVBCKUP=1

    Restart DB2 to propagate changes.

Problem summary

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

Problem conclusion

  • This problem was fixed.

Temporary fix

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    IT30561
    • 

  • Reported component name
    TSM SERVER
    • 

  • Reported component ID
    5698ISMSV
    • 

  • Reported release
    81W
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2019-10-10
    • 

  • Closed date
    2019-12-09
    • 

  • Last modified date
    2019-12-09
    • 





    

  • 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


    

  • R81A  PSY
       UP
    • 

  • R81L  PSY
       UP
    • 

  • R81W  PSY
       UP
    • 








      
              
                            

              

              [{"Line of Business":{"code":"LOB26","label":"Storage"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"81W"}]
              

                                                                    

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            26 August 2021
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback