Question about offline chunk

I have a dbspace with a single chunk that is marked offline. I would like to either bring it online.... or get rid of it so I can re-use the space. When I try to drop the chunk... it says it is not there... but when I try to create it, it says it is already there. This chunk has been like this for a while, and I can't remember the sequence of events that caused it to go offline. I have checked offsets and sizes of other chunks on this storage space and everything appears to be okay. informix@psdb04spr:~> onspaces -c -d socket_in1 -k 0 -p /IDS/data/2_lun1 -o 50855936 -s 1048576 Space already exists. informix@psdb04spr:~> onspaces -d socket_in1 -p /IDS/data/2_lun1 -o 50855936 WARNING: Dropping a chunk. Do you really want to continue? (y/n)y Chunk not dropped. ISAM error: No such chunk informix@psdb04spr:~> onstat -d . . .77cd2688 28 0x60005 28 1 2048 ND B informix socket_in1 . . . 77d2fbc8 28 28 24903680 524288 0 PD-B- /IDS/data/2_lun1 Any hints? Thanks Laurie Laurie Gustin Database Administrator Dept of Technology Services Dept of Public Safety lgustin@utah.gov 801-965-4410

Call IBM and get them to sort it out -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Laurie Gustin Sent: Tuesday, July 26, 2011 2:24 PM To: ids@iiug.org Subject: Question about offline chunk [24457] I have a dbspace with a single chunk that is marked offline. I would like to either bring it online.... or get rid of it so I can re-use the space. When I try to drop the chunk... it says it is not there... but when I try to create it, it says it is already there. This chunk has been like this for a while, and I can't remember the sequence of events that caused it to go offline. I have checked offsets and sizes of other chunks on this storage space and everything appears to be okay. informix@psdb04spr:~> onspaces -c -d socket_in1 -k 0 -p /IDS/data/2_lun1 -o 50855936 -s 1048576 Space already exists. informix@psdb04spr:~> onspaces -d socket_in1 -p /IDS/data/2_lun1 -o 50855936 WARNING: Dropping a chunk. Do you really want to continue? (y/n)y Chunk not dropped. ISAM error: No such chunk informix@psdb04spr:~> onstat -d .. .. ..77cd2688 28 0x60005 28 1 2048 ND B informix socket_in1 .. .. .. 77d2fbc8 28 28 24903680 524288 0 PD-B- /IDS/data/2_lun1 Any hints? Thanks Laurie Laurie Gustin Database Administrator Dept of Technology Services Dept of Public Safety lgustin@utah.gov 801-965-4410 **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. _____ avast! Antivirus <http://www.avast.com>; : Outbound message clean. Virus Database (VPS): 110726-0, 07/26/2011 Tested on: 7/26/2011 2:28:40 PM avast! - copyright (c) 1988-2011 ALWIL Software.