Re: How to determine a db's dbpace?

Roger Tomas (tomasr@agcs.com) wrote: : 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. tbcheck -pe will produce a report of all tables and their dbspace by database and table name. To find the location of the database system tables, look for a table called database:informix.systables. Although the dbspace name does not appear on the same line as the table name, you could write a quickie awk pgm to save the most recent dbspace name when you encounter the desired system table. Enjoy, Bill *8o) =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ /*** / ***\\ Hewlett-Packard Company / \\ / Colorado Springs ITC /* / \\ /**\\ /***\\ / \\/ \\ Phone: TN/(719) 590-3402 / \\ \\ Fax: " " 590-3596 / Bill Border \\ \\ EMail: border@cs.itc.hp.com / MVS Technical Support Mailstop: C103G