what happend with out using Commit,when closing cursor and
program?

Answers were Sorted based on User's Feedback



what happend with out using Commit,when closing cursor and program?..

Answer / harish

yes, commit-it will save the changes that we done to db2
table

when operation is performed successfully table will be auto
committed its default,suppose if any abends occur all
changes will be rolled back , table will come to original
status

since while updating millions of records somewhere some
abend occurs that time its better to have commit ,so till
upto abend whatever changes occured in table will be
saved.....

pls let me know if u have any queries

HARISH POOMGAME SHIVAPPA
NIIT TECHNOLOGY
KOLKATA

Is This Answer Correct ?    4 Yes 0 No

what happend with out using Commit,when closing cursor and program?..

Answer / praveen

If the program ran successfully, then it will commit.

Is This Answer Correct ?    3 Yes 1 No

what happend with out using Commit,when closing cursor and program?..

Answer / guna

If there is no commit while closing cursor or a program,
processed records are lost when an abnormal end occurs.
Say, if due to the execution of the program some rows are
inserted/deleted/updated in a table, those changes will be
lost.
It is a better practice to give commit after every
insertion/updation queries and before terminating a
program.

Is This Answer Correct ?    4 Yes 2 No

what happend with out using Commit,when closing cursor and program?..

Answer / vish

True that we should Explicitly COMMIT the data instead of
depending on auto comit. But COMMITing after every
insert/update of data is not a very good option. Explicit
COMMIT incurs an overhead and makes the processing slow. So
if we are inserting/updating a large number of data into
table, COMMIT after every such update will make the Job
very slow, which in most of the cases, is not preferrable
for production Jobs. In fact, the COMMIT frequency should
be chosen very carefully for every program (please note we
should not have a common COMMIT frequncy for all the
programs as the data being proceesed by different programs
will be different and hence their importance & time to re-
process them also differs) keeping in mind that neither the
performance should be degraded nor the data should be lost.
Suggesstions are Welcome!!

Is This Answer Correct ?    1 Yes 0 No

what happend with out using Commit,when closing cursor and program?..

Answer / mani

The answer to the question is pretty simple and straight.

Auto commit happens when the cursor is closed.
If at all there is any abend then the changes made will be lost.

Is This Answer Correct ?    4 Yes 3 No

Post New Answer

More DB2 Interview Questions

List down the types of triggers in the db2 database?

0 Answers  


How to define the data items to receive the fetch items for the SQL?

2 Answers  


if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..

4 Answers   IBM,


Explain about mirror activator disk mirroring?

0 Answers  


What is difference between isnull and coalesce?

0 Answers  






Once you create a view, where would information about the view be stored?

1 Answers  


Describe what a storage group(STOGROUP) is?

2 Answers  


How to find primary key of a table in db2?

0 Answers  


When will you chose to run RUNSTATS?

1 Answers  


Can a Db2 table data be retrived through JCL?

4 Answers  


What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

0 Answers  


what are the bind parameters?

5 Answers   IBM,


Categories