Dynamic case creation based on output list from a command Post: 302655691

Sponsored Content

Operating Systems Linux Red Hat Dynamic case creation based on output list from a command Post 302655691 by slatoms on Wednesday 13th of June 2012 02:11:48 PM

06-13-2012

Registered User

Dynamic case creation based on output list from a command

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 instances could vary from server to server and I can't figure out how use the results from the db2ilist to create a case.

The output from db2ilist looks like this for example

[sslaton@Z11LD003 ~]$ db2ilist
dtrnd1
scgnd1
scgnd2
scgnd3
dtrnl1
scgnl1
scgnl2
scgnl3

I created a dumbed down version where I hard coded those instances to create a pick list to demonstrate what I'd like to do.

Code:

#!/bin/sh
echo "DB2 INSTANCE PROFILER UTILITY"
echo "1 = DTRND1"
echo "2 = SCGND1"
echo "3 = SCGND2"
echo "4 = SCGND3"
echo "5 = DTRNL1"
echo "6 = SCGNL1"
echo "7 = SCGNL2"
echo "8 = SCGNL3"
echo "Please enter the number of the instance you want to profile:\c"
read name

case $name in
 "1") . /dbhome/dtrnd1/sqllib/db2profile
      db2 get instance;;
 "2") . /dbhome/scgnd1/sqllib/db2profile
      db2 get instance;;
 "3") . /dbhome/scgnd2/sqllib/db2profile
      db2 get instance;;
 "4") . /dbhome/scgnd3/sqllib/db2profile
      db2 get instance;;
 "5") . /dbhome/dtrnl1/sqllib/db2profile
      db2 get instance;;
 "6") . /dbhome/scgnl1/sqllib/db2profile
      db2 get instance;;
 "7") . /dbhome/scgnl2/sqllib/db2profile
      db2 get instance;;
 "8") . /dbhome/scgnl3/sqllib/db2profile
      db2 get instance;;

     *) echo "Your did not pick a valid instance";;
esac

What I want to create is one script I can run on any server so I'm attempting to do something similar using the output of db2ilist. I can build the pick list, but I'm not sure how I can use that output to dynamically create a case.

Code:

#!/bin/sh
echo "DB2 INSTANCE PROFILER UTILITY"
ilist=$(db2ilist)
i='0'

for instance in $ilist
do
i=`expr $i + 1`
echo $i " = " $instance



done

posted to wrong thread by accident. I apologize. If you feel like you can help please reply to the post in the correct thread

https://www.unix.com/shell-programmin...#post302655695

Last edited by slatoms; 06-13-2012 at 03:23 PM.. Reason: posted to wrong thread

slatoms

View Public Profile for slatoms

Find all posts by slatoms

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Creation of log file under dynamic date folder

HI I want to create a date folder and then a log file under it, which will hold all output of shell script. Say shell script abc.sh runs every day and I want to redirect the output of abc.sh > /opt/bea/wls81/Pkmtest/$(date +%Y%m%d)/ant.log. Here date should always change according to system...

2. Shell Programming and Scripting

Creation of output file from list of file

Hi Guru's, Eventhough I know basic shell scripting, Iam not an expert. Can any one help me to get a logic/answer for the below requirement: I've to create an output file "outputfile.txt" from many datafiles (ex: abc.dat, xyz.dat). Header record layout for "outputfile.txt" should be...

3. Shell Programming and Scripting

Creating a dynamic case statement

I'm using the korn shell and trying to create a case statement from the contents of a file that is changed regularly, each line of the file has three fields, eg track1 202.111.111.111 99 room7 222.111.222.333 76 I'm using awk to select each variable. I've been unable to figure out how to...

4. UNIX for Advanced & Expert Users

Dynamic file creation

This my script ls *.ksh ls *.ksh > a.txt i=1 cat "a.txt" | while read a do if then echo "abc" echo "abc" > m.ksh echo "m.ksh" >> a.txt i=2 fi echo $a done ls *.ksh -------------------------- My Output is a.ksh - > first ls *.ksh

5. Shell Programming and Scripting

Parsing dynamic data from a command output

Hi people, I am writing a korn shell script, and one of the command gives an output something like below: release.label.2010.03.02 objects: /project/path/to/some/file_name.ksh /project/path/another/file_name01.dat I have to retrieve the file paths one by one & use them as...

6. Shell Programming and Scripting

Conversion from Upper Case to Lower Case Condition based

Hello Unix Gurus : It would be really appreciative if can find a solution for this . I have records in a file . I need to Capitalize the records based on condition . For Example i tried the following Command COMMAND --> fgrep "2000YUYU" /export/home/oracle/TST/data.dat | tr '' ''...

7. Shell Programming and Scripting

Dynamic case creation based on output list from a command

8. Red Hat

Command understanding the output file destination in case of standard output!!!!!

I ran the following command. cat abc.c > abc.c I got message the following message from command cat: cat: abc.c : input file is same as the output file How the command came to know of the destination file name as the command is sending output to standard file.

9. UNIX for Dummies Questions & Answers

Select all files in a folder based on creation date (ls command)

Hi All, <Re-posting in Correct group> I'm trying to select all the files in a folder that starts with a particular name format and are created in a gven date range using 'ls' command...but i'm not successful.... Example : I'm trying to see all the text files in a folder who names start...

10. UNIX for Dummies Questions & Answers

Dynamic Variable creation

I am trying to create some variables based on the input by the user, say if user entered 3 then 3 variables and if 5 then 5 variables. I am using a for loop for (( i=1; i <= $num; i++ )) do x="num" x+=$i done When i am using echo $x it will show num1 but now how to create variables...

LEARN ABOUT DEBIAN

ocf_heartbeat_db2

OCF_HEARTBEAT_DB2(7)						OCF resource agents					      OCF_HEARTBEAT_DB2(7)

NAME

       ocf_heartbeat_db2 - Resource Agent that manages an IBM DB2 LUW databases in Standard role as primitive or in HADR roles as master/slave
       configuration. Multiple partitions are supported.

SYNOPSIS

       db2 [start | stop | monitor | promote | demote | meta-data | validate-all]

DESCRIPTION

       Resource Agent that manages an IBM DB2 LUW databases in Standard role as primitive or in HADR roles in master/slave configuration. Multiple
       partitions are supported.

       Standard mode:

       An instance including all or selected databases is made highly available. Configure each partition as a separate primitive resource.

       HADR mode:

       A single database in HADR configuration is made highly available by automating takeover operations. Configure a master / slave resource
       with notifications enabled and an additional monitoring operation with role "Master".

       In case of HADR be very deliberate in specifying intervals/timeouts. The detection of a failure including promote must complete within
       HADR_PEER_WINDOW.

       In addition to honoring requirements for crash recovery etc. for your specific database use the following relations as guidance:

       "monitor interval" < HADR_PEER_WINDOW - (appr 30 sec)

       "promote timeout" < HADR_PEER_WINDOW + (appr 20 sec)

       For further information and examples consult http://www.linux-ha.org/wiki/db2_(resource_agent)

SUPPORTED PARAMETERS

       instance
	   The instance of the database(s).  (unique, required, string, no default)

       dblist
	   List of databases to be managed, e.g "db1 db2". Defaults to all databases in the instance. Specify one db for HADR mode.  (optional,
	   string, no default)

       admin
	   DEPRECATED: The admin user of the instance.	(optional, string, no default)

       dbpartitionnum
	   The number of the partion (DBPARTITIONNUM) to be managed.  (optional, string, default 0)

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.

       promote
	   Promotes the resource to the Master role. Suggested minimum timeout: 120.

       demote
	   Demotes the resource to the Slave role. Suggested minimum timeout: 120.

       notify
	   Suggested minimum timeout: 10.

       monitor
	   Performs a detailed status check. Suggested minimum timeout: 60. Suggested interval: 20.

       monitor (Master role)
	   Performs a detailed status check. Suggested minimum timeout: 60. Suggested interval: 22.

       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.

EXAMPLE

       The following is an example configuration for a db2 resource using the crm(8) shell:

	   primitive p_db2 ocf:heartbeat:db2 
	     params 
	       instance=string 
	     op monitor depth="0" timeout="60" interval="20" 
	     op monitor depth="0" timeout="60" role="Master" interval="22"

	   ms ms_db2 p_db2 
	     meta notify="true" interleave="true"

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 UNKNOWN 					    03/09/2014						      OCF_HEARTBEAT_DB2(7)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Creation of log file under dynamic date folder

Discussion started by: pankajkrmishra

2. Shell Programming and Scripting

Creation of output file from list of file

Discussion started by: ganapati

3. Shell Programming and Scripting

Creating a dynamic case statement

Discussion started by: squrcles

4. UNIX for Advanced & Expert Users

Dynamic file creation

Discussion started by: kingganesh04