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

CRJAZ0265I The virtual storage or database resource is .....

Questions
Tags
Users
Badges
Jeff Ong
(141●1●39●47) Jun 27 '08, 11:02 p.m.
I'm trying to run "repotools -createTables" but it keeps giving me the error below. The database server is remote and isn't on the same RTC server. I am able to connect to the database however with no issue. 


CRJAZ0265I The virtual storage or database resource is not available.

SQL: CREATE TABLESPACE CONTENTTS MANAGED BY DATABASE USING (file 'content_tables

pace' 250000) DROPPED TABLE RECOVERY OFF AUTORESIZE YES

SQL Exception #1

SQL Message: DB2 SQL error: SQLCODE: -968, SQLSTATE: 57011, SQLERRMC: null

SQL State: 57011

Error Code: -968



CRJAZ0265I The virtual storage or database resource is not available.

SQL: CREATE TABLESPACE CONTENTTS MANAGED BY DATABASE USING (file 'content_tables

pace' 250000) DROPPED TABLE RECOVERY OFF AUTORESIZE YES

SQL Exception #1

SQL Message: DB2 SQL error: SQLCODE: -968, SQLSTATE: 57011, SQLERRMC: null

SQL State: 57011

Error Code: -968



The database tables were not created.

0 votes

1 answer
8,267 views
0 votes

One answer

Permanent link
Jeff Ong
(141●1●39●47) Jun 29 '08, 1:53 p.m.
Fixed. We ran out of disk space on the remote server.

1 vote

Comments
Josh Crawford
May 31 '13, 8:34 a.m.

I also ran into this with a client recently.  We used db2diag output to validate that this client was also out of disk space on the filesystem they were using for storage on a remote host.  

Kevin Ramer
May 31 '13, 9:05 a.m.

One can also ask DB2 to describe the situation.  I do it this way:

$ db2 \? sql0968


SQL0968C  The file system is full.

Explanation:

One of the file systems containing the database is full. This file
system may contain the database directory, the database log files, or a
table space container.

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.

Ask a question
Guidelines
FAQ
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: Jun 27 '08, 11:02 p.m.

Question was seen: 8,267 times

Last updated: May 31 '13, 9:05 a.m.

Confirmation Cancel Confirm