Help! Bad/unwanted chunks in rootdbs
Posted in 1993
I hope someone can help me with the following problem - my reading of TFM seems to indicate that there is no solution: Our rootdbs has the following chunks: Chunk Offset Pages Used Status 1 1 263873 239295 PO- 2 0 524287 524287 PO- 3 1 589439 3 PO- Chunk 3 was assigned to rootdbs in error - we would like it to be used for a different, droppable, dbspace. Chunk has an offset of 0 - we think this is an error because 1. We get read() errors from time to time, and 2. It seems improbably full (especially since chunk 1 is not). What we would like to do, therefore, is somehow back up the data, drop the rootdbs and its chunks, allocate the chunks to 2 different dbspaces, and then restore the data. It seems clear that we cannot use tbunload/tbload for the backups, but even if we use dbunload, how on earth do we drop the rootdbs (or at least deallocate the second two chunks)? Any pointers would be most appreciated. Thanks in advance, Andrew Shaw AT&T Bell Labs andrew.shaw@att.com apache!shaw@att.com