Dynamic Plan Selection - DB2

pravinj · New User Joined: 10 Jun 2008 Posts: 24 Location: india

Is there any possibility of accessing tables in different regions from the same module?

Say,I need to extract a row from DLSFB.XXXXX table and i want to move it to another table in a different region, say DLSF2.XXXXX in the same module. If it's different databases within a region, common plans are available in our system to access different databases, but in case of using different regions's DBs, i couldn't find a way! Help me out.

Thanks in Advance!

senthilssg · New User Joined: 09 Dec 2005 Posts: 64 Location: USA

Hi ,

You can create the alias on local DB2 subsystem for table which is in remote (different) DB2 system . So you can write the program as like to access the tables from same region . DB2 system will use DRDA connection when it access the alias (which is created for remote table) .

Thanks
Senthil