IC98516: MEMORY LEAK IN GLOBAL POOL WHEN DOING REMOTE SQL STATEMENTS USING THE REMOTE SERVER'S GROUP NAME

APAR status

• Closed as program error.

Error description

• Executing an SQL statement using a remote server's dbservername,
  followed by running SQL statements against the same remote
  server's group name causes a memory leak each time the group
  name is used.
  
  Example:
  
  sqlhosts file:
  g_group1    group       -        -            i=1
  server1     onsoctcp    serv1    serv1_port   g=g_group1
  
  g_group2    group       -        -            i=2
  server2     onsoctcp    serv2    serv2_port   g=g_group2
  
  Connect to server1 in dbaccess and run the following sequence of
  statements:
  
  select * from dbname@server2:tabname;
  select * from dbname@g_group2:tabname:  -- this leaks memory
  every time it is executed
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Informix 11.70 user with remote query using group name       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to IDS-11.70.xC9                                      *
  ****************************************************************
  

Problem conclusion

• Problem Fixed In IDS-11.70.xC9
  

Temporary fix

• using server name instead
  

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

  INFORMIX SERVER

• Fixed component ID

  5725A3900

Applicable component levels

• RB70 PSY

     UP