Turn autocommit off

[khsaunderson]

Hi

What is the syntax to turn auto commit off in DB2? I'm using SqlDbx to run some massive scripts and it's slowing down as the day progresses. I've been told turning autocommit off should speed things up.

Thanks

 

[papadba]

Which operating system is being used for db2?

 

[khsaunderson]

I've actually found a switch on the GUI software I use. Thanks anyhow.
K

 

[blom0344]

Turning autocommit off will possibly cause other issues as you are creating large rollback segments that will start rolling back actions when you run into an issue/error.

Ties Blom