can't drop an empty dbspace -- help please.
A DBA couldn't drop a seemingly empty dbspace (prod2dbs) with two chunks; oncheck output showed TBLSPACE TBLSPACE extents in both chunks, including one in the second chunk. Dropping the last chunk first was suggested but failed. Respondents explained the cause: the tblspace tblspace had grown over time (many tables/detached indexes) and, needing contiguous space, extended into the second chunk, which blocks dropping the chunk/dbspace. The advice was that only IBM advanced support could remove it; no resolution from IBM is recorded in the thread.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi gurus, We have a dbspace (prod2dbs) that is basically empty meaning no user table in it. It has 2 chunks (/product/prd_data_2 and /product/prd_data_8) but we just can't drop it. Perhaps the problem seems to involve with the tblspace tblspace, does anyone have any idea why this happens and how to resolve this? I just want to drop this dbspace out of the system. Thanks in advance. Kern -- DBspace Usage Report: prod2dbs Owner: informix Created: 05/22/2000 Chunk: 6 /product/prd_data_2 Size Used Free 1048559 219 1048340 Disk usage for Chunk 6 Start Length ------------------------------------------- --------- --------- OTHER RESERVED Pages 0 2 CHUNK FREE LIST PAGE 2 1 TBLSPACE TBLSPACE 3 50 FREE 53 95800 FREE 95861 150 FREE 96019 1670 TBLSPACE TBLSPACE 97689 50 FREE 97739 5379 TBLSPACE TBLSPACE 103118 50 FREE 103168 566042 TBLSPACE TBLSPACE 669210 50 FREE 669260 379299 Chunk: 7 /product/prd_data_8 Size Used Free 1048559 53 1048506 Disk usage for Chunk 7 Start Length ------------------------------------------- --------- --------- OTHER RESERVED Pages 0 2 CHUNK FREE LIST PAGE 2 1 FREE 3 761023 TBLSPACE TBLSPACE 761026 50 FREE 761076 287483 ________________________________________________________________________________ ____ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
Can you drop the last chunk first and then try dropping the dbspace with the one remaining chunk? Thanks, ************************************** Ernie Knox Sears Holding Co. IT Database Administrator Specialist IT Service Management, Strategy & Architecture 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Fax: (847) 645-3874 Pager: (800) 759-8352 Pin#: 7271042 Email: eknox@sears.com " It's always a great day to watch Football ! " ************************************** -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Kern Doe Sent: Thursday, April 24, 2008 3:24 PM To: ids@iiug.org Subject: can't drop an empty dbspace -- help please. [11900] Hi gurus, We have a dbspace (prod2dbs) that is basically empty meaning no user table in it. It has 2 chunks (/product/prd_data_2 and /product/prd_data_8) but we just can't drop it. Perhaps the problem seems to involve with the tblspace tblspace, does anyone have any idea why this happens and how to resolve this? I just want to drop this dbspace out of the system. Thanks in advance. Kern -- DBspace Usage Report: prod2dbs Owner: informix Created: 05/22/2000 Chunk: 6 /product/prd_data_2 Size Used Free 1048559 219 1048340 Disk usage for Chunk 6 Start Length ------------------------------------------- --------- --------- OTHER RESERVED Pages 0 2 CHUNK FREE LIST PAGE 2 1 TBLSPACE TBLSPACE 3 50 FREE 53 95800 FREE 95861 150 FREE 96019 1670 TBLSPACE TBLSPACE 97689 50 FREE 97739 5379 TBLSPACE TBLSPACE 103118 50 FREE 103168 566042 TBLSPACE TBLSPACE 669210 50 FREE 669260 379299 Chunk: 7 /product/prd_data_8 Size Used Free 1048559 53 1048506 Disk usage for Chunk 7 Start Length ------------------------------------------- --------- --------- OTHER RESERVED Pages 0 2 CHUNK FREE LIST PAGE 2 1 FREE 3 761023 TBLSPACE TBLSPACE 761026 50 FREE 761076 287483 ________________________________________________________________________________ ____ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!!
Hi Kern, Yeah you will have to call IBM support, this dbspace has to be dropped by advanced support. And you are right, it's the tblspace tblspace entry in chunk 7 that is the poblem. ----- Original Message ---- From: Kern Doe <kern_doe@yahoo.com> To: ids@iiug.org Sent: Thursday, April 24, 2008 3:24:05 PM Subject: can't drop an empty dbspace -- help please. [11900] Hi gurus, We have a dbspace (prod2dbs) that is basically empty meaning no user table in it. It has 2 chunks (/product/prd_data_2 and /product/prd_data_8) but we just can't drop it. Perhaps the problem seems to involve with the tblspace tblspace, does anyone have any idea why this happens and how to resolve this? I just want to drop this dbspace out of the system. Thanks in advance. Kern -- DBspace Usage Report: prod2dbs Owner: informix Created: 05/22/2000 Chunk: 6 /product/prd_data_2 Size Used Free 1048559 219 1048340 Disk usage for Chunk 6 Start Length ------------------------------------------- --------- --------- OTHER RESERVED Pages 0 2 CHUNK FREE LIST PAGE 2 1 TBLSPACE TBLSPACE 3 50 FREE 53 95800 FREE 95861 150 FREE 96019 1670 TBLSPACE TBLSPACE 97689 50 FREE 97739 5379 TBLSPACE TBLSPACE 103118 50 FREE 103168 566042 TBLSPACE TBLSPACE 669210 50 FREE 669260 379299 Chunk: 7 /product/prd_data_8 Size Used Free 1048559 53 1048506 Disk usage for Chunk 7 Start Length ------------------------------------------- --------- --------- OTHER RESERVED Pages 0 2 CHUNK FREE LIST PAGE 2 1 FREE 3 761023 TBLSPACE TBLSPACE 761026 50 FREE 761076 287483 ________________________________________________________________________________ ____ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!!
Ernest, I in fact did tried that and it did not work. Like Mark jamison said in his reply, yes, we probably have to call IBM -- but still I'm curious to know how that's happenned. ----- Original Message ---- From: "Knox, Ernest" <eknox@searshc.com> To: ids@iiug.org Sent: Thursday, April 24, 2008 9:46:56 PM Subject: RE: can't drop an empty dbspace -- help please. [11901] Can you drop the last chunk first and then try dropping the dbspace with the one remaining chunk? Thanks, ************************************** Ernie Knox Sears Holding Co. IT Database Administrator Specialist IT Service Management, Strategy & Architecture 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Fax: (847) 645-3874 Pager: (800) 759-8352 Pin#: 7271042 Email: eknox@sears.com " It's always a great day to watch Football ! " ************************************** -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Kern Doe Sent: Thursday, April 24, 2008 3:24 PM To: ids@iiug.org Subject: can't drop an empty dbspace -- help please. [11900] Hi gurus, We have a dbspace (prod2dbs) that is basically empty meaning no user table in it. It has 2 chunks (/product/prd_data_2 and /product/prd_data_8) but we just can't drop it. Perhaps the problem seems to involve with the tblspace tblspace, does anyone have any idea why this happens and how to resolve this? I just want to drop this dbspace out of the system. Thanks in advance. Kern -- DBspace Usage Report: prod2dbs Owner: informix Created: 05/22/2000 Chunk: 6 /product/prd_data_2 Size Used Free 1048559 219 1048340 Disk usage for Chunk 6 Start Length ------------------------------------------- --------- --------- OTHER RESERVED Pages 0 2 CHUNK FREE LIST PAGE 2 1 TBLSPACE TBLSPACE 3 50 FREE 53 95800 FREE 95861 150 FREE 96019 1670 TBLSPACE TBLSPACE 97689 50 FREE 97739 5379 TBLSPACE TBLSPACE 103118 50 FREE 103168 566042 TBLSPACE TBLSPACE 669210 50 FREE 669260 379299 Chunk: 7 /product/prd_data_8 Size Used Free 1048559 53 1048506 Disk usage for Chunk 7 Start Length ------------------------------------------- --------- --------- OTHER RESERVED Pages 0 2 CHUNK FREE LIST PAGE 2 1 FREE 3 761023 TBLSPACE TBLSPACE 761026 50 FREE 761076 287483 ________________________________________________________________________________ ____ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!! ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!! ________________________________________________________________________________ ____ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
Please send back your IBM results when fixed. Thanks, ************************************** Ernie Knox Sears Holding Co. IT Database Administrator Specialist IT Service Management, Strategy & Architecture 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Fax: (847) 645-3874 Pager: (800) 759-8352 Pin#: 7271042 Email: eknox@sears.com " It's always a great day to watch Football ! " ************************************** -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Kern Doe Sent: Friday, April 25, 2008 9:21 AM To: ids@iiug.org Subject: Re: can't drop an empty dbspace -- help please. [11903] Ernest, I in fact did tried that and it did not work. Like Mark jamison said in his reply, yes, we probably have to call IBM -- but still I'm curious to know how that's happenned. ----- Original Message ---- From: "Knox, Ernest" <eknox@searshc.com> To: ids@iiug.org Sent: Thursday, April 24, 2008 9:46:56 PM Subject: RE: can't drop an empty dbspace -- help please. [11901] Can you drop the last chunk first and then try dropping the dbspace with the one remaining chunk? Thanks, ************************************** Ernie Knox Sears Holding Co. IT Database Administrator Specialist IT Service Management, Strategy & Architecture 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Fax: (847) 645-3874 Pager: (800) 759-8352 Pin#: 7271042 Email: eknox@sears.com " It's always a great day to watch Football ! " ************************************** -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Kern Doe Sent: Thursday, April 24, 2008 3:24 PM To: ids@iiug.org Subject: can't drop an empty dbspace -- help please. [11900] Hi gurus, We have a dbspace (prod2dbs) that is basically empty meaning no user table in it. It has 2 chunks (/product/prd_data_2 and /product/prd_data_8) but we just can't drop it. Perhaps the problem seems to involve with the tblspace tblspace, does anyone have any idea why this happens and how to resolve this? I just want to drop this dbspace out of the system. Thanks in advance. Kern -- DBspace Usage Report: prod2dbs Owner: informix Created: 05/22/2000 Chunk: 6 /product/prd_data_2 Size Used Free 1048559 219 1048340 Disk usage for Chunk 6 Start Length ------------------------------------------- --------- --------- OTHER RESERVED Pages 0 2 CHUNK FREE LIST PAGE 2 1 TBLSPACE TBLSPACE 3 50 FREE 53 95800 FREE 95861 150 FREE 96019 1670 TBLSPACE TBLSPACE 97689 50 FREE 97739 5379 TBLSPACE TBLSPACE 103118 50 FREE 103168 566042 TBLSPACE TBLSPACE 669210 50 FREE 669260 379299 Chunk: 7 /product/prd_data_8 Size Used Free 1048559 53 1048506 Disk usage for Chunk 7 Start Length ------------------------------------------- --------- --------- OTHER RESERVED Pages 0 2 CHUNK FREE LIST PAGE 2 1 FREE 3 761023 TBLSPACE TBLSPACE 761026 50 FREE 761076 287483 ________________________________________________________________________________ ____ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!! ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!! ________________________________________________________________________________ ____ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!!
Hi Kern, The typical reason is that you had a lot of tables and detached indexes in that dbspace at one time. As those objects grows, each one requires a single page in the tblspace tblspace , when the tblspace tblspace has to grow it take the coniguous space that it needs, which means if you fill up Chunk 6 at any time, that the tblspace tblspace will grab that space elsewhere in the dbspace, in this case Chunk 7. Hope That Helps. ----- Original Message ---- From: Kern Doe <kern_doe@yahoo.com> To: ids@iiug.org Sent: Friday, April 25, 2008 9:20:40 AM Subject: Re: can't drop an empty dbspace -- help please. [11903] Ernest, I in fact did tried that and it did not work. Like Mark jamison said in his reply, yes, we probably have to call IBM -- but still I'm curious to know how that's happenned. ----- Original Message ---- From: "Knox, Ernest" <eknox@searshc.com> To: ids@iiug.org Sent: Thursday, April 24, 2008 9:46:56 PM Subject: RE: can't drop an empty dbspace -- help please. [11901] Can you drop the last chunk first and then try dropping the dbspace with the one remaining chunk? Thanks, ************************************** Ernie Knox Sears Holding Co. IT Database Administrator Specialist IT Service Management, Strategy & Architecture 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Fax: (847) 645-3874 Pager: (800) 759-8352 Pin#: 7271042 Email: eknox@sears.com " It's always a great day to watch Football ! " ************************************** -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Kern Doe Sent: Thursday, April 24, 2008 3:24 PM To: ids@iiug.org Subject: can't drop an empty dbspace -- help please. [11900] Hi gurus, We have a dbspace (prod2dbs) that is basically empty meaning no user table in it. It has 2 chunks (/product/prd_data_2 and /product/prd_data_8) but we just can't drop it. Perhaps the problem seems to involve with the tblspace tblspace, does anyone have any idea why this happens and how to resolve this? I just want to drop this dbspace out of the system. Thanks in advance. Kern -- DBspace Usage Report: prod2dbs Owner: informix Created: 05/22/2000 Chunk: 6 /product/prd_data_2 Size Used Free 1048559 219 1048340 Disk usage for Chunk 6 Start Length ------------------------------------------- --------- --------- OTHER RESERVED Pages 0 2 CHUNK FREE LIST PAGE 2 1 TBLSPACE TBLSPACE 3 50 FREE 53 95800 FREE 95861 150 FREE 96019 1670 TBLSPACE TBLSPACE 97689 50 FREE 97739 5379 TBLSPACE TBLSPACE 103118 50 FREE 103168 566042 TBLSPACE TBLSPACE 669210 50 FREE 669260 379299 Chunk: 7 /product/prd_data_8 Size Used Free 1048559 53 1048506 Disk usage for Chunk 7 Start Length ------------------------------------------- --------- --------- OTHER RESERVED Pages 0 2 CHUNK FREE LIST PAGE 2 1 FREE 3 761023 TBLSPACE TBLSPACE 761026 50 FREE 761076 287483 ________________________________________________________________________________ ____ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!! ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!! ________________________________________________________________________________ ____ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!!