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.
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) .