IC78614: QUERY SESSION OR SELECT FROM SESSIONS MAY FAIL WITH ANR0102E ADMSQL.C(XXXX): ERROR 8 INSERTING ROW IN TABLE "ADM_SESST"

APAR status

• Closed as program error.

Error description

• If there are active sessions through a proxy node,
  administrative command QUERY SESSION or SELECT FROM SESSIONS
  may fail.
  
  QUERY SESSION or SELECT FROM SESSIONS fails:
  
  08/29/2011 11:35:12 ANR2017I Administrator ADMIN issued command:
    select * from sessions (SESSION: 123)
  08/29/2011 11:35:12 ANR0162W Supplemental database diagnostic
    information:
    -1:22001:-99999 ([IBM][CLI Driver] CLI0109E  String data
    right truncation. SQLSTATE=22001). (SESSION: 123)
  08/29/2011 11:35:12 ANR0157W Database operation INSERT for table
    adm_sesst failed with result code 8 and tracking
    ID: 1192b2378. (SESSION: 123)
  08/29/2011 11:35:12 ANR0158W Database operation INSERT for table
    adm_sesst failed with operation code 8 and tracking
    id 1192b2378. The data for column 0 is: (int32)110177.
    (SESSION: 123)
  08/29/2011 11:35:12 ANR0102E admsql.c(5327): Error 8 inserting
    row in table "adm_sesst". (SESSION: 123)
  
  Tivoli Storage Manager Versions Affected:
  Tivoli Storage Manager Server version 6.1 and 6.2 on all
  platforms
  
  Initial Impact:
  medium
  
  Additional Keywords:
  zz61 zz62 TSM proxy session query select
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Tivoli Storage Manager server users of   *
  *                 the SELECT FROM SESSIONS commands.           *
  ****************************************************************
  * PROBLEM DESCRIPTION: See ERROR DESCRIPTION.                  *
  *                      The problem only affects users of the   *
  *                      SELECT FROM SESSIONS command            *
  *                      and does not affect users of the        *
  *                      QUERY SESSION command.                  *
  ****************************************************************
  * RECOMMENDATION: Apply fixing level when available. This      *
  *                 problem is currently projected to be         *
  *                 fixed in levels 6.2.4 and 6.3.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 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

• R62A PSY

     UP

• R62H PSY

     UP

• R62L PSY

     UP

• R62S PSY

     UP

• R62W PSY

     UP