What will the COMMIT accomplish?

Answer Posted / as

Commit will clear the content of DB2 buffers.

This point comes to use when you are updating huge nbr of
records without using commit. If the buffer become full
before you commit, then it will cause problem.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many types of page locks can be held in db2?

593


What is null indicator in cobol db2?

585


What is sqlca’s maximum length?

675


What is runstats utility in db2?

569


What is nvl in db2?

628






What is deadlock in db2?

584


What is node in db2?

609


What is catalog database in db2?

646


What are db2 tables?

649


Mention data types used in db2 ?

679


What are the 2 sqlcodes that are returned?

643


How can we retrieve the total number of records in RPG & CLLE?

197


Describe major components of db2?

641


What is reorg and runstats in db2?

696


What is db2 look?

580