Oninit cdi / Archive
Talk to an expert →

free space of a chunk is showing negative

Posted in 2007

Topics: Storage & Space Management

JAYANTA SARKAR — — source: IIUG Forums & Mailing Lists

Hi, I am using IDS10.0 on AIX, Recently one of the dbspace got corrupted so we created new chunk,dbspace and restored the dbspace containing the chunk(no 4). Restoration was successful and chunk got online. We later removed data table from that dbspace. Now it is showing free space more than allocated space. It is not allowing to drop the dbspace also. Tried on oncheck -pe, oncheck -cc, but not useful. oncheck -d datadbs03 is showing error dbspace is not empty, but actually thereis nothing in that dbspace. IBM Informix Dynamic Server Version 10.00.FC5I1 -- On-Line -- Up 00:33:38 --1071904 Kbytes Dbspaces address number flags fchunk nchunks pgsize flags owner name 7000000201afe78 1 0x40002 1 1 4096 M B informix rootdbs 700000020e2d368 2 0x40001 2 1 4096 N B informix datadbs01 700000020e2d500 3 0x40001 3 1 4096 N B informix datadbs02 700000020e2d698 4 0x40001 4 1 4096 N B informix datadbs03 700000020e2d830 5 0x40001 5 1 4096 N B informix tempdbs01 700000020e2d9c8 6 0x40001 6 1 4096 N B informix tempdbs02 700000020e2db60 7 0x40001 7 1 4096 N B informix llogdbs01 700000020e2dcf8 8 0x40001 8 1 4096 N B informix plogdbs01 700000020e2de90 9 0x40001 9 1 4096 N B informix datadbs 9 active, 2047 maximum Chunks address chunk/dbs offset size free bpages flags pathname 7000000201b0028 1 1 0 7500 4110 PO-B /ps7/informix/link/rootdbs 7000000201b01c8 1 1 0 7500 0 MO-B /ps7/informix/mlink/rootmir 7000000201b0568 2 2 0 512000 434747 PO-B /ps7/informix/link/data.chk1 7000000201b0708 3 3 0 512000 473147 PO-B /ps7/informix/link/data.chk2 7000000201b08a8 4 4 0 250000 511947 PO-B /ps7/informix/link/data.chk3 7000000201b0a48 5 5 0 256000 255897 PO-B /ps7/informix/link/temp.chk1 7000000201b0be8 6 6 0 256000 255947 PO-B /ps7/informix/link/temp.chk2 7000000201b0d88 7 7 0 512000 11947 PO-B /ps7/informix/link/llog.chk1 700000020e2d028 8 8 0 128000 115147 PO-B /ps7/informix/link/plog.chk1 700000020e2d1c8 9 9 0 1280 625 PO-B /ps7/informix/link/data.chk 9 active, 32766 maximum Note here the chunk no 4 & dbspace no 4. Please guide me to drop this dbspace.

↪ replying to JAYANTA SARKAR
ART KAGEL, — — source: IIUG Forums & Mailing Lists

Call tech support. They can remove the chunk/dbspace for you. Art S. Kagel ----- Original Message ----- From: Jayanta Sarkar <ids@iiug.org> At: 8/03 7:51:21 Hi, I am using IDS10.0 on AIX, Recently one of the dbspace got corrupted so we created new chunk,dbspace and restored the dbspace containing the chunk(no 4). Restoration was successful and chunk got online. We later removed data table from that dbspace. Now it is showing free space more than allocated space. It is not allowing to drop the dbspace also. Tried on oncheck -pe, oncheck -cc, but not useful. oncheck -d datadbs03 is showing error dbspace is not empty, but actually thereis nothing in that dbspace. IBM Informix Dynamic Server Version 10.00.FC5I1 -- On-Line -- Up 00:33:38 --1071904 Kbytes Dbspaces address number flags fchunk nchunks pgsize flags owner name 7000000201afe78 1 0x40002 1 1 4096 M B informix rootdbs 700000020e2d368 2 0x40001 2 1 4096 N B informix datadbs01 700000020e2d500 3 0x40001 3 1 4096 N B informix datadbs02 700000020e2d698 4 0x40001 4 1 4096 N B informix datadbs03 700000020e2d830 5 0x40001 5 1 4096 N B informix tempdbs01 700000020e2d9c8 6 0x40001 6 1 4096 N B informix tempdbs02 700000020e2db60 7 0x40001 7 1 4096 N B informix llogdbs01 700000020e2dcf8 8 0x40001 8 1 4096 N B informix plogdbs01 700000020e2de90 9 0x40001 9 1 4096 N B informix datadbs 9 active, 2047 maximum Chunks address chunk/dbs offset size free bpages flags pathname 7000000201b0028 1 1 0 7500 4110 PO-B /ps7/informix/link/rootdbs 7000000201b01c8 1 1 0 7500 0 MO-B /ps7/informix/mlink/rootmir 7000000201b0568 2 2 0 512000 434747 PO-B /ps7/informix/link/data.chk1 7000000201b0708 3 3 0 512000 473147 PO-B /ps7/informix/link/data.chk2 7000000201b08a8 4 4 0 250000 511947 PO-B /ps7/informix/link/data.chk3 7000000201b0a48 5 5 0 256000 255897 PO-B /ps7/informix/link/temp.chk1 7000000201b0be8 6 6 0 256000 255947 PO-B /ps7/informix/link/temp.chk2 7000000201b0d88 7 7 0 512000 11947 PO-B /ps7/informix/link/llog.chk1 700000020e2d028 8 8 0 128000 115147 PO-B /ps7/informix/link/plog.chk1 700000020e2d1c8 9 9 0 1280 625 PO-B /ps7/informix/link/data.chk 9 active, 32766 maximum Note here the chunk no 4 & dbspace no 4. Please guide me to drop this dbspace. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Glossary