IBM Support

IC65154: LITERAL VALUES ARE CONVERTED IN SQL COMMANDS IN TIVOLI STORAGE MANAGER VERSION 6.1

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • In Tivoli Storage Manager version 6.1
    the operator "==" gets converted to "=" in a select command.
    Also all leading and trailing white space characters in a quoted
    string will be stripped
    .
    Literal values like "==0" are not affected.
    .
    .
    Examples for the operator "=="
    .
    - Result from a Tivoli Storage Manager version 5.5
    .
    tsm: TSM1>select '==',node_name from adsm.nodes
    .
    Unnamed[1]     NODE_NAME
    ----------     ------------------
    ==             NODE1
    .
    .
    - Result from a Tivoli Storage Manager version 6.1
    .
    tsm: TSM2>select '==',node_name from adsm.nodes
    .
    Unnamed[1]  NODE_NAME
    ----------  ---------------------
    =           NODE1
    .
    .
    Examples for leading and trailing spaces:
    .
    - Result from a Tivoli Storage Manager version 5.5
    .
    tsm: TSM1>tsm: TSM1>select '    ==  ',node_name from adsm.nodes
    .
    Unnamed[1]     NODE_NAME
    ----------     ------------------
        ==         NODE1
    .
    .
    - Result from a Tivoli Storage Manager version 6.1
    .
    tsm: TSM1>tsm: TSM1>select '    ==  ',node_name from adsm.nodes
    .
    Unnamed[1]  NODE_NAME
    ----------  ------------------
    =           NODE1
    .
    .
    Tivoli Storage Manager Versions Affected:
    Tivoli Storage Manager version 6.1 on all supported platforms
    .
    Initial Impact:
    low
    .
    Additional Keywords:
    zz61 TSM select operator literal SQL
    

Local fix

  • Use  '====' in the select commands to get "=="
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All Tivoli Storage Manager server users of   *
    *                 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.4. 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

    IC65154

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    61A

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-12-17

  • Closed date

    2010-01-07

  • Last modified date

    2010-01-07

  • 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

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"61A","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

Modified date:
07 January 2010