Re: Which dbspaces belong to Data Base from command line

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