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 number
IC78614
Reported component name
TSM SERVER
Reported component ID
5698ISMSV
Reported release
62A
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-09-14
Closed date
2011-10-16
Last modified date
2013-08-22
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
[{"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:
22 August 2013