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
