Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
what where clause?? As Art says do a dummy update of a column to get
rid of the in place alter table.
you could do this in spl:
WARNING UNTESTED CODE ahead....
ex:
create procedure dodummy()
define commit_cnt int;
set isolation to dirty read;set lock mode to wait 10;let commit_cnt = 0;
-- no exception handling yet, simply wait for a lock if fails
-- rerun the spl.
begin work;
foreach mycur with hold
for
select somecol from sometable
let commit_cnt = commit_cnt + 1;
update yourtable set somecol = somecol where current of mycur;
if mod(commit_cnt,1000) = 999 then
commit work;
begin work;
end if;
end foreach;
commit work;
end procedure;
which i guess is as fast as it is going to get/be in a logged db.
or make the table raw??? so stuff does not get logged.....
Superboer.
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.