IBM Support

IC99695: SELECT OUTPUT FROM TABLE "NODES" RETURNS INCORRECT VALUE ABOUT "OPTION_SET" FIELD

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Even if the following command is executed without any error on a
    Tivoli Storage Manager server against a node for updating the
    "option_set" field to NULL:
    
    Update node node_name clopt=
    
    the following select statement will continue to return an
    incorrect value as if the option_set field is still populated:
    
    select count as "count(*)" from nodes where node_name like
    'node_na%' and option_set like '%'
    
    
        count(*)
    ------------
               1
    
    Customer/L2 diagnostics:
    The "update node" command does not set correctly the option_set
    field  to NULL and therefore the select statement will continue
    to report erroneously  that the "option_set" field is populated.
    
    Tivoli Storage Manager Versions Affected: All Tivoli Storage
    Manager  Server on all platforms.
    
    
    Initial Impact: Low
    
    Additional Keywords: update node option_set count select
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Tivoli Storage Manager server users.                     *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See ERROR DESCRIPTION.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply fixing level when available. This problem is currently *
    * projected to be fixed in level 7.1.1. Note that this is      *
    * subject to change at the discretion of IBM.                  *
    ****************************************************************
    

Problem conclusion

  • This problem was fixed.
    Affected platforms:  AIX, HP-UX, Solaris, Linux, and Windows.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC99695

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    62A

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-02-27

  • Closed date

    2014-04-03

  • Last modified date

    2014-04-03

  • 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

  • R71A PSY

       UP

  • R71H PSY

       UP

  • R71L PSY

       UP

  • R71S PSY

       UP

  • R71W 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":"62A","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

Modified date:
03 April 2014