DB2 Control Center Alarms

I am receiving the following messages within the DB2 control Centrer GUI for my database

DB2 Alarms

Shared sort heap threshold 0%

Attentions

dbtb_reorg_req
DB.Salary
DB.Salaryx
DB.Salaryxx
DB.Salaryxxx
fortress_frattonAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

momi_sabagCommented:
Hi

the shared sort heap threshold is a paramter that sets the amount of memory available for sort operations, i never saw the message you describe, but you can start off be check the value of that parameter

and about the attentions, i guess it means you need to run a reorg on the listed tablespaces
do you have any threshholds defined in the health center ?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
momi_sabagCommented:
hi

i could not find dbtb_reorg_req anywhere so i guess it's a threshold that someone defined in your site using the health center, can you check this issue ?
0
ghp7000Commented:
the shared sort heap threshold is a database parameter which you can see by doing:
db2 get db cfg for <database name> and looking at the value for sheapthres_shr. The value that has been configured is only used if:
if the intra_parallel database manager configuration parameter is set to yes, because when intra_parallel is set to no, there will be no shared sorts.
if the Concentrator is on (that is, when max_connections is greater than max_coordagents), because sorts that use a cursor declared with the WITH HOLD option will be allocated from shared memory.
So if that is your case, you have to allocate some memory to this parameter to avoid getting this message, or, turn off the alarm in the Health Center.
dbtb_reorg_req
DB.Salary
DB.Salaryx
DB.Salaryxx
DB.Salaryxxx
means reorganzie those tables or again, if you dont want to reorganize the tables, turn off the alarm in the Health Center
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
DB2

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.