All geek questions in one place

Failed to allocate new pages in table space "XXXX" ... but it's 250 megabytes and I use only DDL

I am new to DB2, so I would appreciate even any pointers to where to start looking. We have excellent DB2 administrators, but now they are crammed with other problems, so I'm trying to perform some troubleshooting problems in the development database.

My situation is that I have a tablespace that gives me this error message

It is not possible to select new pages in the table space "[MyTableSpace]".

However, everything I do is executed by several (hundreds) of DDL statements, mostly creating tables, as well as pk indexes and scripts. So, given that the tablespace has about 250 mg, I should not escape from space, right?

Here's another thing - it seems that after I leave my script for a while, something "resets" and works for a while, then again I will become a problem with the table space. However, there may be something else going on.

thanks Sylvia

+3
source share
2 answers

Check the extent size for your tablespace (see the EXTENTSIZE column in SYSCAT.TABLESPACES).

DB2 2 . (, 32 ), 250 .

, 16kb 32 ( ) 1 (16 * 32 / * 2 ).

, , (, 2 4 ) , .

+5

, ? :  1. ,  2. max_size  3. 1

!

0

Source: https://habr.com/ru/post/1739649/

More articles:


All Articles