What are the three types of page locks that can be held?
Answer / s
I think you mean the three types of LOCK MODES.
S Share
U Update
E Exclusive
| Is This Answer Correct ? | 1 Yes | 1 No |
What is performance tuning db2?
What is db2 optimizer?
What is the connection string to connect to the DB2 Database ?
wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?
what happend with out using Commit,when closing cursor and program?
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
If I have a view which is a join of two or more tables, can this view be updatable?
What is Reorg Recovery? when will you run it?
Write a query to extract first 5 characters of a name in the column Stud_Name?
What is error -818 in db2. where can you find the timestamp of the DBRM and the source code.( precompile puts the timestamp on dbrm and source code correct?)