Answers were Sorted based on User's Feedback
Answer / s
Bufferpools are areas of virtual storage where DB2
temporarily stores the pages of tablespaces and indexes.
|Is This Answer Correct ?||12 Yes||0 No|
Answer / pavan grandhi
Buffer pool is a process of caching currently retrieved or
probable pages for retrieval from secondary storage (hard
disks, drums etc.), on to the primary storage.
It is for faster read/write cycles.
Used in OS/RDBMS, DB2 too.
|Is This Answer Correct ?||2 Yes||2 No|
Why select is not preferred in embedded sql programs?
Explain the use of the WHERE clause.
how can you copy records present in a flat physical file to a database file(physical file).please explain in rpg400 with a simple example
what is the name of the default db2 catalog database?
How and when does the db2 enforces the unique key?
How to execute stored procedures?
if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..
Can there be more than one cursor open for any program?
When do you use the IMAGECOPY?
wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?
What is the syntax required for the creation of a cursor?
What is EXPLAIN?