SAP & DB2 Process Monitoring Parameters Post: 302925920

Sponsored Content

Special Forums UNIX and Linux Applications SAP & DB2 Process Monitoring Parameters Post 302925920 by bakunin on Thursday 20th of November 2014 07:53:27 AM

11-20-2014

Registered User

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:

bakunin

View Public Profile for bakunin

Find all posts by bakunin

8 More Discussions You Might Find Interesting

1. 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...

2. 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...

3. 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...

4. 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: ===========================================================...

5. 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 ! ...

6. 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

7. 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...

8. 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....

LEARN ABOUT PHP

db2_close

DB2_CLOSE(3)								 1							      DB2_CLOSE(3)

db2_close - Closes a database connection

SYNOPSIS

       bool db2_close (resource  $connection)

DESCRIPTION

	This function closes a DB2 client connection created with db2_connect(3) and returns the corresponding resources to the database server.

	If  you  attempt to close a persistent DB2 client connection created with db2_pconnect(3), the close request is ignored and the persistent
       DB2 client connection remains available for the next caller.

PARAMETERS

	      o $connection
		- Specifies an active DB2 client connection.

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

EXAMPLES

       Example #1

	      Closing a connection

	       The following example demonstrates a successful attempt to close a connection to an IBM DB2, Cloudscape, or Apache Derby database.

	      <?php
	      $conn = db2_connect('SAMPLE', 'db2inst1', 'ibmdb2');
	      $rc = db2_close($conn);
	      if ($rc) {
		  echo "Connection was successfully closed.";
	      }
	      ?>

	      The above example will output:

	      Connection was successfully closed.

SEE ALSO

       db2_connect(3), db2_pclose(3), db2_pconnect(3).

PHP Documentation Group 													      DB2_CLOSE(3)