Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: SAP & DB2 Process Monitoring Parameters
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
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:
marunmeera
 

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... (1 Reply)
Discussion started by: vslewis
1 Replies

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

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... (1 Reply)
Discussion started by: mpang_
1 Replies

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: ===========================================================... (3 Replies)
Discussion started by: eric_wong_ch
3 Replies

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 ! ... (4 Replies)
Discussion started by: filosophizer
4 Replies

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 (2 Replies)
Discussion started by: nedkao
2 Replies

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

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

LEARN ABOUT DEBIAN

sql::reservedwords::db2

SQL::ReservedWords::DB2(3pm)				User Contributed Perl Documentation			      SQL::ReservedWords::DB2(3pm)

NAME

       SQL::ReservedWords::DB2 - Reserved SQL words by DB2

SYNOPSIS

	  if ( SQL::ReservedWords::DB2->is_reserved( $word ) ) {
	      print "$word is a reserved DB2 word!";
	  }

DESCRIPTION

       Determine if words are reserved by DB2.

METHODS

       is_reserved( $word )
	   Returns a boolean indicating if $word is reserved by either DB2 5, 6, 7 or 8.

       is_reserved_by_db2v5( $word )
	   Returns a boolean indicating if $word is reserved by DB2 5.

       is_reserved_by_db2v6( $word )
	   Returns a boolean indicating if $word is reserved by DB2 6.

       is_reserved_by_db2v7( $word )
	   Returns a boolean indicating if $word is reserved by DB2 7.

       is_reserved_by_db2v8( $word )
	   Returns a boolean indicating if $word is reserved by DB2 8.

       reserved_by( $word )
	   Returns a list with DB2 versions that reserves $word.

       words
	   Returns a list with all reserved words.

EXPORTS

       Nothing by default. Following subroutines can be exported:

       is_reserved
       is_reserved_by_db2v5
       is_reserved_by_db2v6
       is_reserved_by_db2v7
       is_reserved_by_db2v8
       reserved_by
       words

SEE ALSO

       SQL::ReservedWords

       <http://www-306.ibm.com/software/data/db2/udb/>

AUTHOR

       Christian Hansen "chansen@cpan.org"

COPYRIGHT

       This program is free software, you can redistribute it and/or modify it under the same terms as Perl itself.

perl v5.8.8							    2008-03-28					      SQL::ReservedWords::DB2(3pm)
All times are GMT -4. The time now is 12:04 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy