RE: 2GB chunk limit (Bigger chunks despite disabled mode in 9.40)
Posted in 2004
Topics: Storage & Space Management, SQL Development & Query Writing, Server Administration, Platform-Specific Issues
Hi Christian.
IIRC, onmode -BC 2 is your help.
See refer
Admin guide at
http://www-306.ibm.com/software/data/informix/pubs/library/ids_9.html
HTH.
--
Tsutomu Ogiwara from Tokyo Japan.
ICQ#:168106592
>From: c-eriks@algonet.se (Christian Eriksson)
>Reply-To: c-eriks@algonet.se (Christian Eriksson)
>To: informix-list@iiug.org
>Subject: 2GB chunk limit (Bigger chunks despite disabled mode in 9.40)
>Date: 20 Feb 2004 01:18:19 -0800
>
>Hi!
>
>How can this be possible? Look at the chunk sizes beeing bigger than
>2GB despite the "Expanded chunk capacity mode: disabled".
>
>IDS version: Informix Dynamic Server 9.40.FC1
>OS & Platform: Solaris 9 8/03 s9s_u4wos_08a SPARC
>
>Chunks
>address chunk/dbs offset size free bpages
> flags pa
>thname
>15b380028 1 1 1024 102400 100438
> PO-- /l
>ocal/db/aishpr/aishpr_rootdbs
>15c411130 2 2 1024 2499584 2499531
> PO-B /l
>ocal/db/aishpr/aishpr_db01
>15c4112c8 3 3 1024 2499584 2499531
> PO-B /l
>ocal/db/aishpr/aishpr_db02
>15c411460 4 4 1024 2499584 2499531
> PO-B /l
>ocal/db/aishpr/aishpr_db03
>15c4115f8 5 5 1024 2499584 2499531
> PO-B /l
>ocal/db/aishpr/aishpr_db04
>15c411790 6 6 1024 514000 13947
> PO-- /l
>ocal/db/aishpr/aishpr_plog
>15c411928 7 7 1024 1499136 1499083
> PO-B /l
>ocal/db/aishpr/aishpr_tmp01
>15c411ac0 8 8 1024 2048000 547947
> PO-B /l
>ocal/db/aishpr/logs/aishpr_llog
> 8 active, 2047 maximum
>
>Expanded chunk capacity mode: disabled
>
>Regards Christian Eriksson
_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail
sending to informix-list
But his question actually was that he's still in level 0 ("Expanded chunk
capacity mode: disabled"), but that onstat -d is showing large chunk sizes.
"Tsutomu Ogiwara" <tsutomu_ogiwara@hotmail.com> wrote in message
news:c175gp$fn1$1@terabinaries.xmission.com...
>
> Hi Christian.
>
> IIRC, onmode -BC 2 is your help.
>
> See refer
> Admin guide at
> http://www-306.ibm.com/software/data/informix/pubs/library/ids_9.html
>
> HTH.
>
> --
> Tsutomu Ogiwara from Tokyo Japan.
> ICQ#:168106592
>
>
> >From: c-eriks@algonet.se (Christian Eriksson)
> >Reply-To: c-eriks@algonet.se (Christian Eriksson)
> >To: informix-list@iiug.org
> >Subject: 2GB chunk limit (Bigger chunks despite disabled mode in 9.40)
> >Date: 20 Feb 2004 01:18:19 -0800
> >
> >Hi!
> >
> >How can this be possible? Look at the chunk sizes beeing bigger than
> >2GB despite the "Expanded chunk capacity mode: disabled".
> >
> >IDS version: Informix Dynamic Server 9.40.FC1
> >OS & Platform: Solaris 9 8/03 s9s_u4wos_08a SPARC
> >
> >Chunks
> >address chunk/dbs offset size free bpages
> > flags pa
> >thname
> >15b380028 1 1 1024 102400 100438
> > PO-- /l
> >ocal/db/aishpr/aishpr_rootdbs
> >15c411130 2 2 1024 2499584 2499531
> > PO-B /l
> >ocal/db/aishpr/aishpr_db01
> >15c4112c8 3 3 1024 2499584 2499531
> > PO-B /l
> >ocal/db/aishpr/aishpr_db02
> >15c411460 4 4 1024 2499584 2499531
> > PO-B /l
> >ocal/db/aishpr/aishpr_db03
> >15c4115f8 5 5 1024 2499584 2499531
> > PO-B /l
> >ocal/db/aishpr/aishpr_db04
> >15c411790 6 6 1024 514000 13947
> > PO-- /l
> >ocal/db/aishpr/aishpr_plog
> >15c411928 7 7 1024 1499136 1499083
> > PO-B /l
> >ocal/db/aishpr/aishpr_tmp01
> >15c411ac0 8 8 1024 2048000 547947
> > PO-B /l
> >ocal/db/aishpr/logs/aishpr_llog
> > 8 active, 2047 maximum
> >
> >Expanded chunk capacity mode: disabled
> >
> >Regards Christian Eriksson
>
> _________________________________________________________________
> STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
> http://join.msn.com/?page=features/junkmail
>
> sending to informix-list
Related threads
- Re: Re: Crash course for an Oracle DBA
- Re: IDS 7.30 do not start - NT
- Re: IDS 10 erratic run times
- Client SDK