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]>
Sent by: [EMAIL PROTECTED] 10/23/2001 09:53 AM
|
To: [EMAIL PROTECTED] cc: (bcc: Ronald Draper/MIS/DAS/MODNR) Subject: DB2EUG: create table |
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
