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)
Check Out this Related Man Page
OCF_HEARTBEAT_AUDIBL(7) OCF resource agents OCF_HEARTBEAT_AUDIBL(7)NAME
ocf_heartbeat_AudibleAlarm - Emits audible beeps at a configurable interval
SYNOPSIS
AudibleAlarm [start | stop | status | monitor | meta-data | validate-all]
DESCRIPTION
Resource script for AudibleAlarm. It sets an audible alarm running by beeping at a set interval.
SUPPORTED PARAMETERS
nodelist
The node list that should never sound the alarm. (optional, string, no default)
SUPPORTED ACTIONS
This resource agent supports the following actions (operations):
start
Starts the resource. Suggested minimum timeout: 10.
stop
Stops the resource. Suggested minimum timeout: 10.
restart
Suggested minimum timeout: 10.
status
Performs a status check. Suggested minimum timeout: 10. Suggested interval: 10.
monitor
Performs a detailed status check. Suggested minimum timeout: 10. Suggested interval: 10.
meta-data
Retrieves resource agent metadata (internal use only). Suggested minimum timeout: 5.
validate-all
Performs a validation of the resource configuration. Suggested minimum timeout: 5.
EXAMPLE
The following is an example configuration for a AudibleAlarm resource using the crm(8) shell:
primitive p_AudibleAlarm ocf:heartbeat:AudibleAlarm
op monitor depth="0" timeout="10" interval="10"
SEE ALSO
http://www.linux-ha.org/wiki/AudibleAlarm_(resource_agent)
AUTHOR
Linux-HA contributors (see the resource agent source for information about individual authors)
resource-agents UNKNOWN 03/09/2014 OCF_HEARTBEAT_AUDIBL(7)
I'm writing this script in Korn Shell, on AIX. The script will print a log file, and it needs to decide what region it's in before printing.
( the output of db2 "get instance" is either
"The current database manager instance is: db2q" or
"The current database manager instance is: db2u")
... (6 Replies)
Hi Guys,
I'm working on a AIX 5.3 environment and I've been quite a few times in a situation where we can remove db2 orphan processes therefore our only alternative has been to reboot the entire server. Now I wonder is there is any other possible way that we can use to remove those processes... (5 Replies)
My Korn shell script below is giving me the following error: ./test.ksh: 0403-057 syntax error at line 7 : 'then' is not matched.
Can anyone provide a quick solution as to why the error is occurring? Thanks.
#!/usr/bin/ksh
typeset -i RecCount
typeset -i RecCount2
RecCount=`db2 -x "select... (23 Replies)
Hi,
When i try to connect to the db2 database from unix solaris 5.8 version by typing "db2" from the .../sqllib/bin/ folder, i am not getting the db2 command prompt. Could anyone help me resolve this? Here the db2 is executable only. But still iam not getting the db2 prompt.
The error i get is... (4 Replies)
Hi All,
I am trying to write a small shell programming to get db2 database size info. The command I am going to use is- db2 "CALL GET_DBSIZE_INFO(?, ?, ?, -1)"
and the output of above command generally is-
Value of output parameters
--------------------------
Parameter Name :... (4 Replies)
hi,
when I do a failover, hacmp always starts db2 but recently it fails to start db2..noticed the issue is db2nodes.cfg is not modified by hacmp and is still showing primary node..manually changed the node name to secondary after which db2 started immediately..unable to figure out why hacmp is... (4 Replies)
I am attempting to create a script that would allow me to list all the instances associated with a DB2 and then prompt the user to choose which one to issue the db2profile command against. I use the db2 command db2ilist to get a list of the instances for a particular server, but the number of... (7 Replies)
Hi,
I'm a first timer with Unix so pardon my ignorance.
I'm trying to read a comma separated file from the same folder where the script is and insert the value in a DB2 table.
I'm using AWK for the same. I'm getting `)' not expected error.
I'm not sure but for me it doesn't look like detailed... (8 Replies)
I have written a shell script to calculate dbsize :-
db2 "call get_dbsize_info(?,?,?,-1)" | sed -n '8p' | awk -F : '{print $2}'
dbsize=`db2 "call get_dbsize_info(?,?,?,-1)" | sed -n '8p' | awk -F : '{print $2}'`
echo $dbsize
when I execute it the syntax works but it's not... (11 Replies)
Hi Folks,
I am using db2 command -> db2 list tablespace show detail
Tablespace ID = 10
Name = TSCDDHLMSUM
Type = Database managed space
Contents = All permanent data.... (5 Replies)
Hi Team,
I have created a script to output DB Query data to a text file. It displays output as follows for 2 different queries appended to same file.
I want help to convert this data to xls format so that the output of first query is in 1 tab and the other in second tab. Please help.
... (14 Replies)
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)
Hi all, I have a script that I will need to run occasionally to stop my db2 instance-
stopDB2.sh
su -l -c "db2 force application all"
su -l -c "db2 terminate"
su -l -c "db2 stop"
su -l -c "db2licd -end"
This works when I su to the instance owner (archive), and run each line. I need to... (5 Replies)
I am using DB2 v9 and trying to get country values in comma seperated format using below query
SELECT distinct LISTAGG(COUNTRIES, ',') WITHIN GROUP(ORDER BY EMPLOYEE)
FROM LOCATION ;
Output Achieved
MEXICO,UNITED STATES,INDIA,JAPAN,UNITED KINGDOM,MEXICO,UNITED STATES
The table... (4 Replies)