No one individual should have total responsibility for all areas. Review all standards as they pertain to the use of DB2 within the installation. Ensure that standards exist and that they provide a framework within which the software can be controlled and applications can be developed in a manner which is conducive to control and security as well as being efficient. The level of security to be applied to the data being stored. This should provide a definition of the access controls to be applied as well as a method for determining the sensitivity of the data.
Security needs to be applied depending on sensitivity.
In addition, the granting of the administrative privileges needs to be properly defined within standards. The control over the data which is to be applied. This should include requirements for editing and validating the data which is entered into the database, the requirements for control totalling and the requirement for audit trail. These standards should cover the use of the standard SQL exits to provide for control routines. There should be some form of standard which details the steps to be followed when designing applications which use DB2.