identifying objects in a dbspace

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.com... > 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.com... > > 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