If I have 5 Queries in a DB2 Cobol program , while
precompiling how many DBRMs will get created and How many
Plans and Packages will get created while Bind Process?
Answer Posted / shailesh
1 DBRM only.
Correct me if I am wrong !
| Is This Answer Correct ? | 15 Yes | 0 No |
Post New Answer View All Answers
What is a dbrm in db2?
What is a buffer in memory?
Mention the various locks that are available in db2.
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
Can you tell me how can you find out the # of rows updated after an update statement?
What is the use of db2?
What are the 2 sqlcodes that are returned?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What are foreign keys in db2?
Explain the contention situations caused by locks?
Explain about mirror activator disk mirroring?
What is phantom read in db2?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What is the syntax for seeing the columns and data types of a table in the db2 database?
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 ?