Re: Which dbspaces belong to Data Base from command line
Hi,
select tabname,
partnum,
DBINFO('DBSPACE', (select partnum from systables where
tabname=<TabName>))
from systables
where tabname=<TabName>
Art S. Kagel <kagel@bloomberg.com> wrote in article
<3504798F.426A@bloomberg.com>...
> INGRP Eli Sheena 5228 wrote:
> >
> > Hi
> > I write shell script on unix and i want to remove data base and the
> > spaces which belong to
> > this database so i now how to remove data base from the command line ,
i
> > know how
> > to remove space too, but i don't know how to find the space name (it
can
> > has more then one space)
> > It need to be something like
> > space_name=< command to find the spaces>
>
> Select hex(partnum) from sysmaster:sysdatabases where name = "mydbs";
> the first three hex digits of the partnum are the dbspace number which
> you can fetch from sysdbspaces or eyeball the onstat -d report.
>
> Art S. Kagel
>