I was just wondering if you could help me out with this query -

I have an instance created within which you have 3 databases say A , B and C.
I have a Stored Procedure created in A say A.proc1.I have a requirement where I have to update some tables in B and C database.
Is it possible to select or update any table from B or C database in this procedure where the procedure is been created in A database ?

You can update data in B or C or A, but not in more than one of the databases in the same UOW. Two phase commit support for Federation is coming in V9.

BTW, if you are new to DB2, search for Federated Database in the documentation . This presentation might help

http://www.gseukdb2.org.uk/downloads/0506federation.zip

Sathyaram