Oninit cdi / Archive
Talk to an expert →

Dropping/Adding Chunk - Error

Posted in 2004

Topics: Storage & Space Management, Error Codes & Troubleshooting, Server Administration

ADRIAN BASELEY — — source: IIUG Forums & Mailing Lists

I'm trying to move a chunk from one dbspace to another, but when I go to drop the chunk, it give the error message: onspaces -d maxdbs -p /dev/online/chunk13 -o 0WARNING: Dropping a chunk. Do you really want to continue? (y/n)y Chunk not dropped. ISAM error: Chunk not empty The contents of the chunk is as follows: Chunk: 13 /dev/online/chunk13 Size Used Free 1024000 203 1023797 Disk usage for Chunk 13 Start Length ------------------------------------------- --------- --------- OTHER RESERVED Pages 0 2 CHUNK FREE LIST PAGE 2 1 FREE 3 813125 TBLSPACE TBLSPACE 813128 200 FREE 813328 210672 I'm assuming the TBLSPACE is causing the problem, but what can i do about it??? Thanks in advance. Ady

↪ replying to ADRIAN BASELEY
Tilman Model-Bosch — — source: IIUG Forums & Mailing Lists

Dear Adrian, The TBLSPACE TBLSPACE is an internal table used to track all tables in a dbspace. Unfortunately there are no means to control the location of extents of that tablespace. The only way to get rid of the chunk is to move all tables of the dbspace the chunk belongs to to a different dbspace, then drop the whole dbspace. Regards Tilman -- Tilman Model-Bosch IBM Data Managment Solutions, Informix Advanced Support c\\\\o SAP AG TECHDEV 05 Neurrotstr.16 69190 Walldorf "ADRIAN BASELEY" <adrian.baseley@huntleigh-heal To: ids@iiug.org thcare.com> cc: Sent by: Subject: Dropping/Adding Chunk - Error [2522] forum.subscriber@iiug.org 02/06/2004 09:09 AM I'm trying to move a chunk from one dbspace to another, but when I go to drop the chunk, it give the error message: onspaces -d maxdbs -p /dev/online/chunk13 -o 0WARNING: Dropping a chunk. Do you really want to continue? (y/n)y Chunk not dropped. ISAM error: Chunk not empty The contents of the chunk is as follows: Chunk: 13 /dev/online/chunk13 Size Used Free 1024000 203 1023797 Disk usage for Chunk 13 Start Length ------------------------------------------- --------- --------- OTHER RESERVED Pages 0 2 CHUNK FREE LIST PAGE 2 1 FREE 3 813125 TBLSPACE TBLSPACE 813128 200 FREE 813328 210672 I'm assuming the TBLSPACE is causing the problem, but what can i do about it??? Thanks in advance. Ady

Glossary