Re: Error Dopping Temp DB Space




There might be a syntax error in the create dbspace.
The -t flag for temporary dbspace in V. 7.31 should be
between -c and -d. I don't know if this changed in 9.4
In either case, please post the onstat -d output.
This will give a listing of all current dbspaces and chunks.

Regards,
Zev Berezin

Send reply to: "Ben" <ben_informix@xxxxxxxxxxx>
From: "Ben" <ben_informix@xxxxxxxxxxx>
To: <informix-list@xxxxxxxx>
Subject: Error Dopping Temp DB Space
Date sent: Wed, 10 Aug 2005 13:15:48 -0400

> I am encountering an error when attempting to drop a temporary db space.
> The reason I am dropping it is because the disk that it resides on went bad.
>
> Solaris 9
> IDS 9.40.FC5
>
>
> Here is the output from onspaces:
>
> $onspaces -c -d dbs_temp -t -p
> /export/home/informix/dbspaces/link_disk3_1 -o 100 -s 2000000
>
> Space already exists.
>
> $onspaces -d dbs_temp
>
> WARNING: Dropping a DBspace.
> Do you really want to continue? (y/n)y
> Cannot drop the Space.
> ISAM error: no such DBspace
>
> Thanks in advance for any thoughts.
>
> Ben
>
> sending to informix-list
>


sending to informix-list
.



Relevant Pages

  • RE: Error Dopping Temp DB Space
    ... > I am encountering an error when attempting to drop a temporary db ... > Here is the output from onspaces: ... > WARNING: Dropping a DBspace. ...
    (comp.databases.informix)
  • Error Dopping Temp DB Space
    ... The reason I am dropping it is because the disk that it resides on went bad. ... Here is the output from onspaces: ... WARNING: Dropping a DBspace. ...
    (comp.databases.informix)
  • Re: Temporary dbspace
    ... I was involved with a single temp dbspace system (I ... > Many of my current systems have just one temporary dbspace. ... > Some reports and queries are not performing as well as they did when an ...
    (comp.databases.informix)
  • Re: max pages allocated issue
    ... We've ran into this problem before, where we hit the limit of the number of pages that can be allocated to a dbspace for a table. ... Be aware that dropping an "in table" index is not the instant operation that dropping a detateched index is. ...
    (comp.databases.informix)
  • Re: Relocate Informix database from Raw slices to filesystem
    ... > So effectively add a mirrored chunk to each dbspace using onspaces and ... > then drop the original chunk. ... > Can you do this for the rootdbs dbspace too...? ...
    (comp.databases.informix)