IC61183: TSM SERVER ABENDS DELETING A CURSOR THAT WAS DEFINED USING COLUMN QUALIFIERS.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Deleting an SQL cursor that was defined with column qualifiers
    can cause the TSM server to abend. Column qualifiers consist of
    the table name and a period before the column name. For example,
    "NODES." would be the column qualifier in "NODES.NODE_NAME".
    
    TSM Versions Affected: All 6.1 versions/platforms
    
    Customer/L2 Diagnostics:
    
    The TSM server Activity Log will have entries similiar to the
    following example just before the TSM server restarted:
    HH:MM:SS ANR2017I Administrator ADMIN issued command: DEFINE
                      CURSOR Cc1531f0 SQL='SELECT NODES.NODE_NAME
                      FROM NODES NODES ORDER BY NODES.NODE_NAME'
                      (SESSION: XXX)' (SESSION: XXX)
    HH:MM:SS ANR2017I Administrator ADMIN issued command: DISPLAY
                      CURSOR Cc1531f0  (SESSION: XXX)
    HH:MM:SS ANR0162W Supplemental database diagnostic information:
                      -1:42S22:-206 ([IBM][CLI Driver][DB2/NT64]
                      SQL0206N "NODES.NODE_NAME" is not valid in the
                      context where it is used. SQLSTATE=42703).
                      (SESSION: XXX)
    HH:MM:SS ANR2017I Administrator ADMIN issued command: OPEN
                      CURSOR Cc1531f0  (SESSION: XXX)
    HH:MM:SS ANR0162W Supplemental database diagnostic information:
                      -1:42S22:-206 ([IBM][CLI Driver][DB2/NT64]
                      SQL0206N "NODES.NODE_NAME" is not valid in the
                      context where it is used. SQLSTATE=42703).
                      (SESSION: XXX)
    HH:MM:SS ANR2940E The command 'SELECT NODES.NODE_NAME FROM
                      NODESVIEW NODESVIEW ORDER BY NODES.NODE_NAME '
                      contains an unknown SQL column name.
                      (SESSION: XXX)
    HH:MM:SS ANR2017I Administrator ADMIN issued command: DELETE
                      CURSOR Cc1531f0  (SESSION: XXX)
    
    CALLSTACK:
    adsmdll!tbSQLFreeAnchor+0x47        [tbnsql.c @ 377]
    adsmdll!AdmSQLTimeCheckThread+0x453 [admsql.c @ 2921]
    adsmdll!AdmSQLDeleteCursor+0x164    [admsql.c @ 2035]
    adsmdll!AdmCommandLocal+0x553       [admcmd.c @ 2148]
    adsmdll!admCommand+0xdf0            [admcmd.c @ 1890]
    adsmdll!SmAdminCommandThread+0x2a   [smadmin.c @ 1308]
    adsmdll!startThread+0xa8            [pkthread.c @ 2955]
    msvcr90!endthreadex+0x47            [threadex.c @ 348]
    msvcr90!endthreadex+0xe8            [threadex.c @ 326]
    kernel32!BaseThreadStart+0x3a
    
    Initial Impact:
    Medium
    
    Additional Keywords:
    zz61 crash
    

Local fix

  • Ensure that column qualifiers are not used in SQL statements.
    Should an abend occur, review the DB2 SQL0206N message embedded
    in the ANR0162W message to determine the column qualifier that
    was used and correct it in the SQL used to define the cursor. In
    the provided example, removing "NODES." from all of the column
    names will address the issue.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All Tivoli Storage Manager 6.1 Windows and   *
    *                 UNIX servers using the Administrative        *
    *                 Client.                                      *
    ****************************************************************
    * PROBLEM DESCRIPTION: See error description                   *
    ****************************************************************
    * RECOMMENDATION: Apply fixing level when available. This      *
    *                 problem is currently projected to be fixed   *
    *                 in level 6.1.2. 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

    IC61183

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    61W

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-05-19

  • Closed date

    2009-06-05

  • Last modified date

    2009-06-05

  • 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

  • R61A PSY

       UP

  • R61H PSY

       UP

  • R61L PSY

       UP

  • R61S PSY

       UP

  • R61W PSY

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

Tivoli Storage Manager

Software version:

61W

Reference #:

IC61183

Modified date:

2009-06-05

Translate my page

Machine Translation

Content navigation