how to u check the query is executing or not ?where will u check for sqlcode ?

Answer Posted / anjireddy vintha

RUNTIME SUPERVISER WIL MONITER THE SQL QUERY'S AND IT WILL
GENERATE SQLCODE FOR EVERY EXEUTION OF SQL QUERY.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is access path in db2?

564


What is the function of logging in the db2 database?

645


When do you specify the isolation level?

608


Why do chiropractors use drop table?

662


What is commit in db2?

596






How can deadlocks be resolved?

542


Explain how can you do the explain of a dynamic sql statement?

654


What does a deadlock mean in DB2?

653


What is the difference between plan and package in db2?

579


can we view the access paths created by dbrm ? how ? thx

6262


What do you mean by rollback?

572


What is a cursor in programming?

596


What are packages in db2?

597


While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

1820


Define check constraint.

644