Converting existing second dbspace as chunk

Posted in 2015

Topics: Storage & Space Management, Server Administration, Versions, Editions & End-of-Life

S M MAHESH — Fri, 27 Feb 2015 03:15:27 — source: IIUG Forums & Mailing Lists

Hi, I have a box that has two sbspaces created (main_sbspace and subsys_sbspace). The main_sbspace is configured as SBSPACENAME in onconfig file. Because of space and other constraints, I cannot allocate more disk space. Can I convert/re-purpose the existing subsys_space as additional chunk to the main_sbspace? If so, can I do it without losing data in the subsys_sbspace? The 'onspaces' utility does not seem to offer such an option. Current onstat output: IBM Informix Dynamic Server Version 11.70.UC7XA -- On-Line -- Up 1 days 22:31:31 -- 257508 Kbytes Dbspaces address number flags fchunk nchunks pgsize flags owner name 49da2818 1 0x60001 1 1 2048 N BA informix rootdbs :: 4bd99188 11 0x68001 12 1 2048 N SBA informix main_sbspace 4bd99748 15 0x68001 16 1 2048 N SBA informix subsys_sbspace Chunks address chunk/dbs offset size free bpages flags pathname 49da2988 1 1 0 50000 34493 PO-B-D /usr/local/db/informix/data/root.dbs :: 4bd9b018 12 11 0 153600 143186 143186 POSB-D /var/local/db/informix/main_sbspace_dbs Metadata 10361 7709 10361 4bd9b7b8 16 15 0 51200 41495 47678 POSB-D /var/local/db/informix/subsys_sbspace_dbs Metadata 3469 2581 3469 ============ Expected onstat output after the reconfig IBM Informix Dynamic Server Version 11.70.UC7XA -- On-Line -- Up 1 days 22:31:31 -- 257508 Kbytes Dbspaces address number flags fchunk nchunks pgsize flags owner name 49da2818 1 0x60001 1 1 2048 N BA informix rootdbs :: 4bd99188 11 0x68001 12 1 2048 N SBA informix main_sbspace 4bd99748 15 0x68001 16 1 2048 N SBA informix subsys_sbspace Chunks address chunk/dbs offset size free bpages flags pathname 49da2988 1 1 0 50000 34493 PO-B-D /usr/local/db/informix/data/root.dbs :: 4bd9b018 12 11 0 153600 143186 143186 POSB-D /var/local/db/informix/main_sbspace_dbs Metadata 10361 7709 10361 4bd9b7b8 16 11 100 51200 41495 47678 POSB-D /var/local/db/informix/subsys_sbspace_dbs Metadata 3469 2581 3469 Regards, Mahesh

↪ replying to S M MAHESH

Keith Simmons — Fri, 27 Feb 2015 09:16:38 — source: IIUG Forums & Mailing Lists

Mahesh Basically, yes, but only by losing all existing data in that space. In order to add the space to main_sbspace you would need to drop the chunk and subsys_sbspace and then add the chunk to main_sbspace which would remove all internal structures and 'erase' all the data in the added chunk. In order to retain the data (and depending on the data type and use) you would need to unload to the O/S and then reload after the chunk has been added. Keith On 27 February 2015 at 03:15, S M MAHESH <smahesh@cisco.com> wrote: > Hi, > > I have a box that has two sbspaces created (main_sbspace and > subsys_sbspace). > The main_sbspace is configured as SBSPACENAME in onconfig file. Because of > space and other constraints, I cannot allocate more disk space. > > Can I convert/re-purpose the existing subsys_space as additional chunk to > the > main_sbspace? If so, can I do it without losing data in the subsys_sbspace? > > The 'onspaces' utility does not seem to offer such an option. > > Current onstat output: > IBM Informix Dynamic Server Version 11.70.UC7XA -- On-Line -- Up 1 days > 22:31:31 -- 257508 Kbytes> > Dbspaces > address number flags fchunk nchunks pgsize flags owner name > 49da2818 1 0x60001 1 1 2048 N BA informix rootdbs > :: > 4bd99188 11 0x68001 12 1 2048 N SBA informix main_sbspace > 4bd99748 15 0x68001 16 1 2048 N SBA informix subsys_sbspace > > Chunks > address chunk/dbs offset size free bpages flags pathname > 49da2988 1 1 0 50000 34493 PO-B-D /usr/local/db/informix/data/root.dbs > :: > 4bd9b018 12 11 0 153600 143186 143186 POSB-D > /var/local/db/informix/main_sbspace_dbs > > Metadata 10361 7709 10361 > 4bd9b7b8 16 15 0 51200 41495 47678 POSB-D > /var/local/db/informix/subsys_sbspace_dbs > > Metadata 3469 2581 3469 > > ============ > > Expected onstat output after the reconfig > > IBM Informix Dynamic Server Version 11.70.UC7XA -- On-Line -- Up 1 days > 22:31:31 -- 257508 Kbytes> > Dbspaces > address number flags fchunk nchunks pgsize flags owner name > 49da2818 1 0x60001 1 1 2048 N BA informix rootdbs > :: > 4bd99188 11 0x68001 12 1 2048 N SBA informix main_sbspace > 4bd99748 15 0x68001 16 1 2048 N SBA informix subsys_sbspace > > Chunks > address chunk/dbs offset size free bpages flags pathname > 49da2988 1 1 0 50000 34493 PO-B-D /usr/local/db/informix/data/root.dbs > :: > 4bd9b018 12 11 0 153600 143186 143186 POSB-D > /var/local/db/informix/main_sbspace_dbs > > Metadata 10361 7709 10361 > 4bd9b7b8 16 11 100 51200 41495 47678 POSB-D > /var/local/db/informix/subsys_sbspace_dbs > > Metadata 3469 2581 3469 > > Regards, > Mahesh > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --bcaec51717cfbfee6a05100e5260

↪ replying to S M MAHESH

Art Kagel — Fri, 27 Feb 2015 11:24:01 — source: IIUG Forums & Mailing Lists

No, you cannot do what you want to do. You can use the PUT clause to manually place new smart blob objects into the subsys_sbspace, but there is no way to merge the spaces. You unload the objects stored in subsys_sbspace then empty the contents of that sbspace drop it and readd the chunk to the main_sbspace and then reinsert the objects. Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. 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 Thu, Feb 26, 2015 at 10:15 PM, S M MAHESH <smahesh@cisco.com> wrote: > Hi, > > I have a box that has two sbspaces created (main_sbspace and > subsys_sbspace). > The main_sbspace is configured as SBSPACENAME in onconfig file. Because of > space and other constraints, I cannot allocate more disk space. > > Can I convert/re-purpose the existing subsys_space as additional chunk to > the > main_sbspace? If so, can I do it without losing data in the subsys_sbspace? > > The 'onspaces' utility does not seem to offer such an option. > > Current onstat output: > IBM Informix Dynamic Server Version 11.70.UC7XA -- On-Line -- Up 1 days > 22:31:31 -- 257508 Kbytes> > Dbspaces > address number flags fchunk nchunks pgsize flags owner name > 49da2818 1 0x60001 1 1 2048 N BA informix rootdbs > :: > 4bd99188 11 0x68001 12 1 2048 N SBA informix main_sbspace > 4bd99748 15 0x68001 16 1 2048 N SBA informix subsys_sbspace > > Chunks > address chunk/dbs offset size free bpages flags pathname > 49da2988 1 1 0 50000 34493 PO-B-D /usr/local/db/informix/data/root.dbs > :: > 4bd9b018 12 11 0 153600 143186 143186 POSB-D > /var/local/db/informix/main_sbspace_dbs > > Metadata 10361 7709 10361 > 4bd9b7b8 16 15 0 51200 41495 47678 POSB-D > /var/local/db/informix/subsys_sbspace_dbs > > Metadata 3469 2581 3469 > > ============ > > Expected onstat output after the reconfig > > IBM Informix Dynamic Server Version 11.70.UC7XA -- On-Line -- Up 1 days > 22:31:31 -- 257508 Kbytes> > Dbspaces > address number flags fchunk nchunks pgsize flags owner name > 49da2818 1 0x60001 1 1 2048 N BA informix rootdbs > :: > 4bd99188 11 0x68001 12 1 2048 N SBA informix main_sbspace > 4bd99748 15 0x68001 16 1 2048 N SBA informix subsys_sbspace > > Chunks > address chunk/dbs offset size free bpages flags pathname > 49da2988 1 1 0 50000 34493 PO-B-D /usr/local/db/informix/data/root.dbs > :: > 4bd9b018 12 11 0 153600 143186 143186 POSB-D > /var/local/db/informix/main_sbspace_dbs > > Metadata 10361 7709 10361 > 4bd9b7b8 16 11 100 51200 41495 47678 POSB-D > /var/local/db/informix/subsys_sbspace_dbs > > Metadata 3469 2581 3469 > > Regards, > Mahesh > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a113ed15843ecb40510101a92

↪ replying to S M MAHESH

Lloyd S — Mon, 02 Mar 2015 16:40:58 — source: IIUG Forums & Mailing Lists

Is subsys empty? Try to drop this and add it as a chunk to main sbspace? Use onspaces. From: "S M MAHESH"smahesh@cisco.com Sent:Fri, 27 Feb 2015 08:46:29 +0530 To: ids@iiug.org Subject: Converting existing second dbspace as chunk [34725] Hi, > > I have a box that has two sbspaces created (main_sbspace and subsys_sbspace). > The main_sbspace is configured as SBSPACENAME in onconfig file. Because of > space and other constraints, I cannot allocate more disk space. > > Can I convert/re-purpose the existing subsys_space as additional chunk to the > main_sbspace? If so, can I do it without losing data in the subsys_sbspace? > > The 'onspaces' utility does not seem to offer such an option. > > Current onstat output: > IBM Informix Dynamic Server Version 11.70.UC7XA -- On-Line -- Up 1 days > 22:31:31 -- 257508 Kbytes> > Dbspaces > address number flags fchunk nchunks pgsize flags owner name > 49da2818 1 0x60001 1 1 2048 N BA informix rootdbs > :: > 4bd99188 11 0x68001 12 1 2048 N SBA informix main_sbspace > 4bd99748 15 0x68001 16 1 2048 N SBA informix subsys_sbspace > > Chunks > address chunk/dbs offset size free bpages flags pathname > 49da2988 1 1 0 50000 34493 PO-B-D /usr/local/db/informix/data/root.dbs > :: > 4bd9b018 12 11 0 153600 143186 143186 POSB-D > /var/local/db/informix/main_sbspace_dbs > > Metadata 10361 7709 10361 > 4bd9b7b8 16 15 0 51200 41495 47678 POSB-D > /var/local/db/informix/subsys_sbspace_dbs > > Metadata 3469 2581 3469 > > ============ > > Expected onstat output after the reconfig > > IBM Informix Dynamic Server Version 11.70.UC7XA -- On-Line -- Up 1 days > 22:31:31 -- 257508 Kbytes> > Dbspaces > address number flags fchunk nchunks pgsize flags owner name > 49da2818 1 0x60001 1 1 2048 N BA informix rootdbs > :: > 4bd99188 11 0x68001 12 1 2048 N SBA informix main_sbspace > 4bd99748 15 0x68001 16 1 2048 N SBA informix subsys_sbspace > > Chunks > address chunk/dbs offset size free bpages flags pathname > 49da2988 1 1 0 50000 34493 PO-B-D /usr/local/db/informix/data/root.dbs > :: > 4bd9b018 12 11 0 153600 143186 143186 POSB-D > /var/local/db/informix/main_sbspace_dbs > > Metadata 10361 7709 10361 > 4bd9b7b8 16 11 100 51200 41495 47678 POSB-D > /var/local/db/informix/subsys_sbspace_dbs > > Metadata 3469 2581 3469 > > Regards, > Mahesh > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >

Converting existing second dbspace as chunk

Glossary

Your privacy choices