A strategy for improving performance is to disable all
data definition operations while your applications are running.
You do this by using SQLUtil to set the DDL Enabled
parameter in the DBECon file to NO.
This is a simple matter if you do all data definition in a
development DBEnvironment. In such a case, you can disable
DDL in the production DBEnvironment only.
Disabling data definition
Makes it impossible to perform
data definition and to lock system catalog pages exclusively.
Does not inhibit the revalidating of sections. If ALLBASE/SQL
encounters invalid sections, they will be revalidated as necessary.
Disables the following statements:
ADD DBEFILE ADD GROUP ADD TO GROUP
ALTER DBEFILE ALTER TABLE CREATE DBEFILE
CREATE DBEFILESET CREATE GROUP CREATE INDEX
CREATE TABLE CREATE VIEW DROP DBEFILE
DROP DBEFILESET DROP GROUP DROP INDEX
DROP TABLE DROP VIEW GRANT
REMOVE FROM GROUP REVOKE START DBE NEWLOG
TRANSFER OWNERSHIP UPDATE STATISTICS
|
Inhibiting DDL has little effect on performance
for applications that do not re-use the same sections.