IBM Support

IT06648: INCORRECT SELECT OUTPUT AFTER UPGRADE TO 6.3.5 OR 7.1.1 AFTER "DEFINE CURSOR" COMMAND IS USED

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Select commands return incorrect results after upgrade to Tivoli
    Storage Manager Server v6.3.5 or v7.1.1 after a  "DEFINE
    CURSOR" command is used.
    
    For example:
    tsm: TSM11>SELECT VOLUME_NAME FROM libvolumes WHERE
    status='Scratch'
    
    VOLUME_NAME
    ----------------------------------------------------------------
    --
    GRO028L4
    GRO124L4
    GRO209L4
    
    tsm: TSM11>SELECT COUNT(*) FROM libvolumes WHERE
    status='Scratch'
    
      Unnamed[1]
    ------------
               3
    
    
    At the same time, the command  "query  libvolume" on the same
    server
    returns a different result.
    
    TSM11> query libvolume
    
    TS3500LIB    GRO032L4    Private                     Data
    1,035   LTO
    TS3500LIB    GRO124L4    Private                     Data
    1,036   LTO
    TS3500LIB    GRO006L4    Scratch
    1,037   LTO
    TS3500LIB    GRO210L4    Private                     Data
    1,038   LTO
    TS3500LIB    GRO041L4    Scratch
    1,039   LTO
    TS3500LIB    GRO314L4    Private
    1,040   LTO
    
    
    
    The correct output is in "query libvolume" command.
    
    
    
    Customer/L2 Diagnostics:
    
    The problem has been introduced by  APAR IC96223 and occurs when
    the command "define cursor" is used for select statements.
    For example the following command will cause to have an
    incorrect output for any subsequent  select statement:
    
    DEFINE CURSOR C87b12e4 SQL='SELECT * FROM NODES'
    
    Other tables involved may be VOLUMES and EVENTS.
    
    Tivoli Storage Manager Versions Affected: All Tivoli Storage
    Manager Server 6.3.5.x and 7.1.1.x   on all Platforms.
    
    | MDVREGR 6.3.5.0-TIV_5698ISMSV |
    | MDVREGR 7.1.1.0-TIV_5698ISMSV |
    
    
    Initial Impact: low
    
    Additional Keywords: define cursor sql select incorrect db2
    IC96223
    

Local fix

  • Do not use "define cursor" command with select statements
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Tivoli Storage Manager server users of the DEFINE CURSOR *
    * command.                                                     *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See error description.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply fixing level when available. This problem is currently *
    * projected to be fixed in levels 6.3.6, 7.1.1.200, and 7.1.3. *
    * Note that this is subject to change at the discretion of     *
    * IBM.                                                         *
    ****************************************************************
    

Problem conclusion

  • This problem was fixed.
    
    The tables used on the DEFINE CURSOR command will now continue
    to update, but only after either the session using the cursor
    terminates or if the DELETE CURSOR command is used.  If you are
    running an application that is using the DEFINE CURSOR command
    make sure it is deleting the cursors using the DELETE CURSOR
    command, or terminating the session with the Tivoli Storage
    Manager server as soon as it is done with the cursors.  On
    session termination the Tivoli Storage Manager server will
    perform the deletion of the defined cursors.
    
    The following tables are known to be affected by this issue:
    
    ADMIN_SCHEDULES, ADMINS, CLIENT_SCHEDULES, DBSPACE, DB,
    DEVCLASSES, DRIVES, EVENTS, LIBRARIES, LIBVOLUMES, SQL_LICENSES,
    MEDIA, OPTIONS, SCRIPTS, SERVER_GROUP_VIEW, SESSIONS, STGPOOLS,
    VOLUMES, STATUS, AUDITOCC, CLIENTOPTS, MGMTCLASSES, DOMAINSVIEW,
    RESTORES, PROCESSES, DRMEDIA, PATHS, CLOPTSETS, DRMSRPF,
    DRMTRPF, DRMSTANZA, SAN, SHREDSTATUS, SCRIPT_NAMES, LOG, and
    TSM_MON_SETTINGS.
    
    Affected platforms:  AIX, HP-UX, Solaris, Linux, and Windows.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT06648

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    63W

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2015-01-23

  • Closed date

    2015-02-23

  • Last modified date

    2015-07-09

  • 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

  • R63A PSY

       UP

  • R63H PSY

       UP

  • R63L PSY

       UP

  • R63S PSY

       UP

  • R63W PSY

       UP

  • R71A PSY

       UP

  • R71H PSY

       UP

  • R71L PSY

       UP

  • R71S PSY

       UP

  • R71W PSY

       UP



Document information

More support for: Tivoli Storage Manager

Software version: 63W

Reference #: IT06648

Modified date: 09 July 2015