Hi Ron, Container information and tablespace statistics related to the size of a tablespace, amount of used pages, etc. are not stored in the system catalog tables.
As you pointed out, this information is available in the LIST TABLESPACE CONTAINERS SHOW DETAIL command but you can also get this information using the APIs provided by DB2. The ones you would be interested in are: sqlbotcq - Open tablespace container query sqlbftcq - Fetch tablespace container query sqlbctcq - Close tablespace container query sqlbtcq - Tablespace container query (does all 3 above in one call) sqlbgtss - Get tablespace statistics. There is also a set of APIs for querying other information about tablespaces. For more information, please see the Administrative API Reference in the DB2 manuals. Regards, Kelly Kelly Schlamb DB2 Universal Database Development, IBM Toronto Lab, Canada Email: [EMAIL PROTECTED] Phone: 905-413-2469 DB2 Online Support Website: http://www.ibm.com/software/data/db2/udb/winos2unix/support "Ronald Draper" <[EMAIL PROTECTED] To: [EMAIL PROTECTED] e.mo.us> cc: Sent by: Subject: Re: DB2EUG: create table [EMAIL PROTECTED] a.best.com 10/23/2001 04:25 PM Please respond to db2eug Hello everyone, I'm trying to build a script to create the commands for a redirected restore and I need to know where in the catalog is the total pages value is stored or how it is calculated. You can get the value when you run the "LIST TABLESPACE CONTAINER FOR tablespace id SHOW DETAIL," so it must be stored some where or calculated from stored data. Any help would be great appreciated. Thanks Ron Draper Computer Information Technology Specialist I Missouri Department of Natural Resources MIS Program 526-1077 [EMAIL PROTECTED] Microsoft Certified Professional "Gandra, Narayan" <[EMAIL PROTECTED]> To: Sent by: [EMAIL PROTECTED] [EMAIL PROTECTED] cc: (bcc: Ronald Draper/MIS/DAS/MODNR) Subject: DB2EUG: 10/23/2001 09:53 AM create table Please respond to db2eug Hello All, When I issue the following command gettig the following error message: db2 "create table test (col1 int)" DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL0289N Unable to allocate new pages in table space "NGTS_100_PCT_4K". SQLSTATE=57011 I know one of my above tablespace is 100% full, but when I issue the above create table statement the table should be created in userspace1 tablespace which is default and userspace1 tablespace has lot of space avialable to create objects. If I issue the following create table statement then working fine. db2 "create table test (col1 int) in userspace1" DB20000I The SQL command completed successfully. If none of the tablespaces was full then working fine. All Suggestions are welcome. Thank you in advance! -GNR ===== To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod ===== To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
