DB2 backup problem

[Former Member]

hello,

I have a problem with the full online backup on a DB2 system

I get the fallowing error:

ERRORMESSAGE: Error -2048 in dmdb6bkp.c(1498):

SQL2048N An error occurred while accessing object "0". Reason code:

"6".

I cannot get any clue of the cause of the error from the log. I have also searched for SAP notes but did not find anything.

Can anyone help me in solving this issue?

Regards,

dalmi

[former_member524429]

Hi,

Is this your First DB2 Online Backup after enabling logging?

If its your first Online DB2 Backup, you can execute the following command to remove BACKUP PENDING status in Database(Immediate Offline Backup is recoomended after or before enabling/disabling Logging in Database).

db2dart <SID> /CHST /what dbbp off

Any existing backup operation in progress ?

You can execute the following db2 command to get the details of tablespace.

db2 list tablespaces show detail

any Table space is showing "Backup Pending" or another status ?

Also look at db2diag.log file to get more information about such error while performing backup.

Regards,

Bhavik G. Shroff

[Former Member]

This message was moderated.

[Former Member]

Not again, you have copied the content from http://www.ibm.com/developerworks/data/library/techarticle/pworld/0112mccluney.html

[Former Member]

The same error occured in one of our production systems, reason being another backup was still active which started on previous day.

Upon checking in DB02 the TableSpace Status shows: Backup In Progress.

[paul_power]

Hello Dalmi,

as per the documentation on this error code:

http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=/com.ibm.db2.luw.messages.sql.d...

SQL2048N

An error occurred while accessing object object. Reason code: reason-code.

Explanation

An error occurred while accessing an object during the processing of a database utility. The following is a list of reason codes:

6

The object being accessed is a table space and either the table space is in such a state that the operation is not allowed or one or more containers of the table space is not available. (LIST TABLESPACES will list the current table space state.) Examples of such states are: quiesced, offline.

What is the output of db2 list tablespaces show detail

State 0x0000 should mean they are all normal and should be accessible.

If not, check the output of db2 list applications show detail

check if an application si trying to perform a backup of a tablespace that migth have set them to an offline state.

regards,

paul