Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2003
    Location
    Mumbai. India
    Posts
    4

    Unhappy Unanswered: Backup Failed : SQL2048N

    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

  2. #2
    Join Date
    Sep 2002
    Posts
    456

    Re: Backup Failed : SQL2048N

    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.

    Originally posted by ranjitbh
    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

  3. #3
    Join Date
    May 2002
    Location
    General Deheza, Cba, Arg.
    Posts
    276

  4. #4
    Join Date
    Oct 2003
    Location
    Mumbai. India
    Posts
    4

    Re: Backup Failed : SQL2048N

    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.

  5. #5
    Join Date
    Mar 2003
    Posts
    343
    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.

  6. #6
    Join Date
    Oct 2003
    Location
    Mumbai. India
    Posts
    4

    Smile Solved The Backup Problem

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •