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
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
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 Replies)
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... (7 Replies)
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... (5 Replies)
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 (1 Reply)
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... (9 Replies)
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 '' ''... (12 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)
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. (3 Replies)
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... (6 Replies)
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... (3 Replies)
Discussion started by: Raj999
3 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)