Hi All,

In a shell script I'm trying to export the instance names sequencially from a file.

while read line
do
if [ -f /home/$line/sqllib/db2profile ]; then
. /home/$line/sqllib/db2profile

export DB2INSTANCE=$line

db2 "get instance"

done < instance.list

instance.list consists of all the instance names in the server.


I want to display different values for db2 "get instance" depending on the instance name.

Thanks in advance
Sekhar Bade

Why do you want to do this? If you want to list all the instances, just use db2ilist.

Looking at your script, I notice you do not have an end to you if statement.

Andy

Also, you need to issue the DB2 TERMINATE command after changing DB2INSTANCE.

and line
db2 "get instance"

should be

db2 get instance >> instance.list



but Andy is right

Thanks for all your respone,i issued DB2 TERMINATE command after changing DB2INSTANCE as per my requirement.it help me a lot in the shell script.thanks nick.

Warm Regards
BADE

I wonder what is the purpose of all this. All that GET INSTANCE does is display the contents of the DB2INSTANCE environment variable, and you set it from a list of instances, so you could just as well replace your entire script with "cat instance.list"...