A fix is available
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. Following error can be noted in dsmserv.err log file: 05/02/2011 23:05:40 ANR9999D pkmemory.c(845): Error 9 detected while freeing memory; free was called from smqry.c(1933), memory was allocated from smqry.c(495). QUERY SESSION or SELECT FROM SESSIONS fails: 05/02/11 23:05:40 ANR2017I Administrator ADMIN issued command: select count(session_id) as ACTIVE from sessions (SESSION: 8877) 05/02/11 23:05:40 ANR0162W Supplemental database diagnostic information: -1:22001:-99999 ([IBM][CLI Driver] CLI0109E String data right truncation. SQLSTATE=22001). (SESSION: 8877) 05/02/11 23:05:40 ANR0157W Database operation INSERT for table adm_sesst failed with result code 8 and tracking ID: 0x19089268. (SESSION: 8877) 05/02/11 23:05:40 ANR0158W Database operation INSERT for table adm_sesst failed with operation code 8 and tracking id 0x19089268. The data for column 0 is: (int32)8830. (SESSION: 8877) 05/02/11 23:05:40 ANR0102E admsql.c(5317): Error 8 inserting row in table "adm_sesst". (SESSION: 8877) TSM Versions Affected: Tivoli Storage Manager server all versions on all platforms. Initial Impact: Low Additional Keywords: proxy session query select pkmemory.c smqry.c CLI0109E
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All Tivoli Storage Manager server users of * * the QUERY SESSION and SELECT FROM SESSIONS * * commands. * **************************************************************** * PROBLEM DESCRIPTION: See ERROR DESCRIPTION. * **************************************************************** * RECOMMENDATION: Apply fixing level when available. This * * problem is currently projected to be * * fixed in levels 5.5.6 and 6.2.3. * * Note that this is subject to change at * * the discretion of IBM. * **************************************************************** *
Problem conclusion
This problem was fixed. Affected platforms: AIX, HP-UX, Sun Solaris, Linux, Windows and z/OS.
Temporary fix
Comments
APAR Information
APAR number
IC76351
Reported component name
TSM SERVER
Reported component ID
5698ISMSV
Reported release
62L
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-05-13
Closed date
2011-06-01
Last modified date
2013-08-21
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
R55A PSY
UP
R55H PSY
UP
R55L PSY
UP
R55S PSY
UP
R55W PSY
UP
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
[{"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":"62L"}]
Document Information
Modified date:
18 September 2021