Re: How to determine a db's dbpace?

> In article <34o1oj$ck6@laugh.agcs.com> tomasr@agcs.com (Roger Tomas) > writes:>Anyone know how to determine a database's dbspace in a manner > >that can be done from a UNIX shell script? I need to create > >a shell script that creates a database in the same dbspace as > >a related database but cannot make any assumptions about which > >dbspace that might be. > > > > You need to find the hex(partnum) of a system catalog, and find the > dbspacethat corresponds to the first half of the word. > > I do it as follows: > > get_dbspacenum_t () { > DBSPACENUM=`echo " > output to pipe cat without headings > select hex(partnum) from systables > where tabname = \\"${1?}\\" > " | isql $DBNAME 2>&- | awk ' > /0/ {print substr($0,4,1)}'` > } > > I get the free space for it this way - > > get_dbspace_free () { > DBSPACEFREE=`tbstat -d | awk ' > /pathname/ { > while (getline) > if ( $3 == "'${DBSPACENUM?}'" ) > FREE+=$6 > } END { print FREE }'` > } > > I thought I had something to dig out the spacename as well but - > I dont, so I guess you can take it from there. > You don't say which release of OnLine you are running! If you have version 6 you should be able to do it using the sysmaster database. Malcolm