×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
The use of the work file database for RID list processing is controlled by the value of which subsystem parameter?
2.
In an environment with a large amount of dynamic SQL, which subsystem parameter should be adjusted to increase the amount of memory available for caching statements in the global dynamic statement cache?
3.
Which command can be used to adjust the system checkpoint frequency?
4.
A member of a data sharing group is suffering from elongated response times. You suspect that sysplex workload balancing (WLB) is not working properly for the DDF work (not evenly distributing the work among the different members). What is the simplest way to verify how the DDF threads are distributed amongst the different members?
5.
The subsystem parameter PKGREL_COMMIT is set to YES. Which statement is true for packages bound with RELEASE(DEALLOCATE)?
6.
Program Authorization does NOT work in which environment?
7.
DB2 can use RUNSTATS profiles for autonomic statistics maintenance. Which catalog table holds the options specified for the profiles?
8.
What job will check for changes to DB2 that might impact your migration to Version 11 conversion mode?
9.
Which two features are the motivation behind the conversion to extended RBA/LRSN format?
10.
You wish to set the maximum allocation of sort storage to 5000 kilobytes for a query that contains an ORDER BY clause. Which action will accomplish this?