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

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.

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.

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

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

Marcus_A


Do u means after force appications all command,

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

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

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?

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.

thanks for sharing your solution.