Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003
    Location
    Hamburg, Germany
    Posts
    38

    Unanswered: Adding chunks question

    OK, stupid question time.... as I'm new at this and standing in for someone on vacation, I just don't want to trash the existing installation. We cannot wait for the regular guy to return and I need to add some more space to the installation.



    The output of my onstat -d looks like ....

    Informix Dynamic Server 2000 Version 9.21.HC3 -- On-Line -- Up 50 days 07:39:06 -- 184352 Kbytes

    Dbspaces
    address number flags fchunk nchunks flags owner name
    c9abe7e0 1 0x1 1 1 N informix rootdbs
    c9aeee30 2 0x2001 2 1 N T informix temp
    c9abea90 3 0x1 3 1 N informix log
    c9abebd8 4 0x1 4 2 N informix ccm
    c9abed20 5 0x2001 5 1 N T informix temp2
    c9abee68 6 0x2001 6 1 N T informix temp4
    ca2c3018 7 0x2001 7 1 N T informix temp5
    7 active, 2047 maximum

    Chunks
    address chk/dbs offset size free bpages flags pathname
    c9abe928 1 1 0 29096 23910 PO- /sde/informix_data62/ifx62_root.dbs
    c9afd630 2 2 0 58192 54425 PO- /sde/informix_data62/ifx62_temp.dbs
    c9afd798 3 3 0 36864 29131 PO- /sde/informix_data62/ifx62_log.dbs
    c9afd900 4 4 0 512000 57 PO- /sde/informix_data62/ifx62_ccm.dbs
    c9afda68 5 5 0 100000 96797 PO- /sde/informix_data62/ifx62_temp2.dbs
    c9afdbd0 6 6 0 60000 57125 PO- /sde/informix_data62/ifx62_temp4.dbs
    c9afdd38 7 7 0 60000 57581 PO- /sde/informix_data62/ifx62_temp5.dbs
    c9afdea0 9 4 0 500000 338622 PO- /sde/informix_data62/ifx62_ccm3.dbs
    8 active, 2047 maximum



    I want to add another chunk to the dbspace called ccm and extend it by approx 1GB. I also want to create another temp dbspace with 40K pages (approx same size as existing temp space called temp).
    All dbspaces files are cooked files.

    I want to check with you guys the syntax, so that I do not blow anything. :-) Thanks.

    The command for extending the ccm space (adding another chunk) would be:

    onspaces -a -p /sde/informix_data62/ifx62_ccm4.dbs -o 0 -s 1000000

    The command for adding another temp dbspace:

    onspaces -c -d temp6 -t -p /sde/informix_data62/ifx62_temp6.dbs -o 0 -s 81920


    (I know I have to edit the onconfig to add the reference for the extra temp dbspace and restart the engine after it is added).

    Are those commands correct? If not, can you correct me? Do I need to 'touch' the files (/sde/informix_data62/ifx62_ccm4.dbs and /sde/informix_data62/ifx62_ccm4.dbs) , to create them with 0 size before issuing the onspaces commands?



    Thanks for your help.
    Adi.

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780

    Re: Adding chunks question

    Originally posted by AdiHH
    OK, stupid question time.... as I'm new at this and standing in for someone on vacation, I just don't want to trash the existing installation. We cannot wait for the regular guy to return and I need to add some more space to the installation.



    The output of my onstat -d looks like ....

    Informix Dynamic Server 2000 Version 9.21.HC3 -- On-Line -- Up 50 days 07:39:06 -- 184352 Kbytes

    Dbspaces
    address number flags fchunk nchunks flags owner name
    c9abe7e0 1 0x1 1 1 N informix rootdbs
    c9aeee30 2 0x2001 2 1 N T informix temp
    c9abea90 3 0x1 3 1 N informix log
    c9abebd8 4 0x1 4 2 N informix ccm
    c9abed20 5 0x2001 5 1 N T informix temp2
    c9abee68 6 0x2001 6 1 N T informix temp4
    ca2c3018 7 0x2001 7 1 N T informix temp5
    7 active, 2047 maximum

    Chunks
    address chk/dbs offset size free bpages flags pathname
    c9abe928 1 1 0 29096 23910 PO- /sde/informix_data62/ifx62_root.dbs
    c9afd630 2 2 0 58192 54425 PO- /sde/informix_data62/ifx62_temp.dbs
    c9afd798 3 3 0 36864 29131 PO- /sde/informix_data62/ifx62_log.dbs
    c9afd900 4 4 0 512000 57 PO- /sde/informix_data62/ifx62_ccm.dbs
    c9afda68 5 5 0 100000 96797 PO- /sde/informix_data62/ifx62_temp2.dbs
    c9afdbd0 6 6 0 60000 57125 PO- /sde/informix_data62/ifx62_temp4.dbs
    c9afdd38 7 7 0 60000 57581 PO- /sde/informix_data62/ifx62_temp5.dbs
    c9afdea0 9 4 0 500000 338622 PO- /sde/informix_data62/ifx62_ccm3.dbs
    8 active, 2047 maximum



    I want to add another chunk to the dbspace called ccm and extend it by approx 1GB. I also want to create another temp dbspace with 40K pages (approx same size as existing temp space called temp).
    All dbspaces files are cooked files.

    I want to check with you guys the syntax, so that I do not blow anything. :-) Thanks.

    The command for extending the ccm space (adding another chunk) would be:

    onspaces -a -p /sde/informix_data62/ifx62_ccm4.dbs -o 0 -s 1000000

    The command for adding another temp dbspace:

    onspaces -c -d temp6 -t -p /sde/informix_data62/ifx62_temp6.dbs -o 0 -s 81920


    (I know I have to edit the onconfig to add the reference for the extra temp dbspace and restart the engine after it is added).

    Are those commands correct? If not, can you correct me? Do I need to 'touch' the files (/sde/informix_data62/ifx62_ccm4.dbs and /sde/informix_data62/ifx62_ccm4.dbs) , to create them with 0 size before issuing the onspaces commands?



    Thanks for your help.
    Adi.
    Hello Adi,

    Yes, the commands is correct, you remember what the chunks must exist with owner and group informix and permission 660, before the commands ejecution.
    It excuses by my english, I prefer español.

    Gustavo.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •