IBM Support

IC59884: TSM SELECT * FROM SESSIONS OUTPUT IS INCORRECT

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The CLIENT_NAME entry from "select * from sessions" is
    incorrect. This problem occurs for server to server sessions.
    The correct entry is in the "Client Name" entry from
    "query session f=d" output.
    .
    Example:
    The following commands ran on a TSM library manager.
    The TSM library manager has the name LM_MANAGER.
    The involved TSM library client has the name LC_CLIENT
    .
    query session f=d
                  Sess Number: 1,000
                 Comm. Method: Tcp/Ip
                   Sess State: IdleW
                    Wait Time: 23 S
                   Bytes Sent: 328
                  Bytes Recvd: 262
                    Sess Type: Server
                     Platform: AIX-RS/6000
                  Client Name: LC_CLIENT
          Media Access Status:
                    User Name:
    Date/Time First Data Sent:
       Proxy By Storage Agent:
    .
    select * from sessions
    .
           SESSION_ID: 1000
           START_TIME: 2009-02-05 13:27:08.000000
           COMMMETHOD: Tcp/Ip
                STATE: IdleW
         WAIT_SECONDS: 23
           BYTES_SENT: 328
       BYTES_RECEIVED: 262
         SESSION_TYPE: Server
      CLIENT_PLATFORM: AIX-RS/6000
          CLIENT_NAME: LM_MANAGER
           OWNER_NAME:
     MOUNT_POINT_WAIT:
     INPUT_MOUNT_WAIT:
       INPUT_VOL_WAIT:
     INPUT_VOL_ACCESS:
    OUTPUT_MOUNT_WAIT:
      OUTPUT_VOL_WAIT:
    OUTPUT_VOL_ACCESS:
            LAST_VERB: GetIdleVolumeVerb
           VERB_STATE: Sent
    .
    The entry of CLIENT_NAME is here the TSM library manager
    (LM_MANAGER) instead of the name of the involved
    TSM library client (LC_CLIENT).
    The correct value is LC_CLIENT, seen in the "Client Name" entry
    from "q session f=d" output.
    .
    TSM Versions Affected:
    All supported TSM server and storage agents
    .
    Initial Impact: low
    .
    Additional Keywords: s2s. server to server, LM, LC, STA
    

Local fix

  • Use "query session f=d" instead of "select * from sessions"
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All TSM Server users of Select from the      *
    *                 Sessions Table.                              *
    ****************************************************************
    * PROBLEM DESCRIPTION: See ERROR DESCRIPTION.                  *
    ****************************************************************
    * RECOMMENDATION: Apply fixing level when available.           *
    *                 This problem is currently projected to       *
    *                 be fixed in levels 5.5.3 and 6.1.1.          *
    *                 Note that this is subject to change at       *
    *                 the discretion of IBM.                       *
    ****************************************************************
    *
    

Problem conclusion

  • The TSM server has been corrected.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC59884

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    54A

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-02-09

  • Closed date

    2009-02-23

  • Last modified date

    2009-02-23

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    PK81209

Fix information

  • Fixed component name

    TSM SERVER

  • Fixed component ID

    5698ISMSV

Applicable component levels

  • R55A PSY

       UP

  • R55H PSY

       UP

  • R55L PSY

       UP

  • R55S PSY

       UP

  • R55W PSY

       UP

  • R55Z PSY

       UP

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

Document Information

Modified date:
15 September 2021