Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

DB2 v9.7 error in migrating from Derby

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?

0 votes



One answer

Permanent link
I believe that the content_tablespace file is created as a 4Gb file so your 3.3Gb free won't be enough ...

0 votes

Your answer

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Dec 02 '10, 3:48 p.m.

Question was seen: 7,066 times

Last updated: Dec 02 '10, 3:48 p.m.

Confirmation Cancel Confirm