New chunk has 0 pages free after 30 minutes
A DBA on IDS 9.40 (Solaris) added a 5 GB chunk to a nearly full dbspace and found it showed 0 free pages within 30 minutes, with nothing unusual in the message log. Respondents suggested checking what actually occupied the chunk with 'oncheck -pe'. The output showed three application tables (cnin801, cnin8, cnout801) consuming the entire chunk in huge extents. So the space was genuinely used, not an internal quirk; the application developers confirmed a runaway loop generating masses of messages, a problem they had seen at another site.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi folks,
can anyone help me out (or explain what's happening) ??
I have IDS 9.40 UC6 running on Solaris 9 (sparc), dbspaces are configured on a
filesystem. One dbspace had only 312 pages free so I added a chunk of 5 Gb.
All went well, but after less than 30 minutes, the "onstat -d" indicates 0
pages free while other values do not change. No particular messages in the
logfile.
Here's part of the output of "onstat -d" :
Chunks
address chunk/dbs offset size free bpages flags pathname
19d0e928 1 1 0 500000 490826 PO-B /infor/dkisa
19d0ec80 2 2 0 500000 496781 PO-B /d02/DBisa/temp
19d0ee08 3 3 0 40000000 312 PO-B /d02/DBisa/prod
19e44c30 4 4 0 25000 24851 PO-B /d02/DBisa/unused
19e44db8 5 5 0 250000 137948 PO-B /d02/DBisa/perso
1a4e4018 6 6 0 750000 224947 PO-B /r02/DBisa/logspace
1d7a6940 7 3 0 2500000 0 PO-B /d02/DBisa/prod_ch1
7 active, 32766 maximum
Is this normal behaviour ? Internal reorganisation or really occupied space ?
Thanks for any feedback.
Jacques Lapeire
Hi
Nobody deleted the Raw device ?
It means the chunk definition is still ON and the chunk physical no more
Or ... is the chunk used for Logical Log or Physical Log ?
Sould be good if whole output of onstat -d and onstat -D will be sent for us
...
BR
R Ferronato
> To: ids@iiug.org
> From: jacques.lapeire@ts.fujitsu.com
> Subject: New chunk has 0 pages free after 30 minutes [17908]
> Date: Wed, 4 Nov 2009 14:05:40 -0500
>
> Hi folks,
>
> can anyone help me out (or explain what's happening) ??
>
> I have IDS 9.40 UC6 running on Solaris 9 (sparc), dbspaces are configured on
a
> filesystem. One dbspace had only 312 pages free so I added a chunk of 5 Gb.
>
> All went well, but after less than 30 minutes, the "onstat -d" indicates 0
> pages free while other values do not change. No particular messages in the
> logfile.
>
> Here's part of the output of "onstat -d" :
>
> Chunks
> address chunk/dbs offset size free bpages flags pathname
> 19d0e928 1 1 0 500000 490826 PO-B /infor/dkisa
> 19d0ec80 2 2 0 500000 496781 PO-B /d02/DBisa/temp
> 19d0ee08 3 3 0 40000000 312 PO-B /d02/DBisa/prod
> 19e44c30 4 4 0 25000 24851 PO-B /d02/DBisa/unused
> 19e44db8 5 5 0 250000 137948 PO-B /d02/DBisa/perso
> 1a4e4018 6 6 0 750000 224947 PO-B /r02/DBisa/logspace
> 1d7a6940 7 3 0 2500000 0 PO-B /d02/DBisa/prod_ch1
> 7 active, 32766 maximum
>
> Is this normal behaviour ? Internal reorganisation or really occupied space ?
>
> Thanks for any feedback.
>
> Jacques Lapeire
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
_________________________________________________________________
Keep your friends updatedeven when youre not signed in.
http://www.microsoft.com/middleeast/windows/windowslive/see-it-in-action/social-
network-basics.aspx?ocid=PID23461::T:WLMTAGL:ON:WL:en-xm:SI_SB_5:092010
Hi,
it's not about RAW-devices, it's on a filesystem !!
Here's what I've done
touch /d02/DBisa/prod_ch1
chown informix:informix /d02/DBisa/prod_ch1
chmod 660 /d02/DBisa/prod_ch1
onspaces -a prod -p /d02/DBisa/prod_ch1 -o 0 -s 5000000
Verifying physical disk space, please wait ...
Chunk successfully added.
This is in the LOGfile :
19:21:42 Maximum server connections 427
19:21:42 Chunk '/d02/DBisa/prod_ch1' added to space 'prod'.
and here is the full output of onstat -d :
onstat -d
IBM Informix Dynamic Server Version 9.40.UC6 -- On-Line -- Up 82 days 09:07:57
-- 1086464 Kbytes
Dbspaces
address number flags fchunk nchunks flags owner name
19d0e7d8 1 0x60001 1 1 N B informix rootdbs
1a4e41a0 2 0x42001 2 1 N TB informix temp
1a4e42f0 3 0x60001 3 2 N B informix prod
1a4e4440 4 0x40001 4 1 N B informix unused
1a4e4590 5 0x40001 5 1 N B informix perso
1a4e46e0 6 0x40001 6 1 N B informix logspace
6 active, 2047 maximum
Chunks
address chunk/dbs offset size free bpages flags pathname
19d0e928 1 1 0 500000 428786 PO-B /infor/dkisa
19d0ec80 2 2 0 500000 496773 PO-B /d02/DBisa/temp
19d0ee08 3 3 0 40000000 312 PO-B /d02/DBisa/prod
19e44c30 4 4 0 25000 24851 PO-B /d02/DBisa/unused
19e44db8 5 5 0 250000 137948 PO-B /d02/DBisa/perso
1a4e4018 6 6 0 750000 224947 PO-B /r02/DBisa/logspace
1d7a6940 7 3 0 2500000 0 PO-B /d02/DBisa/prod_ch1
7 active, 32766 maximum
Expanded chunk capacity mode: always
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of R Fo
Sent: Wednesday, November 04, 2009 8:11 PM
To: ids@iiug.org
Subject: RE: New chunk has 0 pages free after 30 minutes [17910]
Hi
Nobody deleted the Raw device ?
It means the chunk definition is still ON and the chunk physical no more
Or ... is the chunk used for Logical Log or Physical Log ?
Sould be good if whole output of onstat -d and onstat -D will be sent for us
....
BR
R Ferronato
> To: ids@iiug.org
> From: jacques.lapeire@ts.fujitsu.com
> Subject: New chunk has 0 pages free after 30 minutes [17908]
> Date: Wed, 4 Nov 2009 14:05:40 -0500
>
> Hi folks,
>
> can anyone help me out (or explain what's happening) ??
>
> I have IDS 9.40 UC6 running on Solaris 9 (sparc), dbspaces are configured on
a
> filesystem. One dbspace had only 312 pages free so I added a chunk of 5 Gb.
>
> All went well, but after less than 30 minutes, the "onstat -d" indicates 0
> pages free while other values do not change. No particular messages in the
> logfile.
>
> Here's part of the output of "onstat -d" :
>
> Chunks
> address chunk/dbs offset size free bpages flags pathname
> 19d0e928 1 1 0 500000 490826 PO-B /infor/dkisa
> 19d0ec80 2 2 0 500000 496781 PO-B /d02/DBisa/temp
> 19d0ee08 3 3 0 40000000 312 PO-B /d02/DBisa/prod
> 19e44c30 4 4 0 25000 24851 PO-B /d02/DBisa/unused
> 19e44db8 5 5 0 250000 137948 PO-B /d02/DBisa/perso
> 1a4e4018 6 6 0 750000 224947 PO-B /r02/DBisa/logspace
> 1d7a6940 7 3 0 2500000 0 PO-B /d02/DBisa/prod_ch1
> 7 active, 32766 maximum
>
> Is this normal behaviour ? Internal reorganisation or really occupied space
?
>
> Thanks for any feedback.
>
> Jacques Lapeire
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
_________________________________________________________________
Keep your friends updatedeven when youre not signed in.
http://www.microsoft.com/middleeast/windows/windowslive/see-it-in-action/social-
network-basics.aspx?ocid=PID23461::T:WLMTAGL:ON:WL:en-xm:SI_SB_5:092010
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Run oncheck -pe p see what has been placed in that chunk.
Art
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do
those opinions reflect those of other individuals affiliated with any entity
with which I am affiliated nor those of the entities themselves.
On Wed, Nov 4, 2009 at 2:05 PM, JACQUES LAPEIRE <
jacques.lapeire@ts.fujitsu.com> wrote:
> Hi folks,
>
> can anyone help me out (or explain what's happening) ??
>
> I have IDS 9.40 UC6 running on Solaris 9 (sparc), dbspaces are configured
> on a
> filesystem. One dbspace had only 312 pages free so I added a chunk of 5 Gb.
>
> All went well, but after less than 30 minutes, the "onstat -d" indicates 0
> pages free while other values do not change. No particular messages in the
> logfile.
>
> Here's part of the output of "onstat -d" :
>
> Chunks
> address chunk/dbs offset size free bpages flags pathname
> 19d0e928 1 1 0 500000 490826 PO-B /infor/dkisa
> 19d0ec80 2 2 0 500000 496781 PO-B /d02/DBisa/temp
> 19d0ee08 3 3 0 40000000 312 PO-B /d02/DBisa/prod
> 19e44c30 4 4 0 25000 24851 PO-B /d02/DBisa/unused
> 19e44db8 5 5 0 250000 137948 PO-B /d02/DBisa/perso
> 1a4e4018 6 6 0 750000 224947 PO-B /r02/DBisa/logspace
> 1d7a6940 7 3 0 2500000 0 PO-B /d02/DBisa/prod_ch1
> 7 active, 32766 maximum
>
> Is this normal behaviour ? Internal reorganisation or really occupied space
> ?
>
> Thanks for any feedback.
>
> Jacques Lapeire
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--0023545bddb83fdb67047791190d
When you perform an oncheck -pe, what does it list for the "prod" dbspace?
Take care.
Clifton
> To: ids@iiug.org
> From: jacques.lapeire@ts.fujitsu.com
> Subject: RE: New chunk has 0 pages free after 30 minutes [17913]
> Date: Wed, 4 Nov 2009 14:54:42 -0500
>
> Hi,
>
> it's not about RAW-devices, it's on a filesystem !!
>
> Here's what I've done
>
> touch /d02/DBisa/prod_ch1
> chown informix:informix /d02/DBisa/prod_ch1
> chmod 660 /d02/DBisa/prod_ch1
> onspaces -a prod -p /d02/DBisa/prod_ch1 -o 0 -s 5000000>
> Verifying physical disk space, please wait ...
>
> Chunk successfully added.
>
> This is in the LOGfile :
>
> 19:21:42 Maximum server connections 427
> 19:21:42 Chunk '/d02/DBisa/prod_ch1' added to space 'prod'.
>
> and here is the full output of onstat -d :
>
> onstat -d>
> IBM Informix Dynamic Server Version 9.40.UC6 -- On-Line -- Up 82 days
09:07:57
> -- 1086464 Kbytes>
> Dbspaces
> address number flags fchunk nchunks flags owner name
> 19d0e7d8 1 0x60001 1 1 N B informix rootdbs
> 1a4e41a0 2 0x42001 2 1 N TB informix temp
> 1a4e42f0 3 0x60001 3 2 N B informix prod
> 1a4e4440 4 0x40001 4 1 N B informix unused
> 1a4e4590 5 0x40001 5 1 N B informix perso
> 1a4e46e0 6 0x40001 6 1 N B informix logspace
> 6 active, 2047 maximum
>
> Chunks
> address chunk/dbs offset size free bpages flags pathname
> 19d0e928 1 1 0 500000 428786 PO-B /infor/dkisa
> 19d0ec80 2 2 0 500000 496773 PO-B /d02/DBisa/temp
> 19d0ee08 3 3 0 40000000 312 PO-B /d02/DBisa/prod
> 19e44c30 4 4 0 25000 24851 PO-B /d02/DBisa/unused
> 19e44db8 5 5 0 250000 137948 PO-B /d02/DBisa/perso
> 1a4e4018 6 6 0 750000 224947 PO-B /r02/DBisa/logspace
> 1d7a6940 7 3 0 2500000 0 PO-B /d02/DBisa/prod_ch1
> 7 active, 32766 maximum
>
> Expanded chunk capacity mode: always
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of R Fo
> Sent: Wednesday, November 04, 2009 8:11 PM
> To: ids@iiug.org
> Subject: RE: New chunk has 0 pages free after 30 minutes [17910]
>
> Hi
>
> Nobody deleted the Raw device ?
> It means the chunk definition is still ON and the chunk physical no more
> Or ... is the chunk used for Logical Log or Physical Log ?
>
> Sould be good if whole output of onstat -d and onstat -D will be sent for us
> .....
>
> BR
>
> R Ferronato
>
> > To: ids@iiug.org
> > From: jacques.lapeire@ts.fujitsu.com
> > Subject: New chunk has 0 pages free after 30 minutes [17908]
> > Date: Wed, 4 Nov 2009 14:05:40 -0500
> >
> > Hi folks,
> >
> > can anyone help me out (or explain what's happening) ??
> >
> > I have IDS 9.40 UC6 running on Solaris 9 (sparc), dbspaces are configured
on
> a
> > filesystem. One dbspace had only 312 pages free so I added a chunk of 5 Gb.
> >
> > All went well, but after less than 30 minutes, the "onstat -d" indicates 0
> > pages free while other values do not change. No particular messages in the
> > logfile.
> >
> > Here's part of the output of "onstat -d" :
> >
> > Chunks
> > address chunk/dbs offset size free bpages flags pathname
> > 19d0e928 1 1 0 500000 490826 PO-B /infor/dkisa
> > 19d0ec80 2 2 0 500000 496781 PO-B /d02/DBisa/temp
> > 19d0ee08 3 3 0 40000000 312 PO-B /d02/DBisa/prod
> > 19e44c30 4 4 0 25000 24851 PO-B /d02/DBisa/unused
> > 19e44db8 5 5 0 250000 137948 PO-B /d02/DBisa/perso
> > 1a4e4018 6 6 0 750000 224947 PO-B /r02/DBisa/logspace
> > 1d7a6940 7 3 0 2500000 0 PO-B /d02/DBisa/prod_ch1
> > 7 active, 32766 maximum
> >
> > Is this normal behaviour ? Internal reorganisation or really occupied space
> ?
> >
> > Thanks for any feedback.
> >
> > Jacques Lapeire
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
> _________________________________________________________________
> Keep your friends updatedeven when youre not signed in.
>
>
>
http://www.microsoft.com/middleeast/windows/windowslive/see-it-in-action/social-
network-basics.aspx?ocid=PID23461::T:WLMTAGL:ON:WL:en-xm:SI_SB_5:092010
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
_________________________________________________________________
Bing brings you maps, menus, and reviews organized in one place.
http://www.bing.com/search?q=restaurants&form=MFESRP&publ=WLHMTAG&crea=TEXT_MFES
RP_Local_MapsMenu_Resturants_1x1
Sure, all statements are Ok ...
The "prod" dbspace is not physical log, right ?
The interesting thing is you have other chunk (# 3) as the first chunk of
dbspace "prod" and it mention has 2 chunks for that dbspace.
Could any table have a very large "next extent" and fill a whole chunk ?
Or, you create a new table with very large first extent ?
You could find all extents of tblspace in this chunk, running a select agaist
sysmaster tables.
Sorry I do not have an IDS instance now to tell you the name of the sysmaster
tables...
But is something like syschunks , sysextents
BR
RFO
> To: ids@iiug.org
> From: jacques.lapeire@ts.fujitsu.com
> Subject: RE: New chunk has 0 pages free after 30 minutes [17913]
> Date: Wed, 4 Nov 2009 14:54:42 -0500
>
> Hi,
>
> it's not about RAW-devices, it's on a filesystem !!
>
> Here's what I've done
>
> touch /d02/DBisa/prod_ch1
> chown informix:informix /d02/DBisa/prod_ch1
> chmod 660 /d02/DBisa/prod_ch1
> onspaces -a prod -p /d02/DBisa/prod_ch1 -o 0 -s 5000000>
> Verifying physical disk space, please wait ...
>
> Chunk successfully added.
>
> This is in the LOGfile :
>
> 19:21:42 Maximum server connections 427
> 19:21:42 Chunk '/d02/DBisa/prod_ch1' added to space 'prod'.
>
> and here is the full output of onstat -d :
>
> onstat -d>
> IBM Informix Dynamic Server Version 9.40.UC6 -- On-Line -- Up 82 days
09:07:57
> -- 1086464 Kbytes>
> Dbspaces
> address number flags fchunk nchunks flags owner name
> 19d0e7d8 1 0x60001 1 1 N B informix rootdbs
> 1a4e41a0 2 0x42001 2 1 N TB informix temp
> 1a4e42f0 3 0x60001 3 2 N B informix prod
> 1a4e4440 4 0x40001 4 1 N B informix unused
> 1a4e4590 5 0x40001 5 1 N B informix perso
> 1a4e46e0 6 0x40001 6 1 N B informix logspace
> 6 active, 2047 maximum
>
> Chunks
> address chunk/dbs offset size free bpages flags pathname
> 19d0e928 1 1 0 500000 428786 PO-B /infor/dkisa
> 19d0ec80 2 2 0 500000 496773 PO-B /d02/DBisa/temp
> 19d0ee08 3 3 0 40000000 312 PO-B /d02/DBisa/prod
> 19e44c30 4 4 0 25000 24851 PO-B /d02/DBisa/unused
> 19e44db8 5 5 0 250000 137948 PO-B /d02/DBisa/perso
> 1a4e4018 6 6 0 750000 224947 PO-B /r02/DBisa/logspace
> 1d7a6940 7 3 0 2500000 0 PO-B /d02/DBisa/prod_ch1
> 7 active, 32766 maximum
>
> Expanded chunk capacity mode: always
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of R Fo
> Sent: Wednesday, November 04, 2009 8:11 PM
> To: ids@iiug.org
> Subject: RE: New chunk has 0 pages free after 30 minutes [17910]
>
> Hi
>
> Nobody deleted the Raw device ?
> It means the chunk definition is still ON and the chunk physical no more
> Or ... is the chunk used for Logical Log or Physical Log ?
>
> Sould be good if whole output of onstat -d and onstat -D will be sent for us
> .....
>
> BR
>
> R Ferronato
>
> > To: ids@iiug.org
> > From: jacques.lapeire@ts.fujitsu.com
> > Subject: New chunk has 0 pages free after 30 minutes [17908]
> > Date: Wed, 4 Nov 2009 14:05:40 -0500
> >
> > Hi folks,
> >
> > can anyone help me out (or explain what's happening) ??
> >
> > I have IDS 9.40 UC6 running on Solaris 9 (sparc), dbspaces are configured
on
> a
> > filesystem. One dbspace had only 312 pages free so I added a chunk of 5 Gb.
> >
> > All went well, but after less than 30 minutes, the "onstat -d" indicates 0
> > pages free while other values do not change. No particular messages in the
> > logfile.
> >
> > Here's part of the output of "onstat -d" :
> >
> > Chunks
> > address chunk/dbs offset size free bpages flags pathname
> > 19d0e928 1 1 0 500000 490826 PO-B /infor/dkisa
> > 19d0ec80 2 2 0 500000 496781 PO-B /d02/DBisa/temp
> > 19d0ee08 3 3 0 40000000 312 PO-B /d02/DBisa/prod
> > 19e44c30 4 4 0 25000 24851 PO-B /d02/DBisa/unused
> > 19e44db8 5 5 0 250000 137948 PO-B /d02/DBisa/perso
> > 1a4e4018 6 6 0 750000 224947 PO-B /r02/DBisa/logspace
> > 1d7a6940 7 3 0 2500000 0 PO-B /d02/DBisa/prod_ch1
> > 7 active, 32766 maximum
> >
> > Is this normal behaviour ? Internal reorganisation or really occupied space
> ?
> >
> > Thanks for any feedback.
> >
> > Jacques Lapeire
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
> _________________________________________________________________
> Keep your friends updatedeven when youre not signed in.
>
>
>
http://www.microsoft.com/middleeast/windows/windowslive/see-it-in-action/social-
network-basics.aspx?ocid=PID23461::T:WLMTAGL:ON:WL:en-xm:SI_SB_5:092010
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
_________________________________________________________________
Windows Live Hotmail: Your friends can get your Facebook updates, right from
Hotmail®.
http://www.microsoft.com/middleeast/windows/windowslive/see-it-in-action/social-
network-basics.aspx?ocid=PID23461::T:WLMTAGL:ON:WL:en-xm:SI_SB_4:092009
Hi ,
here's the output of oncheck -pe (part for the new chunk)
Chunk Pathname Size Used F7
/d02/DBisa/prod_ch1 2500000 2500000 0
Description Offset Size
------------------------------------------------------------- -------- --------
RESERVED PAGES 0 2
CHUNK FREELIST PAGE 2 1
isa:'informix'.cnin801 3 960000
isa:'informix'.cnin8 960003 50000
isa:'informix'.cnout801 1010003 1489997
Total Used: 2500000
Total Free: 0
Does this mean the space is already occupied ?
Thanks,
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art Kagel
Sent: Wednesday, November 04, 2009 9:03 PM
To: ids@iiug.org
Subject: Re: New chunk has 0 pages free after 30 minutes [17915]
Run oncheck -pe p see what has been placed in that chunk.
Art
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do
those opinions reflect those of other individuals affiliated with any entity
with which I am affiliated nor those of the entities themselves.
On Wed, Nov 4, 2009 at 2:05 PM, JACQUES LAPEIRE <
jacques.lapeire@ts.fujitsu.com> wrote:
> Hi folks,
>
> can anyone help me out (or explain what's happening) ??
>
> I have IDS 9.40 UC6 running on Solaris 9 (sparc), dbspaces are configured
> on a
> filesystem. One dbspace had only 312 pages free so I added a chunk of 5 Gb.
>
> All went well, but after less than 30 minutes, the "onstat -d" indicates 0
> pages free while other values do not change. No particular messages in the
> logfile.
>
> Here's part of the output of "onstat -d" :
>
> Chunks
> address chunk/dbs offset size free bpages flags pathname
> 19d0e928 1 1 0 500000 490826 PO-B /infor/dkisa
> 19d0ec80 2 2 0 500000 496781 PO-B /d02/DBisa/temp
> 19d0ee08 3 3 0 40000000 312 PO-B /d02/DBisa/prod
> 19e44c30 4 4 0 25000 24851 PO-B /d02/DBisa/unused
> 19e44db8 5 5 0 250000 137948 PO-B /d02/DBisa/perso
> 1a4e4018 6 6 0 750000 224947 PO-B /r02/DBisa/logspace
> 1d7a6940 7 3 0 2500000 0 PO-B /d02/DBisa/prod_ch1
> 7 active, 32766 maximum
>
> Is this normal behaviour ? Internal reorganisation or really occupied space
> ?
>
> Thanks for any feedback.
>
> Jacques Lapeire
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--0023545bddb83fdb67047791190d
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Ok thanks a lot guys,
the output of the oncheck -pe indicated some tables and I contacted the
developers of the application,
something seems to be in a loop generating lots of messages !!
They had a similar problem on another site.
Thanks again !!
Best regards
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art Kagel
Sent: Wednesday, November 04, 2009 9:03 PM
To: ids@iiug.org
Subject: Re: New chunk has 0 pages free after 30 minutes [17915]
Run oncheck -pe p see what has been placed in that chunk.
Art
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do
those opinions reflect those of other individuals affiliated with any entity
with which I am affiliated nor those of the entities themselves.
On Wed, Nov 4, 2009 at 2:05 PM, JACQUES LAPEIRE <
jacques.lapeire@ts.fujitsu.com> wrote:
> Hi folks,
>
> can anyone help me out (or explain what's happening) ??
>
> I have IDS 9.40 UC6 running on Solaris 9 (sparc), dbspaces are configured
> on a
> filesystem. One dbspace had only 312 pages free so I added a chunk of 5 Gb.
>
> All went well, but after less than 30 minutes, the "onstat -d" indicates 0
> pages free while other values do not change. No particular messages in the
> logfile.
>
> Here's part of the output of "onstat -d" :
>
> Chunks
> address chunk/dbs offset size free bpages flags pathname
> 19d0e928 1 1 0 500000 490826 PO-B /infor/dkisa
> 19d0ec80 2 2 0 500000 496781 PO-B /d02/DBisa/temp
> 19d0ee08 3 3 0 40000000 312 PO-B /d02/DBisa/prod
> 19e44c30 4 4 0 25000 24851 PO-B /d02/DBisa/unused
> 19e44db8 5 5 0 250000 137948 PO-B /d02/DBisa/perso
> 1a4e4018 6 6 0 750000 224947 PO-B /r02/DBisa/logspace
> 1d7a6940 7 3 0 2500000 0 PO-B /d02/DBisa/prod_ch1
> 7 active, 32766 maximum
>
> Is this normal behaviour ? Internal reorganisation or really occupied space
> ?
>
> Thanks for any feedback.
>
> Jacques Lapeire
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--0023545bddb83fdb67047791190d
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Related threads
- IDS 10 table-level restore
- Informix Development Webinar December 11, 2007
- ontape -p/r with changed ROOTPATH
- Migrate from HP PA-RISC to HP ITANIUM by ontape