GUIDELINE
Review Date
08/2002
1.0 SUBJECT: DB2 DDL
2.0 DISTRIBUTION: All Current Users
3.0 FROM: Bruce Roberts, Director of DISC
4.0 PURPOSE: To provide direction in the creation and maintenance of DB2 objects and libraries.
5.0 BACKGROUND: In order to maintain the integrity of systems it has been determined that it is necessary to maintain separate source code libraries for each function such as production, test, training and development. In most instances a minimum of two libraries have proven to be necessary, one for production code and one for testing purposes.
6.0 GUIDELINE: DB2 objects and libraries should be as unique to a function, (production, test, training, development), as is source code. Table modifications can and will affect applications and should be carefully tested before changes are put into production. The integrity of a system utilizing DB2 will be as dependent upon the integrity of the DB2 objects and libraries as it is upon source code. As much caution should be exercised to maintain the integrity of DB2 objects and libraries as is utilized to protect the integrity of source code.
7.0 HISTORY: This publication was originally issued as Guideline 3609.00, 12/19/1991. Reissued 3609.01, 07/05/200. Re-issued 3609.02, 08/15/2002.
8.0 CONTACT PERSON: Deputy Director, Bureau of Information Systems, 785-296-3343.