5. Populating Tables : Large Data Loads with the Set Nologging Statement : Example: Use a Set Nologging Application to Load an Existing Database
 
Share this page                  
Example: Use a Set Nologging Application to Load an Existing Database
The following sequence uses a SET NOLOGGING application to load data to an existing database:
1. Checkpoint the database and disable journaling by entering the following command at the operating system prompt:
ckpdb -j dbname
(In Director, use the Back Up Database dialog; in VDBA, use the Checkpoint dialog.)
2. Start the program to load the database with the new data. The program does the following:
Locks the database exclusively to prevent other applications from using the database until the load is complete.
Includes a SET NOLOGGING statement to bypass transaction logging during the data load.
3. If any errors are encountered, restore the database from the checkpoint (you can use the Restore Database dialog in Director or the Database Rollforward DB menu in VDBA) and repeat Step 2.
4. Issue a SET LOGGING statement to resume normal logging operations.
5. Turn journaling back on for the database by checkpointing the database:
ckpdb +j dbname
This establishes a new point from which rollforwarddb processing can be done.
The load is complete. The database can be made accessible to other applications.