473,320 Members | 1,955 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

SQL2048

I tried to backup a database with
db2 backup database mydb, and (after a few minutes) received this
error:
SQL2048N An error occurred while accessing object "Tablespace: 0,
Table:
SQL00050". Reason code: "4".
Reason code 4 resolves to: "Access to an object failed."
How can I get around this? We are running DB2 8.2.0 on Linux.

Dec 13 '05 #1
1 3826
"JasonFriedman80238" <ja***@powerpull.net> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...
I tried to backup a database with
db2 backup database mydb, and (after a few minutes) received this
error:
SQL2048N An error occurred while accessing object "Tablespace: 0,
Table:
SQL00050". Reason code: "4".
Reason code 4 resolves to: "Access to an object failed."
How can I get around this? We are running DB2 8.2.0 on Linux.


You need to do:

db2 list tablespaces show detail

to find the status of the database and find out what the problem is. For
each tablespace, you may also want to check that the containers are
accessible.
Dec 13 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.