Ingres 11.0 | Example: Use a Set Nologging Application to Load a New Database

Database Administrator Guide > Database Administrator Guide > Populating Tables > Large Data Loads with the SET NOLOGGING Statement > Example: Use a Set Nologging Application to Load a New Database

Was this helpful?

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.

Last modified date: 01/30/2023