SAP & DB2 Process Monitoring Parameters

 
Thread Tools Search this Thread
Special Forums UNIX and Linux Applications SAP & DB2 Process Monitoring Parameters
# 1  
Old 11-18-2014
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
# 2  
Old 11-19-2014
Quote:
Originally Posted by marunmeera
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
What do you mean by "capture shutdown, restart & Halt status"? It is realatively easy to find out if SAP is running or not, but to find out in which state the running software is you would need access to ot (via SAPGui, Web dispatcher or similar means). This might - depending on what you want to monitor exactly - not be feasible within a script.

Similar for DB/2. A look into the process list with "ps" tells you if DB/2 is started or not, but to tell if it is running normally or if only the dabase manager is started for a TSM backup or .... you will need to access the DB software itself.


So please specify what exactly you want to know and which means to find out you have at your disposal. Further, tell a bit more detail about your SAP instance: do you have an ABAP instance only, a JAVA stack too and, if the latter is the case, a web dispatcher instance on top?

I hope this helps.

bakunin
This User Gave Thanks to bakunin For This Post:
# 3  
Old 11-20-2014
Thanks Bakunin for your reply.

We were using a performance monitoring tool, my query is what are the parameters (Services or Process) need to configure on monitoring to capture the instance like shutdown, restart or halt status of SAP & DB2.

Hope I clarified in depth.
# 4  
Old 11-20-2014
Quote:
Originally Posted by marunmeera
Thanks Bakunin for your reply.

We were using a performance monitoring tool, my query is what are the parameters (Services or Process) need to configure on monitoring to capture the instance like shutdown, restart or halt status of SAP & DB2.

Hope I clarified in depth.
Sorry, but this still doesn't make sense for me.

A "performance monitoring tool" will tell you how many resources - processors, RAM, whatever - is consumed (by an application) at a certain point in time. You won't be able to monitor the application status with such a tool for the same reason why you can't measure a length with a watch - its the wrong measurement instrument.

How about you tell us which "performance monitoring tool" you are going to use and maybe we can work out something.

For instance, here is how you can test if a (DB/2)-DB is available for SAP: change to the "sidadm" user of the ABAP instance and run the following command. If the output is as shown (the important part is the "0000") then the DB is available

Code:
sidadm@saphost > R3trans -d | tail -n 1
R3trans finished (0000).

I use this in my scripts the following way:

Code:
[...]
chOut="$(su - "${chUser}" -c "R3trans -d" | tail -n 1)"
chOut="${chOut%\)*}"
chOut="${chOut#*\(}"

if [ "$chOut" == "0000" ] ; then
     print - "INFO: Database available"
else
     print -u2 - "ERROR: Database failed to start. Aborting....
fi
[....]

I hope this helps.

bakunin
This User Gave Thanks to bakunin For This Post:
Login or Register to Ask a Question

Previous Thread | Next Thread

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Monitoring processes in parallel and process log file after process exits

I am writing a script to kick off a process to gather logs on multiple nodes in parallel using "&". These processes create individual log files. Which I would like to filter and convert in CSV format after they are complete. I am facing following issues: 1. Monitor all Processes parallelly.... (5 Replies)
Discussion started by: shunya
5 Replies

2. Shell Programming and Scripting

need help with a process monitoring script

GM everyone, I have this script that goes to multiple servers and monitor a certain process and send the output to a file on servers1, the script looks like this exec < server.list while read SERVER do ssh $SERVER "ps -ef | grep process_name" >> /tmp/report done can someone help ad... (0 Replies)
Discussion started by: baders
0 Replies

3. UNIX for Dummies Questions & Answers

AIX & DB2 paging issues

AIX & DB2 paging issues Hello I needs some help on AIX & DB2 paging issues. Recently a db2 query caused paging issues which then lead to memory problems and a server restart. Is there anyway of finding out what db2 queries were causing the problem.. Thanks in advance (2 Replies)
Discussion started by: nedkao
2 Replies

4. AIX

Aix hacmp cluster question (oracle & sap)

Hello, I was wondering if I have 3 nodes (A, B, C) all configured to startup with HACMP, but I would like to configure HACMP in such a way: 1) Node B should startup first. After the cluster successfully starts up and mounts all the filesystems, then 2) Node A, and Node C should startup ! ... (4 Replies)
Discussion started by: filosophizer
4 Replies

5. Shell Programming and Scripting

process monitoring

hi all, i would like to write the shell script to monitoring the processing, but if i passing the parameter the number of process is incorrect how to slove it? many thx got the correct number of process as following script: ===========================================================... (3 Replies)
Discussion started by: eric_wong_ch
3 Replies

6. Shell Programming and Scripting

DB2 stored procedure (with input parameters) from script

I have a db2 stored procedure on my database which require 3 parameters, I have the following db2 command in a sql script CONNECT TO SAMPLE; CALL BACKUP(INPUT_1, INPUT_2, INPUT3); Usually, I would just invoke this sql script from my shell script like below db2 -tf... (1 Reply)
Discussion started by: mpang_
1 Replies

7. AIX

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... (0 Replies)
Discussion started by: sprellari
0 Replies

8. HP-UX

alias & parameters

We just recently moved from a DG-UX (Unix V) to HP 9000 servers running POSIX. I used the c-shell in the DG-UX system mainly because the bourne-shell did not support aliasing. Now in the default posix-shell of HP aliasing is supported. The main difference seams to be that in a c-shell you can pass... (1 Reply)
Discussion started by: vslewis
1 Replies
Login or Register to Ask a Question