Hi,

We have the following configuration :

DB2 UDB Version : 7.2
IBM AIX : 4.3.3

on IBM RS/6000 Server Machines (3 Node Cluster).

The problem is we can't take an offline/online backups.
The command I gave was :

db2 "backup db <dbname> online to ."

The error message I get is:

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

I'm giving the info about Object "175" below:

Tablespace ID = 175
Name = TSPAN
Type = Database managed space
Contents = Any data
State = 0x4100
Detailed explanation:
Restore pending
Offline

Tablespace ID = 176
Name = IXPPAN
Type = Database managed space
Contents = Any data
State = 0x4080
Detailed explanation:
Roll forward pending
Offline

There are 5 more tablespaces having the state : 0x4080.

I've tried to Roll Forward :

db2 "rollforward database <dbname> to end of logs tablespace (NFSTEST) online"

SQL1272N Table space level roll-forward recovery for database "<DBNAME>" has stopped before completion on node(s) "0".

We haven't been able to take any backups for the past 1 month. Can
anybody help?

Regards

Ranjit Bhaskar

Well, as the reason code says and the

Detailed explanation:
Restore pending
Offline

suggests your tablespace is not available for operation besides restoration. So do the restore/rollforward first and then you can take a backup.

check this link:

http://www.developer.ibm.com/tech/fa...:20544,00.html
http://www-1.ibm.com/support/docview...id=swg21053707

and

http://www-3.ibm.com/software/data/p.../ibmnetapp.pdf

The tablespaces which I'm referring to are curently not used by our application. So all we want is to remove it. But we are not able to do that.

We are not even able to do a roll forward . The reason I've mentioned in my earlier post.

The error which I'm getting while trying to drop this tablespace is :

DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned:
SQL0282N Table space "TSPAN" cannot be dropped because at least one of the tables in it, "DB2INST1.PAN_NEW", has one or more of its parts in another table space. SQLSTATE=55024

Next I tried dropping the table : PAN_NEW. I got the error :

DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned:
SQL0290N Table space access is not allowed. SQLSTATE=55039

So either way I'm stuck.

I CAN'T ROLL FOWARD THE TABLESPACES.
I CAN'T DELETE THE TABLESPACES. Either one would solve my problem.

Are logs missing on node 0? Have you looked at sql1272n - to me it indicates that there was something in the logs that it couldn't rollforward through - like a ddl change or an autoload to the table - what does the diaglog say?

Do you have a backup to go back to and it's correponding logs to rollforward to the Minimum Point of time of the database? If you do, do a full recovery with a replace all and rollforward to the MPIT only. At that point the database should be accessible. Then you should be capable of taking a full backup.

The real problem was that I couldn't bring a tablespace back online nor could I drop it 'cause some of its tables exists in some other tablespaces too. This was forming a vicious circle as described above.

Well, I tried dropping both the tablespaces at once.

db2 "drop tablespaces tbsp1, tbsp2"

This time DB2 didn't complain and dropped both. This put a drop pending flag on the tablespaces and getting it out of the offline status and allowing me to drop it finally.

db2 "restart db .... drop pending tablespaces"

This worked just fine and now my backup runs just fine 'cause all the tablspaces are in normal state now.

THANX TO ALL WHO TRIED TO HELP ME.