If we have 100 records in the PF, we deleted all the records
then what is the Size of the PF?

Answer Posted / divyananda

The memory will be held untill you compress the PF

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

define clustering index.

618


What is the difference between cursor and select statement?

615


Explain the contents that are a part of dclgen.

661


Explain in detail about buffer manager and its functionalities?

564


I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

1651






Which command is used to remove all rows from a table?

553


What type of database is db2?

525


is it compulsory commitment control in journal?

2013


Name the various locking levels available?

637


How to rename a table in DB2 ?

641


What is collection in db2 bind?

577


What is data manager?

610


What is the purpose of rollback and commit?

595


What is buffer pool?

613


What is null indicator in cobol db2?

586