IC76351: ERROR 9 DETECTED WHILE FREEING MEMORY DURING QUERY SESSIONS OR SELECT FROM SESSIONS

IBM Tivoli Storage Manager V5.5 Fix Pack 6 (5.5.6) Server Downloads

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 is sysrouted FROM one or more of the following:

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

  PM40616

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