Hi,
I need a shell script for displaying instance names,database names and database alias names which are presenting in a particular instance(only Local databases) and port numbers in a tabular form.I had written a shell script for this but it is not displaying all alias names for databases(only 1st alias name its showing).If anybody is having it already please help me.

I'm showing the structure by indenting but we just need a flat file generated in table-like format:

> Server Name and IP Address
- DB2 Instance Name and Port Number
+ Database Name and Alias
+ Database Name and Alias
+ etc

- Next DB2 Instance Name and Port Number
+ Database Name and Alias
+ etc
- Etc...

Thanks&Regards

Bade

Can you post the script please ? Also specify where you are facing the problem.


Cheers
Sathyaram

Hi Satyaram thanks for ur quick reply

I'm executing the below command :
1. db2 list db directory

Output:

Database 1 entry:

Database alias = SAMP
Database name = SAMPLE
Local database directory = /db2samp1
Database release level = b.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =

Database 2 entry:

Database alias = DBWEB
Database name = DBWEB
Local database directory = /db2samp1
Database release level = b.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =

Database 3 entry:

Database alias = DBPORT
Database name = DBPORT
Local database directory = /db2samp1
Database release level = b.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =

Database 2 entry:

Database alias = SAMPLE
Database name = SAMPLE
Local database directory = /db2samp1
Database release level = b.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =



Basing on "Local database directory" of the above output, i'm executing the below command:

2. db2 list db directory on /db2samp1 | egrep -i -e "Database alias"

Output:

DBWEB
DBPORT
SAMPLE


Here it should also display the SAMP database alias name but it is not displaying that alias.

Thanks in advance
Bade

will do the trick

Thanks Sathyaram
It really help me a lot in modifying the script.