What is the function of logging in the db2 database?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB2 Interview Questions

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

5 Answers   CSC,


1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).

1 Answers  


What is the role of schema in the db2 database?

0 Answers  


Can you access the DB2 Directory table using SQL?

3 Answers  


How to resolve -407 sql code in DB2?

9 Answers   Cap Gemini,






What is difference between alias and synonym in db2?

0 Answers  


How do I import a csv file into db2?

0 Answers  


Give some example of statistics collected during RUNSTATS?

1 Answers  


What is the maximum size of varchar data type in db2?

0 Answers  


explain about index with examples

2 Answers   Syntel,


How will you return the number of records in table?

0 Answers  


What does it mean if the null indicator has -1, 0, -2?

1 Answers  


Categories