suche 36x36
  • Admin-Scout-small-Banner
           

    CURSOR Admin-Scout

    get the ultimate tool for Informix

    pfeil  
Latest versionsfixlist
14.10.xC11 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

Informix - Problem description

Problem IT35940 Status: Closed

MEMORY LEAK ON RALLOC ON REMOTE SERVERWHERE DATE(DATETIME_COL) =SUBQUERY
WITH DATE_COL FROM A SYNONYM TO THE REMOTE SERVER

product:
INFORMIX SERVER / 5725A3900 / E10 - 
Problem description:
Memory leak on ralloc on remote server when using where
date(datetime_col) = select date_col from a synonym to the
remote server

On a query like:

SELECT col2 FROM tablea WHERE DATE(col2) =
(SELECT rcol4 FROM rtableb WHERE rcol1="XXXX" AND rcol2 = "XXXX"
and rcol3 = "XXXX")
AND col1 = "XXX"

informix@farias-ThinkPad-P50:~/prods/14.10/FC5$ onstat -g ses 72

IBM Informix Dynamic Server Version 14.10.FC5AEE -- On-Line --
Up 01:43:20 -- 507908 Kbytes
2021-02-16 15:09:34

session           effective                            #RSAM
total      used       dynamic
id       user     user      tty      pid      hostname threads
memory     memory     explain
72       informix -         0        30902    xxxxxxxx 1
114688     103128     off

Program :
/home/informix/prods/14.10/FC5/bin/oninit

tid      name     rstcb            flags    curstk   status
83       srvinfx  45962e48         Y--P---  3824     cond wait
netnorm   -

Memory pools    count 2
name         class addr              totalsize  freesize
#allocfrag #freefrag
72           V     4867f040         110592     10816      128
16
72*O0        V     4817f040         4096       744        1
1

name             free       used         name             free
used
overhead         0          6704         scb              0
144
opentable        0          4880         filetable        0
712
log              0          16536        temprec          0
2208
ralloc           0          30944        gentcb           0
1648
ostcb            0          2992         sqscb            0
22592
hashfiletab      0          552          osenv            0
3344
sqtcb            0          9392         fragman          0
336
sapi             0          144

sqscb info
scb              sqscb            optofc   pdqpriority
optcompind  directives
463011c0         481aa028         0        0           2
1

Sess       SQL            Current            Iso Lock       SQL
ISAM F.E.
Id         Stmt type      Database           Lvl Mode       ERR
ERR  Vers  Explain
72         -              testcases          CR  Not Wait   0
0    9.59  Off

Last parsed SQL statement :
  select x0.rcol4 from testcases:"informix".tableb x0 where
(((x0.rcol1 =
    'IF2101' ) AND (x0.rcol2 = 'SIPP' ) ) AND (x0.rcol3 = 'INV'
) )


Subsequent runs of the query, remote server ralloc shows:

onstat -g ses 72|grep ralloc
ralloc           0          61960        gentcb           0
1648
onstat -g ses 72|grep ralloc
ralloc           0          92872        gentcb           0
1648
onstat -g ses 72|grep ralloc
ralloc           0          123784       gentcb           0
1648
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* Users of Informix Server prior to 12.10.xC15 and 14.10.xC6.  *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Informix Server 12.10.xC15 (when available) or    *
* 14.10.xC6 (when available).                                  *
****************************************************************
Local Fix:
Solution
Workaround
****************************************************************
* USERS AFFECTED:                                              *
* Users of Informix Server prior to 12.10.xC15 and 14.10.xC6.  *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Informix Server 12.10.xC15 (when available) or    *
* 14.10.xC6 (when available).                                  *
****************************************************************
Comment
Fixed in Informix Server 12.10.xC15 and 14.10.xC6.
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
17.02.2021
12.05.2021
12.05.2021
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
Informix EditionsInformix Editions
Informix Editions
DocumentationDocumentation
Documentation
IBM NewsletterIBM Newsletter
IBM Newsletter
Current BugsCurrent Bugs
Current Bugs
Bug ResearchBug Research
Bug Research
Bug FixlistsBug Fixlists
Bug Fixlists
Release NotesRelease Notes
Release Notes
Machine NotesMachine Notes
Machine Notes
Release NewsRelease News
Release News
Product LifecycleProduct Lifecycle
Lifecycle
Media DownloadMedia Download
Media Download