Hi,

I've dropped an index of a fragmented table from a dbspace, but to my
surprise the dbspace still has used pages. I would have thought the
dbspace would be empty. When rebuilding the index, the used pages do
not seem to be reused. Then when I try to drop the dbspace I receive
the messages that the DBspace is not empty.

How do I identify what's left in this dbspace?

I'm using Informix Dynamic Server 9.3 on a Sun Enterprise 3000 running
Solaris 8.

Thanks,
Steve

oncheck -pe dbspacename


"Steven Kurlander" <skurlander@yahoo.com> wrote in message
news:4f7c9960.0410110626.25628966@posting.google.c om...
> Hi,
>
> I've dropped an index of a fragmented table from a dbspace, but to my
> surprise the dbspace still has used pages. I would have thought the
> dbspace would be empty. When rebuilding the index, the used pages do
> not seem to be reused. Then when I try to drop the dbspace I receive
> the messages that the DBspace is not empty.
>
> How do I identify what's left in this dbspace?
>
> I'm using Informix Dynamic Server 9.3 on a Sun Enterprise 3000 running
> Solaris 8.
>
> Thanks,
> Steve

dbaccess sysmaster <<!
select * from systabnames where dbinfo("dbspace", partnum) = "rootdbs"
!

see you

Superboer

"Dave Griffen" <dgriffen@nospam.finishline.com> wrote in message news:<cke737$bq0$1@news.onecall.net>...
> oncheck -pe dbspacename
>
>
> "Steven Kurlander" <skurlander@yahoo.com> wrote in message
> news:4f7c9960.0410110626.25628966@posting.google.c om...
> > Hi,
> >
> > I've dropped an index of a fragmented table from a dbspace, but to my
> > surprise the dbspace still has used pages. I would have thought the
> > dbspace would be empty. When rebuilding the index, the used pages do
> > not seem to be reused. Then when I try to drop the dbspace I receive
> > the messages that the DBspace is not empty.
> >
> > How do I identify what's left in this dbspace?
> >
> > I'm using Informix Dynamic Server 9.3 on a Sun Enterprise 3000 running
> > Solaris 8.
> >
> > Thanks,
> > Steve