Re: Error Dopping Temp DB Space

onspaces -d dbs_temp -y This should drop the temp dbspace. As indicated below, you cannot drop the first chunk of a dbspace. This chunk contains reserved pages, chunk free list, etc.... but you can drop the entire dbspace by using the command above. "Ben" <ben_informix@com cast.net> To Sent by: <informix-list@iiug.org> owner-informix-li cc st@iiug.org Subject Re: Error Dopping Temp DB Space 08/11/2005 10:58 AM Please respond to "Ben" <ben_informix@com cast.net> Thanks for your suggestion Clifford - here is the result of that command: $onspaces -d dbs_temp -p /export/home/informix/dbspaces/link_disk3_1 -o 100 WARNING: Dropping a chunk. Do you really want to continue? (y/n)y Chunk not dropped. ISAM error: Can not drop first chunk --Ben ----- Original Message ----- From: "Burton, Clifford" <clifford_burton@simplus.com.au> To: "Ben" <ben_informix@comcast.net>; <informix-list@iiug.org> Sent: Wednesday, August 10, 2005 6:54 PM Subject: RE: Error Dopping Temp DB Space > > -----Original Message----- >> From: Ben [mailto:ben_informix@comcast.net] >> Sent: Thursday, 11 August 2005 06:32 >> To: informix-list@iiug.org >> Subject: Re: Error Dopping Temp DB Space >> >> >> My apologies - The database space does indeed exist - I ran the create > database space command merely to show that IDS thinks that it exists - > then > when I try to drop it IDS reports that it does not exist. >> >> I did try 'onspaces -d dbs_temp' - and IDS returned the message that the > space does not exist. > > onspaces -d <spacename> [ -p <path> -o <offset> ]> >> >> Thanks, >> >> Ben > > > ---------------------------------------------------- > > This message is for the named person's use only. > > Privileged/confidential information may be contained in > this message. If you are not the addressee indicated in > this message (or responsible for delivery of the message > to such person), you may not copy or deliver this > message to anyone. In such case, you should destroy > this message, and notify us immediately. > > Any views expressed in this message are those of the > individual sender, except where the message states > otherwise and the sender is authorised to state them to > be the views of any such entity. > ---------------------------------------------------- > sending to informix-list sending to informix-list sending to informix-list

if onspaces -d dbs_temp -y does not work and onstat -d shows it... There was a bug that one could not drop a dbspace because in the sys res pages it was a bit mucked up; eq there was an unexpected whitespace or something else.. i suggest you contact techsupport and have them look at it. i guess they ask you for a oncheck -pr and may be a dump or dd of your sys reserved pages where this dbspace resides. if you can reproduce this in 9.4xx then i guess its a new bug?? where reproduce is create space drop space. Superboer Darren_Jacobs@carmax.com schreef: > onspaces -d dbs_temp -y> > This should drop the temp dbspace. As indicated below, you cannot drop the > first chunk of a dbspace. This chunk contains reserved pages, chunk free > list, etc.... but you can drop the entire dbspace by using the command > above. > > > > > > > "Ben" > <ben_informix@com > cast.net> To > Sent by: <informix-list@iiug.org> > owner-informix-li cc > st@iiug.org > Subject > Re: Error Dopping Temp DB Space > 08/11/2005 10:58 > AM > > > Please respond to > "Ben" > <ben_informix@com > cast.net> > > > > > > > Thanks for your suggestion Clifford - here is the result of that command: > > > $onspaces -d dbs_temp -p /export/home/informix/dbspaces/link_disk3_1 -o 100 > WARNING: Dropping a chunk. > Do you really want to continue? (y/n)y > Chunk not dropped. > ISAM error: Can not drop first chunk> > --Ben > > > > > ----- Original Message ----- > From: "Burton, Clifford" <clifford_burton@simplus.com.au> > To: "Ben" <ben_informix@comcast.net>; <informix-list@iiug.org> > Sent: Wednesday, August 10, 2005 6:54 PM > Subject: RE: Error Dopping Temp DB Space > > > > > > -----Original Message----- > >> From: Ben [mailto:ben_informix@comcast.net] > >> Sent: Thursday, 11 August 2005 06:32 > >> To: informix-list@iiug.org > >> Subject: Re: Error Dopping Temp DB Space > >> > >> > >> My apologies - The database space does indeed exist - I ran the create > > database space command merely to show that IDS thinks that it exists - > > then > > when I try to drop it IDS reports that it does not exist. > >> > >> I did try 'onspaces -d dbs_temp' - and IDS returned the message that the > > space does not exist. > > > > onspaces -d <spacename> [ -p <path> -o <offset> ]> > > >> > >> Thanks, > >> > >> Ben > > > > > > ---------------------------------------------------- > > > > This message is for the named person's use only. > > > > Privileged/confidential information may be contained in > > this message. If you are not the addressee indicated in > > this message (or responsible for delivery of the message > > to such person), you may not copy or deliver this > > message to anyone. In such case, you should destroy > > this message, and notify us immediately. > > > > Any views expressed in this message are those of the > > individual sender, except where the message states > > otherwise and the sender is authorised to state them to > > be the views of any such entity. > > ---------------------------------------------------- > > sending to informix-list > > sending to informix-list > > sending to informix-list