4. What parameters are used to control the free space in DB2?

What parameters are used to control the free space in DB2?

Answer

Free space permits the addition of new rows.

There are two parameters, which are used to control the free space in DB2, they are:

  • PCTFREE – It defines the free space percentage that will be present in each page.
  • FREEPAGE – It specifies the number of pages to be loaded before leaving a page empty.

All mainframes Questions
Ask your interview questions on mainframes

Write Your comment or Questions if you want the answers on mainframes from mainframes Experts
Name* :
Email Id* :
Mob no* :
Question
Or
Comment* :
 





Disclimer: PCDS.CO.IN not responsible for any content, information, data or any feature of website. If you are using this website then its your own responsibility to understand the content of the website

--------- Tutorials ---