By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,375 Members | 1,111 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,375 IT Pros & Developers. It's quick & easy.

Health Monitor - Manual Backup required...why?

P: 5
Hello,

The Database server = DB2/NT Workgroup Edition 8.2.8

Recently we configured the db to do online backups. After the initial full offline backup full online backups have been scheduled and they are successful.
But we keep getting the following health monitor message:

"Attention" alert for "db.db_backup_req" for "database" "DB2.AWSSV5 "

ADM10502W Health indicator "Database Backup Required" ("db.db_backup_req") is in state "Manual backup required" on "database" "DB2.AWSSV5 ".

Why is a manual backup required?

Do offline backups have to be done periodically even if we are do full online backups?

Anyone have ideas?! Please!!
Oct 21 '08 #1
Share this Question
Share on Google+
2 Replies


P: 9
The explanation for ADM10502W is as follows. Try recommendations and descriptions as suggested in the commands below.

(GET RECOMMENDATIONS FOR HEALTH INDICATOR Health-Indicator-Short-Name
GET DESCRIPTION FOR HEALTH INDICATOR Health-Indicator-Short-Name
)

ADM10502WHealth indicator Health-Indicator-Short-Description (Health-Indicator-Short-Name) is in state Health-Indicator-Value on Monitored-Object-Type Monitored-Object-Name.

Explanation
The health monitor generated an alert because the state value of this health indicator was non-normal. This condition does not necessarily require immediate attention, but rather it will depend on the expected state of the database given operations being performed on it at the time, and the prevailing workload.

User response
You can use one of the following tools to obtain recommendations, and in some cases take actions, to resolve this alert.

Health Center:

If the Control Center tools are installed, you can launch this tool in one of the following ways:

Start Menu on Windows
Control Center toolbar
command line as "db2hc"
Health indicator description, recommended actions, and links to tools to effect the actions are provided.

Command Line Processor (CLP):

From the CLP, you can obtain the Health indicator description and recommended actions by executing the following commands:
GET RECOMMENDATIONS FOR HEALTH INDICATOR Health-Indicator-Short-Name
GET DESCRIPTION FOR HEALTH INDICATOR Health-Indicator-Short-Name
Oct 21 '08 #2

P: 5
Thanks,

I will try this when I get the message/alter again and reply here.
Oct 21 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.