Example: Use a Set Nologging Application to Load a New Database
Here is an example sequence of using a SET NOLOGGING application to load a new database:
1. Create the database.
2. Start the program to load the new database with data. The program includes a SET NOLOGGING statement to bypass transaction logging during the data load.
3. If any errors are encountered, destroy the database and repeat Steps 1 and 2.
4. Issue a SET LOGGING statement to resume normal operations.
5. Checkpoint the database and enable journaling to enable rollforward recovery on this database.