Progress
Programming
Handbook
Disabling Triggers for Dump/Load
When you dump and load database records, you may want to disable the schema triggers of the involved databases. If you do not disable them, when you dump records from a database, Progress executes any of the database’s associated FIND schema triggers. Also, when you load records into a database, Progress executes any of the database’s associated CREATE, WRITE, and ASSIGN schema triggers.
Executing schema triggers can interfere with the dump/load operation and can increase the time needed for the operation. For more information on how to disable schema triggers, see the Progress Database Administration Guide and Reference.
NOTE: If your site implements database replication, and the replication scheme involves cascading replication, you might have to use ALLOW–REPLICATION option of the DISABLE TRIGGERS FOR LOAD statement. This option tells Progress not to disable replication-related triggers while it loads data from the replication log to the database.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |