Explain in detail about buffer manager and its functionalities?
No Answer is Posted For this Question
Be the First to Post Answer
One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?
What is the command used by TSO users to invoke DB2?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What is the role of data manager in the db2 database?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
Assuming that a site's standard is that pgm name = plan name, what is the easiest way to find out which Will precompile of an DB2-COBOL program bomb, if DB2 is down?
What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?
What is precompiler in db2?
What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.
SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .
What is the information associated with sysibm.syslinks table?
Before you give the explain statement, what are the prerogatives?