alternate option to "not logged initially"

sanjai · #1 (**permalink**) 08-06-09, 01:31

hi all,

i am altering a table with "not logged initially" option to avoid logging while doing massive update (to avoid transaction log full). but sometimes i am getting an error
SQL1477N For table "RPM.TRANS" an object "269" in table space "4"
cannot be accessed. SQLSTATE=55019

as per the above msg, i have to drop and recreate the table.

is there any other way to run dml without logging

pls advice

regards
sanjai

db2girl · #2 (**permalink**) 08-06-09, 11:43

See if this helps you:
update 10 million records

MarkhamDBA · #3 (**permalink**) 08-06-09, 14:46

Quote:

Originally Posted by sanjai

hi all,

i am altering a table with "not logged initially" option to avoid logging while doing massive update (to avoid transaction log full). but sometimes i am getting an error
SQL1477N For table "RPM.TRANS" an object "269" in table space "4"
cannot be accessed. SQLSTATE=55019

as per the above msg, i have to drop and recreate the table.

is there any other way to run dml without logging

pls advice

regards
sanjai

could you display commands you used. I just used this option before creating indexes on a huge table and it reduced the time by 30%.

Internet Services

Web Development

Digital Marketing

Consumer Tech