473,387 Members | 1,365 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Health Monitor - Manual Backup required...why?

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
2 9602
kazam
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
mycita
5
Thanks,

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

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

Similar topics

7
by: Bruce MacDonald | last post by:
I am unable to see the health monitor SQL table functions (e.g.: SQLPROC.HEALTH_CONT_HI). Have I missed a utility which registers the functions? DB2 8.1.3.132 WR21324. Another point about the...
2
by: Debbie E | last post by:
Are there any issues with the Health Monitor in a partitioned environment? I have turned on the health monitor and can obtain the health snapshot for the DBM via the following command: get...
2
by: Mike | last post by:
Hellos again, I seem to be having a weird issue. Whenever DB2 Health monitor seems to run, all connections to the database seem to just lock up. For example: (and this seems consistent) In list...
0
by: nycjay | last post by:
i am trying to use the db2 health monitor alert to run a script. i set up the health monitor to run a script when the tablespace utailization is too high. in the end, the script should send a...
1
by: p175 | last post by:
Hi people, How can I reduce the amount of memory required to have the health monitor running. Presently whenever I start it I get endless out of memory errors in the db2diag.log when strictly...
1
by: rdudejr | last post by:
How often does the health monitor check the threshold of an indicator to see if there is a warning or alarm? I am trying to simulate the behaviour of the health monitor and have a dms tablespace...
1
by: bhd282 | last post by:
Regarding this message: ADM10502W Health indicator "Database Backup Required" ("db.db_backup_req") is in state "Automated backup failed" on "database" "db2inst2.WAREHOUS". Is there any place...
5
by: jbenner | last post by:
I have opened a PMR for this with IBM, and am not asking for advice from the DB2 DBA community. I am posting this as an FYI that DB2 Health Monitor, even at the latest version of DB2, still can cause...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.