IBM Support

IT22232: DATABASE RESTORE ON WINDOWS SERVER USING 8.1.2 CLIENT FAILS WITHDB2 SQLCODE: -2033. DB2 SQLERRMC: 137.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • DATABASE RESTORE on Windows server with Backup-Archive Client
    version 8.1.2 and API Version 8.1.2 might fail with
    ANR9999D_3900387427.
    
    
    IBM Spectrum Protect Server console log shows:
    ANR4897I Database restore of operation 0 will use device class
    FILE and attempt to use 1 streams.
    ANR9999D_3900387427 VerifyAuthInfo(smauth.c:2524) Thread<11>:
    OpenDBForUserId
    had error.
    ANR9999D Thread<11> issued message 9999 from:
    ANR9999D Thread<11>  7fee2b73458 OutDiagToCons()+198
    output.c:1367
    ANR9999D Thread<11>  7fee2b65d23 outDiagfExt()+223 outvarg.c:247
    ANR9999D Thread<11>  7fee2976793 VerifyAuthInfo()+2f3
    smauth.c:2530
    ANR9999D Thread<11>  7fee2973253 HandleAuthenticate()+203
    smauth.c:1413
    ANR9999D Thread<11>  7fee2971143 SmV2AuthProcess()+973
    smauth.c:597
    ANR9999D Thread<11>  7fee281172a smExecuteSession()+57a
    smexec.c:2745
    ANR9999D Thread<11>  7fee2d3e88d SessionThread()+95d
    tcpcomm.c:3463
    ANR9999D Thread<11>  7fee186b9bf startThread()+35f
    pkthread.c:3692
    ANR9999D Thread<11>  7feed86a105 beginthreadex()+1f5
    ANR9999D Thread<11>  7feed86a357 endthreadex()+1d7
    ANR9999D Thread<11>  76b659cd BaseThreadInitThunk()+d
    ANR9999D Thread<11>  76d9a561 RtlUserThreadStart()+21
    ANR2969E Database restore terminated. DB2 sqlcode: -2033. DB2
    sqlerrmc: 137.
    
    
    Customer/L2 Diagnostics:
    API return code 137 means "authentication failure"
    
    Note: This has also been seen with DB2 sqlerrmc: 168
    
    IBM Spectrum Protect Server Version Affected:
    Version 8.1.2 on Windows
    
    | MDVREGR 8.1.2-TIV_5698MSV |
    
    Initial Impact:
    High
    
    
    Additional Keywords:
    TSM server Spectrum Protect restore db api ba client
    

Local fix

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.3. Note that this is      *
    * subject to change at the discretion of IBM.                  *
    ****************************************************************
    

Problem conclusion

  • This problem was fixed.
    Affected platforms for reported release:  AIX, Linux, and
    Windows.
    Platforms fixed:  AIX, Linux, and Windows.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT22232

  • 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

    2017-09-07

  • Closed date

    2017-09-07

  • Last modified date

    2018-05-23

  • 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



Document information

More support for: Tivoli Storage Manager

Software version: 81W

Reference #: IT22232

Modified date: 23 May 2018