Login or Register to Ask a Question and Join Our Community


AIX

DB2 Monitoring

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Operating Systems AIX DB2 Monitoring
# 1  
Old 05-30-2006
DB2 Monitoring
Hi everyone.

I am currently looking for a monitor to monitor my DB2 UDB database, which runs on AIX 5.3. Does anyone here use any good ones or has anyone heard of any good ones?

I especially need to monitor which applications run at any given time, so that I am able to ballance the workload by my applications better.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

DB2 in awk

Hi, I want to retrieve the base table name for a table and replace the table with the view name in the file. I was trying to retrieve the base with the below db2 command but i am getting "1" as return value. Could you anyone please assist ? Table_name=system("db2 -x... (4 Replies)
Discussion started by: Nandy
4 Replies

2. UNIX and Linux Applications

SAP & DB2 Process Monitoring Parameters

What are the parameters ((i.e., Process & Services) need to monitor for SAP & DB2 to capture shutdown, restart & Halt status of those applications. Please suggest the best practices. Ex: SAPSTART for SAP & DP2SYS for DB2 (3 Replies)
Discussion started by: marunmeera
3 Replies

3. Shell Programming and Scripting

Db2 query on other host

Hello, i need some help with a script. I made a script, which connect to different hosts to get some informations. But i got now some problems with getting informations of a database (db2) which is on a other host. I tried something like var=$(rsh HOST su - db2adm -c "db2 connect to database;... (2 Replies)
Discussion started by: Cyver
2 Replies

4. AIX

DB2 high CPU

Hello dear friends, I have Lpar AIX 6.1 and there is DB2 installed. I have 8 Virtual CPU's configured on my Lpar and when I run nmon the CPU waiting time is always big.. I will provide screenshot for better realizing.. my question is what may produce so big waiting time?? Thanks in advance! (19 Replies)
Discussion started by: Vit0_Corleone
19 Replies

5. Shell Programming and Scripting

Connect db2 using db2 connect

I want to connect to DB2 database which is mainframes using a unix script and run query and get the result set into the unix box. Is this acheivable using db2 connect? pls help me with a sample script which can perform the same. (1 Reply)
Discussion started by: midhun19
1 Replies

6. AIX

AIX Tuning For DB2

Dear friends. can anybody suggest me what to be considered in order to achieve maximum performance of AIX on which DB2 will be installed Thanks is advance :) (1 Reply)
Discussion started by: Vit0_Corleone
1 Replies

7. AIX

DB2 basics

Dear friends I am going to study DB2 and i dont have any experience with any DB's.. Please provide me with some links or pdf's for DB2 starters. any advice will be very usefull (2 Replies)
Discussion started by: Vit0_Corleone
2 Replies

8. Shell Programming and Scripting

db2

i want to run a db2 query though shell script but i want my where condition element to chnage everytime like class_nm='abc' next time class_nm='def' next time i want it to do by passing parameters to unix script can someone give example how can i do it (0 Replies)
Discussion started by: er_zeeshan05
0 Replies

9. UNIX for Dummies Questions & Answers

Exception while loading DB2 driver Class.forName("com.ibm.db2.jcc.DB2Driver")

Hi... I m working on UNIX z/OS. Actually i have to pass the parameters from the JCL to java-db2 program thru PARM. I am able to pass the arguments but the problem occured is, it is throwing an exception while loading the db2 driver as 'Javaclassnotfound:com.ibm.db2.jcc.DB2Driver'... (0 Replies)
Discussion started by: Sujatha Gowda
0 Replies

10. Shell Programming and Scripting

for loop with db2 command

Having some trouble with usage of for loop and displaying words. Basically I had 3 words( some times more ) in the variable. I want to get one at a time to process. I am new to unix scripting so please bear with my question and appreciate your reply. I think this can also me done my awk... (1 Reply)
Discussion started by: Vaddadi
1 Replies
Login or Register to Ask a Question

LEARN ABOUT SUSE

ocf_heartbeat_db2

OCF_HEARTBEAT_DB2(7)						OCF resource agents					      OCF_HEARTBEAT_DB2(7)

NAME

       ocf_heartbeat_db2 - Manages an IBM DB2 Universal Database instance

SYNOPSIS

       db2 [start | stop | status | monitor | validate-all | meta-data | methods]

DESCRIPTION

       Resource script for db2. It manages a DB2 Universal Database instance as an HA resource.

SUPPORTED PARAMETERS

       instance
	   The instance of database. (required, string, no default)

       admin
	   The admin user of the instance. (optional, string, no default)

SUPPORTED ACTIONS

       This resource agent supports the following actions (operations):

       start
	   Starts the resource. Suggested minimum timeout: 120.

       stop
	   Stops the resource. Suggested minimum timeout: 120.

       status
	   Performs a status check. Suggested minimum timeout: 60.

       monitor
	   Performs a detailed status check. Suggested minimum timeout: 60. Suggested interval: 10.

       validate-all
	   Performs a validation of the resource configuration. Suggested minimum timeout: 5.

       meta-data
	   Retrieves resource agent metadata (internal use only). Suggested minimum timeout: 5.

       methods
	   Suggested minimum timeout: 5.

EXAMPLE

       The following is an example configuration for a db2 resource using the crm(8) shell:

	   primitive example_db2 ocf:heartbeat:db2 
	     params 
	       instance=string 
	     op monitor depth="0" timeout="60" interval="10"

SEE ALSO

       http://www.linux-ha.org/wiki/db2_(resource_agent)

AUTHOR

       Linux-HA contributors (see the resource agent source for information about individual authors)

resource-agents 1.0.3						    07/05/2010						      OCF_HEARTBEAT_DB2(7)