Hi

How to insert by select between two subsystems.

insert into dbxx.table1 --> sub system dbxa, TSO1
select * from dbyy.table1 --> sub system dbya, TSO2

ofcouse the above will not work, as both of them belong to different system.

Please advise, whether we can do like this or not.
This is just to avoid unload and load.

Advise on any chance to do using insert and select

One way to do this is to access the other DB2 subsystem on OS/390 using DDF (distributed data facitliy). Check out DDF in the manuals. DDF would need to be enabled by your DB2 systems programmer.