Unix Technical Forum

creating large chunks/dbspaces

This is a discussion on creating large chunks/dbspaces within the Informix forums, part of the Database Server Software category; --> I just installed 9.4FC3 on HP/UX 11 and want to use large chunks (3-5GB). I have the symbolic links ...


Go Back   Unix Technical Forum > Database Server Software > Informix

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-19-2008, 10:17 PM
Kennedy, Randy
 
Posts: n/a
Default creating large chunks/dbspaces


I just installed 9.4FC3 on HP/UX 11 and want to use large chunks (3-5GB). I
have the symbolic links setup of the correct size and am now trying to
create the dbspace/chunk. Both onmonitor and onspaces tell me my chunk size
is too big. I have run 'onmode -BC1 & 2. How am I supposed to create them?
I have found nothing in the manual that specifically states how to do it.

I am trying this command: 'onspaces -c -d dbspacename -p /path/of/link -o 0
-s 3072000'

Thanks,
Randy
sending to informix-list
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-19-2008, 10:17 PM
Neil Truby
 
Posts: n/a
Default Re: creating large chunks/dbspaces

"Kennedy, Randy" <RKennedy@scottsdaleaz.gov> wrote in message
news:c74et4$94a$1@terabinaries.xmission.com...
>
> I just installed 9.4FC3 on HP/UX 11 and want to use large chunks (3-5GB).

I
> have the symbolic links setup of the correct size and am now trying to
> create the dbspace/chunk. Both onmonitor and onspaces tell me my chunk

size
> is too big. I have run 'onmode -BC1 & 2. How am I supposed to create

them?
> I have found nothing in the manual that specifically states how to do it.
>
> I am trying this command: 'onspaces -c -d dbspacename -p /path/of/link -o

0
> -s 3072000'


Works fine for me. See below.
Couple of obvious things:

1. Are you sure the onmode -BC has gone through OK?
2. Could /path/of/link be a link to a file system which has not got
"largefiles" enabled?

Please post the output from onstat -d and the exect error message you get
from onspaces.
================================================== =========================
informix@hamvpar2[/home/system/informix]onstat -d

IBM Informix Dynamic Server Version 9.40.FC3W2 -- On-Line -- Up 1 days
18:54:57 -- 153388 Kbytes

Dbspaces
address number flags fchunk nchunks flags owner
name
c000000020a60e60 1 0x60001 1 1 N B informix
rootdbs
c000000020bf5de8 2 0x40001 2 1 N B informix
physdbs
c000000020a61218 3 0x40001 3 1 N B informix
llogdbs
c000000020a61398 4 0x42001 4 1 N TB informix
tempdbs
c000000020a61518 5 0x40001 5 1 N B informix
dbs0
5 active, 2047 maximum

Chunks
address chunk/dbs offset size free bpages
flags pathname
c000000020a61028 1 1 0 26624 23922 PO-B
/opt/informix/dbspaces6/rootdbs
c000000020c099f8 2 2 0 51200 0 PO-B
/opt/informix/dbspaces6/physdbs
c000000020c09b90 3 3 0 51200 0 PO-B
/opt/informix/dbspaces6/llogdbs
c000000020c09d28 4 4 0 26624 26571 PO-B
/opt/informix/dbspaces6/tempdbs
c000000020bf5c50 5 5 0 806912 217241 PO-B
/opt/informix/dbspaces6/dbs0_1
5 active, 32766 maximum

Expanded chunk capacity mode: always

informix@hamvpar2[/home/system/informix]onspaces -c -d neil -p /tmp/neil -o
0 -s 3072000
Verifying physical disk space, please wait ...
Space successfully added.

** WARNING ** A level 0 archive of Root DBSpace will need to be done.
informix@hamvpar2[/home/system/informix]onstat -d

IBM Informix Dynamic Server Version 9.40.FC3W2 -- On-Line -- Up 1 days
18:55:04 -- 153388 Kbytes

Dbspaces
address number flags fchunk nchunks flags owner
name
c000000020a60e60 1 0x60001 1 1 N B informix
rootdbs
c000000020bf5de8 2 0x40001 2 1 N B informix
physdbs
c000000020a61218 3 0x40001 3 1 N B informix
llogdbs
c000000020a61398 4 0x42001 4 1 N TB informix
tempdbs
c000000020a61518 5 0x40001 5 1 N B informix
dbs0
c000000021902a80 6 0x60001 6 1 N B informix
neil
6 active, 2047 maximum

Chunks
address chunk/dbs offset size free bpages
flags pathname
c000000020a61028 1 1 0 26624 23922 PO-B
/opt/informix/dbspaces6/rootdbs
c000000020c099f8 2 2 0 51200 0 PO-B
/opt/informix/dbspaces6/physdbs
c000000020c09b90 3 3 0 51200 0 PO-B
/opt/informix/dbspaces6/llogdbs
c000000020c09d28 4 4 0 26624 26571 PO-B
/opt/informix/dbspaces6/tempdbs
c000000020bf5c50 5 5 0 806912 217241 PO-B
/opt/informix/dbspaces6/dbs0_1
c000000021902c00 6 6 0 1536000 1535947 PO-B
/tmp/neil
6 active, 32766 maximum

Expanded chunk capacity mode: always


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 08:37 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com