MVSFORUMS.com

vani · Beginner Joined: 28 May 2003 Posts: 51 Topics: 30

Is there any way we can stop db2 from logging? We are inserting records into tables using a program and the active log datasets are getting full in 5 minutes.
We dont want the data for recovery.

Regards,
Vani

kolusu · Posted: Tue Oct 21, 2003 6:50 am Post subject:

vani,

For inserting a large amount of data, instead of using an SQL INSERT statement, use the LOAD utility with LOG(NO) and take an inline copy.

For mass delete operations, consider using segmented table spaces. If segmented table spaces are not an option, create one table per table space and use LOAD REPLACE with no rows in the input data set to empty the entire table space.

Search this forum for exmaples of load utility

Hope this helps...

cheers

kolusu