It's all about the answers!

Ask a question

DB2 v9.7 error in migrating from Derby


Robert Carter (42928789) | asked Dec 02 '10, 3:48 p.m.
Task:
Migrating from derby to DB2 express-c v9.7

Environment:
RTC 2.0.0.2, Ubuntu 10.04 LTS, DB2 Express-C v9.7, VMware Fusion 3.1.1

Error:

CRJAZ0265I The virtual storage or database resource is not available.
SQL: CREATE TABLESPACE CONTENTTS MANAGED BY DATABASE USING (file 'content_tablespace' 250000) DROPPED TABLE RECOVERY OFF AUTORESIZE YES
SQL Exception #1
SQL Message: DB2 SQL Error: SQLCODE=-968, SQLSTATE=57011, SQLERRMC=null, DRIVER=
3.53.70
SQL State: 57011
Error Code: -968


Troubleshooting:
I have seen this error message in other threads. It seems to be indication that my filesystem is full. However, I have confirmed that I have space on the filesystem using the df -h command:

Filesystem Size Used Avail Use% Mounted on
/dev/sda1 9.4G 5.7G 3.3G 64% /
none 496M 204K 496M 1% /dev
none 500M 0 500M 0% /dev/shm
none 500M 44K 500M 1% /var/run
none 500M 0 500M 0% /var/lock
none 500M 0 500M 0% /lib/init/rw


Any thoughts here?

One answer



permanent link
Robin Parker (32633738) | answered Dec 03 '10, 12:33 p.m.
I believe that the content_tablespace file is created as a 4Gb file so your 3.3Gb free won't be enough ...

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.