It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×42,863

question asked: Jun 27 '08, 11:02 p.m.
question was seen: 8,109 times
last updated: May 31 '13, 9:05 a.m.

Related questions

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

0
Jeff Ong (141●1●39●47) | asked 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.

One answer

Most liked answers ↑|Newest answers|Oldest answers

1
permanent link
Jeff Ong (141●1●39●47) | answered Jun 29 '08, 1:53 p.m.
Fixed. We ran out of disk space on the remote server.
Comments
Josh Crawford commented 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 commented 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 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.