Informix Cannot Drop First Chunk

Login as user informix and from a command line window, execute: onspaces -d spacename -d Drop a DBspace, BLOBspace, SBLOBspace, Extspace spacename The name of the DBspace to drop Example: If the data isn't bad - why would the chunk be down ? Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. ISAM error: Can not drop first chunk I dropped the database I was attempting to dbimport but I got the same result when trying to drop the dbspace. http://pgexch.com/informix-cannot/informix-cannot-write-blob.html

Read 14 Mar 12 - BernieSpang.com - International Informix User Group set to meet in San Diego... Superboer [email protected] schreef: > onspaces -d dbs_temp -y > > This should drop the temp dbspace. Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy Terms of use Accessibility Login by ID Login by Member # Save Password: Save In Response To: force drop dbspace with first chunk inconsistent? (GERARDO PADIERNA) Put a call into tech support and they can do a secure "dial-in" to your system and drop it

Read 26 Feb 12 - BernieSpan.com - Better results, lower cost for a broad set of new IBM clients and partners... Pact enables five-city smart meter pilot in Europe... If so you can delete the data in the chunk or drop the table(s) and/or fragments there. If you are not the addressee indicated inthis message (or responsible for delivery of the messageto such person), you may not copy or deliver thismessage to anyone.

If you are not the addressee indicated inthis message (or responsible for delivery of the messageto such person), you may not copy or deliver thismessage to anyone. Kagel Guest « create index stalls entire informix server | How to switch off constraints? » Similar Threads big dbspace By Gokusan in forum Informix Replies: 2 Last Post: October 10th, Ingres available on sparcstation? 7. http://members.iiug.org/forums/ids/index.cgi/read/21051 Read 28 May 12 - Bloor - David Norfolk on the recent Informix benchmark "pretty impressive results"...

What i did was accidentally assigned the same chunk of space to two different instances. Read 20 Jul 10 - IBM Announcements - Software withdrawal: Elite Support for Informix Ultimate-C Edition... Then you will be able to drop the chunk using onspaces -d unless some database resides in that chunk. but you can drop the entire dbspace by using the commandabove."Ben" ToSent by: owner-informix-li cc***@iiug.orgSubjectRe: Error Dopping Temp DB Space08/11/2005 10:58AMPlease respond to"Ben"Thanks for your suggestion Clifford - here is the

However if we run "oncheck -pe" nothing is in this particular chunk. What could be causing this or what are we missing ? Drop the dbspace - onspaces -d dbspacename Document information More support for: Informix Servers Software version: 10.0, 11.1, 11.5, 11.7 Operating system(s): AIX, HP-UX, Linux, OS X, Solaris, Windows Reference #: http://pgexch.com/informix-cannot/informix-cannot-locate-service-tcp.html But running the command "onspaces -d ..." gives the error "chunk not empty".

Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy Terms of use Accessibility United States English English IBM® Site map IBM IBM Support Check here to Terms of use *** Powered By IBM Informix Dynamic Server V11.10 - Run Cheetah Run*** Very Computer Board index Informix cannot drop empty chunk ? It keeps its own database of what disk space belongs to what instance an will not allow one to add chunks that overlapp to different instances.

I think the onspaces -s may only work if you are using Informix mirroring. (** not true - see below **) See below for various input from people on this matter.

Try first bringing the chunk up using onspaces -s to change the chunk status to "Online". Do you really want to continue? (y/n)y Verifying physical disk space, please wait ... Add discriptive comments list to file 8.3 file names 5. his comment is here Any help would be greatly appreciated.

As indicated below, you cannot drop thefirst chunk of a dbspace. i suggest you contact techsupport and have them look at it. As indicated below, you cannot drop the > first chunk of a dbspace. Read 14 Nov 12 - IBM - IBM's Big Data For Smart Grid Goes Live In Texas...

Read 19 May 10 - ZDNet - IBM software in your home? Read 10 Aug 12 - businessCLOUD9 - Is this the other half of Cloud monitoring?... Well - it seems that there is no way to drop a bad chunk unless you get Informix support to do it for you. Joe Lumbley Home Services Forums Advertise Contact or Login Login to Your Account Remember Me?

I don't know if this changed in 9.4In either case, please post the onstat -d output.This will give a listing of all current dbspaces and chunks.Regards,Zev BerezinSubject: Error Dopping Temp DB Regards, Denmark W. 2. ISAM error: bad isam file format. I still cannot remove the chunk/dbspace from instance 1 because of an error: Cannot drop the Space.

Lester Knutsen (IBM Champion) writes about database back up safety using "archecker"... Read Previous news items End of Support Dates IDS 11.10 - 30 Sep 2012 Subscribe to notifications a> Home Member Area About IIUG Help Resources IIUG Insider IIUG Hotspots Informix Links This is what it looks like: onspaces -s mydbspacename -p /informix/RawSpaces/mychunkname -o 0 -O Warning: Bringing chunk back online. I still cannot remove the chunk/dbspace from instance 1 > because of an error: > Cannot drop the Space. > ISAM error: bad isam file format. > > I assume this