In a UDB class, I was told that if you do not specify the tablespace on the create table statement and someone has created a tablespace in the database then DB2 will try to use to tablespaces, rather than userspace1. If there are multiple user-created tablespaces, then DB2 will use the first created
user tablespace. If you have no user-created tablespaces, then DB2 will use the userspace1 tablespace. I have not seen this documented in the manuals, but your experience leads me to believe what I heard is correct. "Gandra, Narayan" wrote: > 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
