relation of updating a table and logfile

M_RAS · #1 (**permalink**) 11-21-03, 12:01

Hi All,
I am working with db2 v7.2 fix pack 6 and AIX 5.2

I am trying to update a table with 10 mil records and updating will impact to 1.7 mil records

my question is:
whole of table will transfer to logfile or just 1.7 mil records?

Thank you in advance for your help.

Marcus_A · #2 (**permalink**) 11-21-03, 12:31

Just the 1.7 rows that are changed are logged. It would good if you could do intermediate commits. This can be specified on the import command. Intermediate commits every 100-1000 updates is a good commit interval.

If you don't perform intermediate commits, your log files may fill up.

M_RAS · #3 (**permalink**) 11-21-03, 12:37

Quote:

Originally posted by Marcus_A
Just the 1.7 rows that are changed are logged. It would good if you could do intermediate commits. This can be specified on the import command. Intermediate commits every 100-1000 updates is a good commit interval.

If you don't perform intermediate commits, your log files may fill up.

Thank you Marcus

Internet Services

Web Development

Digital Marketing

Consumer Tech