RE: Dropping a dbspace

You need to make it available again to drop it. You do that with onspaces -s ... or restore from archive. Otherwise the easiest is to reinitialise and start again. MW > -----Original Message----- > From: owner-informix-list@iiug.org > [mailto:owner-informix-list@iiug.org]On Behalf Of Chariya Peterson > Sent: Tuesday, 3 February 2004 11:17 a.m. > To: informix-list@iiug.org > Subject: Re: Dropping a dbspace > > > > > "TBP@Nospam.Nothere.Co.Uk" wrote: > > > > Chariya Peterson wrote: > > > > > > > > I have a bad dbspace I wanted to drop (and recreated). But I > have some > > > problem. > > > Here is the output form onstat -d: > > > > > > 5010c7d8 1 0x20001 1 1 N informix > > > dbroot_test3 > > > 5020dcb0 2 0x20005 2 1 ND > informix dbdata > > > 5020de00 3 0x2001 3 1 N T informix > > > dbtemp01 > > > > > > 5010c928 1 1 0 50000 45561 PO-- > > > /usr/informix/dev-links/DBROOT_TEST3 > > > 5021cc50 2 2 1 208000 0 PD-- > > > /usr/informix/dev-links/DBDATA_TEST3 > > > 5021cdd0 3 3 1 50000 49947 PO-- > > > /usr/informix/dev-links/DBTEMP1_TEST3 > > > > > > I tried to drop dbdata, but both onmonitor and onspaces just hang. > > > We are using Informix 9.4. > > > > > > Thanks, > > > Chariya > > > > Platform?? > > AIX RS6000 > > > > What "went bad"? > The DBDATA dbspace is down (with flag = ND). I wanted to drop and > import the database from another server but have to get the dbspace > online (or drop/recreate) first. > > > Here is the error messages from onmode/oninit > ---- > informix@saatest3 $ onmode -ky > Warning: checkpoint appears to be stalled and is not complete. > Continuing shutdown > ---- > informix@saatest3 $ > informix@saatest3 $ oninit > SENDER IS NULL NO MAIL WILL BE SENT > oninit: Cannot open chunk '/usr/informix/dev-links/DBDATA_TEST3'. errno > = 2 > ---- > > > > > > What error is in the online log when you try and drop it? > 16:19:04 Dataskip is now OFF for all dbspaces > 16:19:04 Checkpoint blocked by down space, waiting for override or> shutdown > 16:20:00 (4) connection rejected - no calls allowed for sqlexec > 16:20:00 listener-thread: err = -27002: oserr = 0: errstr = : No> connections are allowed in Dynamic Server quiescent mode. > ---- > > > > > What does ls -l /usr/informix/dev-links/DBTEMP1_TEST3 show? > Seems normal. > ls -l > lrwxrwxrwx 1 informix informix 19 Apr 14 2003 > /usr/informix/dev-links/DBDATA_TEST3@ -> /dev/dbdata_testdb > > > > What does ls -L /usr/informix/dev-links/DBDATA1_TEST3 show? > ls -L > /dev/dbdata_testdb > > > > > > > > On the assumption that you have some logical logs, and a bit of physical > > log, I wonder how much actual "data" is left in the instance with this > > dbspace dbdata marked as down. > > There is no need to recover the data. I simply want to drop and > recreate this dbspace (DBDATA). Then import the database. > > Chariya sending to informix-list

"Murray Wood (IList)" wrote: > > You need to make it available again to drop it. You do that with onspaces -s ... or restore from archive. > > Otherwise the easiest is to reinitialise and start again. > > MW I tried what you suggested and get the following error: informix@saatest3 $ onspaces -s dbdata -p /usr/informix/dev-links/DBDATA_TEST3 -o 4 Warning: Bringing chunk back online. Do you really want to continue? (y/n)y Verifying physical disk space, please wait ... Cannot change chunk status. ISAM error: illegal argument to ISAM function. informix@saatest3 $ Looks like a bad disk? chariya > > > -----Original Message----- > > From: owner-informix-list@iiug.org > > [mailto:owner-informix-list@iiug.org]On Behalf Of Chariya Peterson > > Sent: Tuesday, 3 February 2004 11:17 a.m. > > To: informix-list@iiug.org > > Subject: Re: Dropping a dbspace > > > > > > > > > > "TBP@Nospam.Nothere.Co.Uk" wrote: > > > > > > Chariya Peterson wrote: > > > > > > > > > > > I have a bad dbspace I wanted to drop (and recreated). But I > > have some > > > > problem. > > > > Here is the output form onstat -d: > > > > > > > > 5010c7d8 1 0x20001 1 1 N informix > > > > dbroot_test3 > > > > 5020dcb0 2 0x20005 2 1 ND > > informix dbdata > > > > 5020de00 3 0x2001 3 1 N T informix > > > > dbtemp01 > > > > > > > > 5010c928 1 1 0 50000 45561 PO-- > > > > /usr/informix/dev-links/DBROOT_TEST3 > > > > 5021cc50 2 2 1 208000 0 PD-- > > > > /usr/informix/dev-links/DBDATA_TEST3 > > > > 5021cdd0 3 3 1 50000 49947 PO-- > > > > /usr/informix/dev-links/DBTEMP1_TEST3 > > > > > > > > I tried to drop dbdata, but both onmonitor and onspaces just hang. > > > > We are using Informix 9.4. > > > > > > > > Thanks, > > > > Chariya > > > > > > Platform?? > > > > AIX RS6000 > > > > > > > What "went bad"? > > The DBDATA dbspace is down (with flag = ND). I wanted to drop and > > import the database from another server but have to get the dbspace > > online (or drop/recreate) first. > > > > > > Here is the error messages from onmode/oninit > > ---- > > informix@saatest3 $ onmode -ky > > Warning: checkpoint appears to be stalled and is not complete. > > Continuing shutdown > > ---- > > informix@saatest3 $ > > informix@saatest3 $ oninit > > SENDER IS NULL NO MAIL WILL BE SENT > > oninit: Cannot open chunk '/usr/informix/dev-links/DBDATA_TEST3'. errno > > = 2 > > ---- > > > > > > > > > > > What error is in the online log when you try and drop it? > > 16:19:04 Dataskip is now OFF for all dbspaces > > 16:19:04 Checkpoint blocked by down space, waiting for override or> > shutdown > > 16:20:00 (4) connection rejected - no calls allowed for sqlexec > > 16:20:00 listener-thread: err = -27002: oserr = 0: errstr = : No> > connections are allowed in Dynamic Server quiescent mode. > > ---- > > > > > > > > > What does ls -l /usr/informix/dev-links/DBTEMP1_TEST3 show? > > Seems normal. > > ls -l > > lrwxrwxrwx 1 informix informix 19 Apr 14 2003 > > /usr/informix/dev-links/DBDATA_TEST3@ -> /dev/dbdata_testdb > > > > > > > What does ls -L /usr/informix/dev-links/DBDATA1_TEST3 show? > > ls -L > > /dev/dbdata_testdb > > > > > > > > > > > > > > On the assumption that you have some logical logs, and a bit of physical > > > log, I wonder how much actual "data" is left in the instance with this > > > dbspace dbdata marked as down. > > > > There is no need to recover the data. I simply want to drop and > > recreate this dbspace (DBDATA). Then import the database. > > > > Chariya > > sending to informix-list