we have an error:
SQL0289N - Unable to allocate new pages in table space with DB2 ESE in IWD
from the db2 log, it say:
"ADM6044E The DMS table space "USERSPACE1" (ID "2") is full. Additional space
can be added to the table space by either adding new containers or extending
existing ones using the ALTER TABLESPACE SQL statement.
so I can only use alter to extend the userspace1, right?
I found that one to teach me how to do this:
"df -k <tablespace.path>" what should be the <tablespace.path> is about ? how can I find that out ?
I login to the solarix console and type this instead
df -k , it show me some data with column :
6) mounted on
what is the following means:
the avail value is number of Bytes available for each of the Filesystem, ?
what I know is the structure of userspace1 is :
CREATE REGULAR TABLESPACE USERSPACE1
IN DATABASE PARTITION GROUP IBMDEFAULTGROUP
MANAGED BY DATABASE
USING ( File '/space/home/yyyy/user/user_container' 602908 )
DROPPED TABLE RECOVERY ON
if the file thing, "/space/home/yyyy/user/use
r", is the value for <tablespace.path> in the command "df -k <tablespace.path>" ?
just want to know how many MB I have to increase in storage!