how can we establish connection to single DB2 system from multiple CPUs , I have simulated the process below
D1 is the DB2 sub system of MVS present in CPUX and I need to run a job in CPUY, the job from CPUY should be connected to D1 in CPUX and fetch some data and do the processing . Please give me some suggetion how establish the DB2 connection ..
The connections between multiple db2 subsystems on different Z/OS is established through DRDA protocols.If you want your job on substem A(requester) to access data from substem B(server) on a different Z/os, all you have to do is create a package on the server side where the SQL statements would be executed and of course create a local package for the program(on the requester side). These two bind commands can be issued from the requester subsytem itself once with location name specified and once with the location name omitted. Once this is done, you can use the bind plan command tyo include the packages in the list with DBPROTOCOL(DRDA) access option in the command.