Answer / jdriley

It will make the edits you made to the tables using INSERT,
UPDATE, and DELETE permanent.

Answer / abhisek

COMMIT will save/commit the changes made to a database
while INSERT, DELETE and UPDATE operations.

Answer / 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.

Answer / s

COMMIT will write the updates out to DASD.

Answer / urta

issuing the command "commit" means u have saved the
transaction..

how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures

2 Answers   Accenture,

What is a db2 collection?

0 Answers  

What is a page in db2?

0 Answers  

what is plan? is plan executable or package?

4 Answers  

SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .

2 Answers   Cognizant,

In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?

8 Answers   Syntel,

what are stage one indexable predicates?

1 Answers  

What are delete-connected tables?

1 Answers  

When is the results table for the query in a DECLARE CURSOR statement created?

5 Answers  

select 100 records from million records ?

2 Answers   Verizon,

What is the advantage in De-normalizing tables in DB2?

0 Answers  

What does the RUNSTATS Utility do?

4 Answers