| Author |
IQ can't release paging space?
|
|
| Peter Yu 2005-08-01, 3:25 am |
| Does IQ release paging space when finishing a query?
I run several BIG queries, and then I see paging space usage grows up. But
paging space never goes down after finishing those queris, unless shuting
down IQ server. Can anyone tell me what's wrong?
If the paging space never goes down, OS may freeze. And I have to reboot the
system. Who can tell me how to solve this case?
Thanks!
ps.
(1)AIX 5.1 32bit, 12GB RAM, 6 CPUs
(2)sp_iqstatus
Version:
12.5.0/030616/P/ESD 3/RS6000MP/AIX 5.1.0/64bit/2003-06-16 22:10:36
(3)IQ configuration file
-c 48m
-gc 20
-gd all
-gl all
-gm 100
-gp 4096
-ti 4400
-ud
-iqtc 3000
-iqmc 6000
| |
| Thomas Johansen 2005-09-13, 1:25 pm |
| Do you get any error in the log?
Latest ESD for IQ 12.5.x are ESD17 could be worth to try...
you could also checkout the coverletter
> (2)sp_iqstatus
> Version:
> 12.5.0/030616/P/ESD 3/RS6000MP/AIX
> 5.1.0/64bit/2003-06-16 22:10:36
| |
| Peter Yu 2005-09-23, 3:24 am |
| There isn't any error in the log.
Only 'out of paging space' messages in OS(AIX) log(use errpt to look up the
log).
You mean the latest ESD would help?
<Thomas Johansen> 撰寫於郵件新聞:43271
136.3bab.1681692777@sybase.com...[color=darkred]
> Do you get any error in the log?
>
> Latest ESD for IQ 12.5.x are ESD17 could be worth to try...
> you could also checkout the coverletter
>
| |
| dbmethods 2005-09-24, 8:24 pm |
| Search AIX 5.3 manual on paging space garbage collection.
This is a new feature on 5.3. I haven't tested it out, so no clue it is
fixed or not.
On Thu, 22 Sep
2005 23:05:26 -0700, Peter Yu wrote:
[color=darkred]
> There isn't any error in the log.
> Only 'out of paging space' messages in OS(AIX) log(use errpt to look up the
> log).
>
> You mean the latest ESD would help?
>
>
>
> <Thomas Johansen> 撰寫於郵件新聞:43271
136.3bab.1681692777@sybase.com...
|
|
|
|