Mention the downsides of page level lock.
No Answer is Posted For this Question
Be the First to Post Answer
How do I delete a table in database?
What is the default page size of buffer pools?
What are the two types of logging in the db2 database? Explain them.
what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'
Mention the location where the output received from explain statement is stored.
Request to database but database is not available so what is was abend is raised?
what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??
What is IMAGECOPY ?
Is db2 free?
if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)
what is Runstats? Whem will u choose to runatats?
List out the three types of page locks that can be held.