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|
What is the maximum No of rows per page?
Suppose if I need to update a column, how you do that using cursor?
How do you eliminate duplicate values in db2?
A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cobol-db2 program. How should I declare my local input file variable or any suggestion?
What do you mean by storage group (stogroup)?
What is query for your birthday date should be in hours,minute and seconds format?
when does the SQL statement gets executed when you use cursor in the application programming ?
what types of copies can be made with the COPY Utility ?
What are the 4 environments which can access DB2 ?
What does db2 plan contain?
How do you run JCL in cobol program
What is filter factor?