Database administration for data sharing
Using data sharing has implications for planning exit routines, authorizing users, and loading and reorganizing data.
Because the Db2 catalog is shared by all members of a data sharing group, data definition, authorization, and control are the same as for non–data sharing environments. Be sure that every object has a unique name, and be sure that the shared data resides on shared disks.
Planning for exit routines
If you use exit routines, such as a field or validation procedure or the access control authorization routine, ensure that all members of the group use the same routines.Authorizing users
Generally, you can use the same authorization mechanisms that are in place for non–data sharing Db2 subsystems to control access to shared Db2 data and to members. However, some specific considerations apply in Db2 data sharing environments. For more information, see Security for Db2 data sharing.
Loading and reorganizing data
You can load or reorganize data from any member of a data sharing group.