In Optim z/OS 11.3 using DB2, I've a situation wherein parent table along with some children are in one DB2 region and some more children in another DB2 region. I tried using three part name in AD like REMOTE_<reg2>.<owner>.<tablename> but it said table is unknown. In the site options, we have following setting:
Remote DB2 Connection ===> S A-Application, S-System
Has anybody dealt with the same issue and how it was handled? Any help on this topic will be appreciated.