User Profile

Collapse

Profile Sidebar

Collapse
Raymond Batkin
Raymond Batkin
Last Activity: Mar 23 '12, 08:38 PM
Joined: Mar 20 '12
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • How to get out of "BACKUP PENDING. SQLSTATE=57019 on DB2" State

    How do you recover from a

    BACKUP PENDING. SQLSTATE=57019 on DB2 (XP O/S)?

    Reason probably because I set LOGARCHMETH1 to TSM in error
    Need to be LOGARCHMETH1 OFF

    Current situation means I cannot connect to database because it has 'BACKUP PENDING' - so I cannot do anything with the database - need a 'get out of jail' solution.

    Help please.
    See more | Go to post

  • Raymond Batkin
    started a topic DB2 v9.0 (Enterprise) vendor code
    in DB2

    DB2 v9.0 (Enterprise) vendor code

    I am running a database under XP with DB2 Enterprise edition v9.0 (no longer supported).
    The database is backed up and then an attempt to 'restore' it on a different machine. This fails with a SQL2071N error

    The IBM site mentions

    (quote)
    If the user tries to restore a database from a backup image and transaction log files archived using a vendor library and later extracted to the disk, and if the vendor...
    See more | Go to post
No activity results to display
Show More
Working...