SQL2048

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JasonFriedman80238 - 13 Dec 2005 17:00 GMT

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.

Reply to this Message

Mark A - 13 Dec 2005 18:55 GMT

>I tried to backup a database with
> db2 backup database mydb, and (after a few minutes) received this
[quoted text clipped - 4 lines]
> 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.

Reply to this Message