Large Data Loads with the Set Nologging Statement

This section contains the following topics:

• Suspend Transaction Logging
• Effects of the Set Nologging Statement
• Before Using the Set Nologging Statement
• Restore Transaction Logging
• Example: Use a Set Nologging Application to Load a New Database
• Example: Use a Set Nologging Application to Load an Existing Database

The SET NOLOGGING statement allows you to bypass the logging and recovery system. This can be time-efficient for certain types of batch update operations but must always be used with extreme care.

The SET NOLOGGING statement is intended to be used solely for large database load operations for which the reduction of logging overhead and log file space usage outweigh the benefits of having the system recover automatically from update errors.