IBM Support

IT24051: SERVER ON WINDOWS CAN CRASH RUNNING A SELECT FROM CONTAINERS IF BACKSLASHES ARE MISSING IN THE CONTAINER FILE NAME

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Any select from the containers table from dsmadmc command line,
    can crash the server when running on Windows platform, if
    backslashes are missing in the container file name.
    
    From analysing the crash from a Windows server it can be seen:
    
    adsmdll!sdQueryContainer+0xc43
    adsmdll!AdmUseExtCmdTab+0x175a
    adsmdll!AdmCommandLocal+0x520
    adsmdll!admCommand+0x12c6
    adsmdll!PreFlushDataForSQL+0x4bb
    adsmdll!ScrubCmdInput+0xaaa
    adsmdll!PreProcessQuery+0x282
    adsmdll!AdmSQLExecute+0x9d
    adsmdll!AdmCommandLocal+0x520
    adsmdll!admCommand+0x12c6
    adsmdll!SmAdminCommandThread+0x2a
    adsmdll!startThread+0x141
    msvcr120!_callthreadstartex+0x17
    msvcr120!_threadstartex+0x102
    kernel32!BaseThreadInitThunk+0x22
    ntdll!RtlUserThreadStart+0x34
    
    No error is seen in the activity log. The last entry logged will
    be the failing select from containers table.
    
    
    
    Initial Impact: Medium
    
    
    
    Tivoli Storage Manager and IBM Spectrum Protect versions
    affected: Server  7.1.x and 8.1.x  on Windows
    
    
    
    Additional Keywords:  TSM Spectrum Protect error select path
    slashes forward backward missing
    

Local fix

  • The following DB2 select can be used instead:
    DB2 "select * from containers"
    

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

Problem conclusion

  • This problem was fixed.
    Affected platforms for reported release:  Windows.
    Platforms fixed:  Windows.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT24051

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    71W

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-02-13

  • Closed date

    2018-02-14

  • Last modified date

    2018-02-14

  • 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

  • R71W PSY

       UP

  • R81W PSY

       UP



Document information

More support for: Tivoli Storage Manager

Software version: 7.1.3

Reference #: IT24051

Modified date: 14 February 2018