Need to check long running processes on the database server and the os is AIX Post: 302885766

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Script to check running processes on remote server.

Hi, I am trying to write a script, which queries a db to get the names of processes, stores it in a file and then checks if that process is running on a remote server. However I am not getting it right, could anyone help me out. #!/bin/sh echo "select Address from Device where Cust =...

2. UNIX for Advanced & Expert Users

how to check how long the process has been running.

I have a requirement to check how long a process is running on unix system.If i use ps -ef i am getting the following message guest 2453638 1998920 0 16:16:05 - 0:00 dsapi_slave 9 8 0 but this is showing only time not the date.Can any one please advice me any script to find out how...

3. UNIX for Advanced & Expert Users

How to check since when (for how long) a particular process is running ?

How do I check if a particular process is running from a certain date and time ?

4. Shell Programming and Scripting

Script for long running processes....

I searched the forums but didn't see anything related to what I'm looking for. I need a script that would give me a listing of jobs running longer than, for example, 12 hours or so. Thanks in advance for your assistance!!

5. Shell Programming and Scripting

determine the active processes on the system which are running since long time

Hi , Please help me shell script to determine the active processes on the system which are running since long time

6. AIX

How to Identify long running unix processes

Hi All, Need an urgent help, I have a requirement to find long running unix processes.. I have tried the below commands, but not succeed. I need to arrange the unix processess in an order of elapsed time (high to low) that runs in a system. For Eg: Consider we have 3 processes, Pid 1 pid 2...

7. Shell Programming and Scripting

Quick question about finding the PID of long-running processes

The end result that I'd like is to terminate any process on my ps -u username list that extends beyond 20 minutes. I know for a fact that this process will be named l.exe, but I don't know the number in between and I won't know the PID. Is there a way to use grep or pidof to do this task every 20...

8. Shell Programming and Scripting

Check for long running process on AIX

I want to write a shellscript which determines if a particular process is long running than my specified threshold time. Eg: My process name is "prsd" and is expected to run for 15 mins and completes. If I set a threshold limit of 1 hour, and how we can the get output of the long running...

9. Shell Programming and Scripting

Check Running Processes

I want to check how many processes are running with same names and get their respective counts. ps -ef|grep -Eo 'process1|process2|process3| '|sort -u | awk '{print $2": "$1}' Output would look like : $ ps -ef|grep -Eo 'process1|process2|process3| '|sort | uniq -c | awk '{print $2":...

10. UNIX for Beginners Questions & Answers

Check processes running on remote server

Hello Guys, I need some help to find out if processes are running on remote server or not. I could do 'ssh' to do that but due to some security reasons, I need to avoid the ssh & get result from remote server. Could you please suggest some that can be done without ssh or similar sort of...

LEARN ABOUT PHP

fbsql_db_status

FBSQL_DB_STATUS(3)							 1							FBSQL_DB_STATUS(3)

fbsql_db_status - Get the status for a given database

SYNOPSIS

       int fbsql_db_status (string  $database_name, [resource  $link_identifier])

DESCRIPTION

	Gets the current status of the specified database.

PARAMETERS

	      o $database_name
		- The database name.

	      o $
		link_identifier  -A FrontBase link identifier returned by fbsql_connect(3) or fbsql_pconnect(3).If optional and not specified, the
		function will try to find an open link to the FrontBase server and if no such link is found it	will  try  to  create  one  as	if
		fbsql_connect(3) was called with no arguments.

RETURN VALUES

	Returns an integer value with the current status. This can be one of the following constants:

	      o FALSE - The exec handler for the host was invalid. This error will occur when the $link_identifier connects directly to a database
		by using a port number. FBExec can be available on the server but no connection has been made for it.

	      o FBSQL_UNKNOWN - The Status is unknown.

	      o FBSQL_STOPPED - The database is not running. Use fbsql_start_db(3) to start the database.

	      o FBSQL_STARTING - The database is starting.

	      o FBSQL_RUNNING - The database is running and can be used to perform SQL operations.

	      o FBSQL_STOPPING - The database is stopping.

	      o FBSQL_NOEXEC - FBExec is not running on the server and it is not possible to get the status of the database.

SEE ALSO

       fbsql_start_db(3), fbsql_stop_db(3).

PHP Documentation Group 													FBSQL_DB_STATUS(3)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Script to check running processes on remote server.

Discussion started by: amitsayshii

2. UNIX for Advanced & Expert Users

how to check how long the process has been running.

Discussion started by: ukatru

3. UNIX for Advanced & Expert Users

How to check since when (for how long) a particular process is running ?

Discussion started by: hpuxlxboy

4. Shell Programming and Scripting

Script for long running processes....

Discussion started by: CyberOptiq