Results 1 to 11 of 11
  1. #1
    Join Date
    Sep 2003
    Posts
    27

    Unanswered: Problem with offline backup

    Hi all
    I am using db2 V8 on red hat 7.3. I can do the online backup. But when i perform the offline backup. It will prompt following error,
    SQL1224N A database agent could not be started to service a request, or was terminated as a result of a database system shutdown or a force command. SQLSTATE=55032


    My offline backup process is as follow,
    1.db2 force applications all
    2.db2 terminate
    3.db2 backup database <dbname> to /db2bkup

    Pls help me
    Thx very much.

  2. #2
    Join Date
    Nov 2003
    Location
    kualaumpur
    Posts
    33

    Re: Problem with offline backup

    Originally posted by chansteve1234
    Hi all
    I am using db2 V8 on red hat 7.3. I can do the online backup. But when i perform the offline backup. It will prompt following error,
    SQL1224N A database agent could not be started to service a request, or was terminated as a result of a database system shutdown or a force command. SQLSTATE=55032


    My offline backup process is as follow,
    1.db2 force applications all
    2.db2 terminate
    3.db2 backup database <dbname> to /db2bkup

    Pls help me
    Thx very much.
    its looks like db2 instance is stopped.

    try db2start then

    db2 backup database <dbname> to path

  3. #3
    Join Date
    Sep 2003
    Posts
    27
    The instance have been started, as the process have been follow,
    My offline backup process is as follow,
    0.db2start
    1.db2 force applications all
    2.db2 terminate
    3.db2 backup database <dbname> to /db2bkup

    The error have been the same.

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I sometimes get that error when I do a db2 force applications all and then immediately try to connect to the database. But when I connect again, it works. So you might try adding a db2 connect to database in the script (and ignore any error that might occur). This will not be a problem since the application agent that does the offline database backup can be connected to the database.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    Feb 2004
    Location
    Copenhagen
    Posts
    220

    Quiesce

    please try runnning the following commands in sequence:

    1. db2start
    2. connect to 'yourdb'
    3. quiesce database immediate force connections
    4. connect reset
    5. backup database 'yourdb' (to /x/x or use tsm)

    - wait till it displays backup successful then:

    6. connect to 'yourdb'
    7. unquiesce db
    8. connect reset

    Good Luck
    Kristian K. Hansen
    Project Supervisor
    National Board of Health

  6. #6
    Join Date
    Sep 2003
    Posts
    27
    thx very much, I have tried runnning the following commands in sequence:

    1. db2start
    2. connect to 'yourdb'
    3. quiesce database immediate force connections
    4. connect reset
    5. backup database 'yourdb' (to /x/x or use tsm)
    Following error displayed,
    SQL1035N The database is currently in use. SQLSTATE=57019

  7. #7
    Join Date
    Sep 2003
    Posts
    27
    Marcus_A


    Do u means after force appications all command,

    i wait for a while, and then type backup database <mydb> command???

  8. #8
    Join Date
    Sep 2003
    Posts
    27
    thx very much, I have tried runnning the following commands in sequence:

    1. db2start
    2. connect to 'yourdb'
    3. quiesce database immediate force connections
    4. connect reset
    5. backup database 'yourdb' (to /x/x or use tsm)
    Following error displayed,
    SQL1035N The database is currently in use. SQLSTATE=57019

  9. #9
    Join Date
    Sep 2003
    Posts
    27
    When i remove all the event monitor, the offline backup can be done.

    Then i try to stop the event monitor, and then perform backup, following error will be prompted,
    SQL1035N The database is currently in use. SQLSTATE=57019

    Can I not remove the event monitor, and perform offline backup?

  10. #10
    Join Date
    Sep 2003
    Posts
    27
    Thx all u very much.

    The problem seems have been solved.
    I config the event monitor as not start automatically, then the offline backup can be performed.

  11. #11
    Join Date
    May 2003
    Location
    Toronto
    Posts
    29
    thanks for sharing your solution.

Posting Permissions

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