IDS Forum

RE: New chunk has 0 pages free after 30 minutes

Posted By: Clifton Bean
Date: Wednesday, 4 November 2009, at 3:04 p.m.

In Response To: RE: New chunk has 0 pages free after 30 minutes (Lapeire, Jacques)

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 updated—even when you’re 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_MFESRP_Local_MapsMenu_Resturants_1x1

Messages In This Thread

• New chunk has 0 pages free after 30 minutes
  JACQUES LAPEIRE -- Wednesday, 4 November 2009, at 2:05 p.m.
  • RE: New chunk has 0 pages free after 30 minutes
    R Fo -- Wednesday, 4 November 2009, at 2:10 p.m.
    • RE: New chunk has 0 pages free after 30 minutes
      Lapeire, Jacques -- Wednesday, 4 November 2009, at 2:54 p.m.
      • RE: New chunk has 0 pages free after 30 minutes
        Clifton Bean -- Wednesday, 4 November 2009, at 3:04 p.m.
      • RE: New chunk has 0 pages free after 30 minutes
        R Fo -- Wednesday, 4 November 2009, at 3:06 p.m.
  • Re: New chunk has 0 pages free after 30 minutes
    Art Kagel -- Wednesday, 4 November 2009, at 3:03 p.m.
    • RE: New chunk has 0 pages free after 30 minutes
      Lapeire, Jacques -- Wednesday, 4 November 2009, at 3:19 p.m.
    • RE: New chunk has 0 pages free after 30 minutes
      Lapeire, Jacques -- Wednesday, 4 November 2009, at 3:30 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.