RE: dropping a dbspace apparently empty (IOWS 7.20.UC2 )
Posted in 2000
Its a very old Bug. But then you're on a very old engine for which support
has lapsed.
Only Tech Support can drop this.
Upgrade!
MW
-----Original Message-----
From: owner-informix-list@iiug.iiug.org
[mailto:owner-informix-list@iiug.iiug.org]On Behalf Of Jean-Brice
Albertus
Sent: Monday, September 11, 2000 11:57 PM
To: informix-list@iiug.org
Subject: dropping a dbspace apparently empty (IOWS 7.20.UC2 )
Hello
I am trying to drop a dbspace on my IOWS 7.20.UC2 on a SCO Openserver 5.0.2:
>---<
#onspaces -d pcl
WARNING: Dropping a DBspace/BLOBspace.
Do you really want to continue? (y/n)y
Cannot drop the DBspace/BLOBspace.
ISAM error: DBspace is not empty
>---<
the Admin guide says:
"Execute oncheck -pe to verify that no tables or log files are residing in
the
dbspace or blobspace."
And here the results of the oncheck -pe
>---<
DBspace Usage Report: pcl Owner: informix Created:
10/09/98
Chunk: 4 /dev/usr3 Size Used Free
25000 205 24795
Disk usage for Chunk 4 Start Length
------------------------------------------- --------- ---------
OTHER RESERVED Pages 0 2
CHUNK FREE LIST PAGE 2 1
FREE 53 2019
FREE 2122 2648
FREE 4820 20180
DBspace Usage Report: pcl Owner: informix Created:
10/09/98
Chunk: 4 /dev/usr3 Size Used Free
25000 205 24795
Disk usage for Chunk 4 Start Length
------------------------------------------- --------- ---------
TBLSPACE TBLSPACE 3 50
TBLSPACE TBLSPACE 2072 50
TBLSPACE TBLSPACE 4770 50
>---<
I think that dbspace is empy, isn't it ?
May anyone help me ?
Thank you very much...
Jean-Brice Albertus
jb.albertus@imsii.fr