SAS/ACCESS® to DB2 allows data sharing on MVS


DB2 on MVS has a concept called "data sharing" that allows 32 different subsystems across multiple MVS systems to be members of a DB2 "sharing group". Each DB2 subsystem of the sharing group can access all the data on any of the other subsystems as if it were local. SAS allows a user to access a data sharing group through the SAS/ACCESS to DB2 product as long as all required DB2 setup has been done.

Rather than specifying a particular subsystem, sites can give the group name instead. This allows the same job to run on any of the MVS systems and does not require that the user specify a valid subsystem.

To accomplish this, use the SSID= option but replace the subsystem value with the group name. For example:

proc sql;
connect to db2(ssid=group_name);
quit;