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

Answers were Sorted based on User's Feedback



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

Answer / divyananda

The memory will be held untill you compress the PF

Is This Answer Correct ?    6 Yes 1 No

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

Answer / rama

If it is a physical sequential file the size of the file
becomes 0.

Is This Answer Correct ?    5 Yes 2 No

Post New Answer

More DB2 Interview Questions

What is db2 command?

0 Answers  


Return code 100 means?

6 Answers   Cap Gemini,


What is the picture clause of null indicator variable?

0 Answers  


How to resolve -803 sql code in DB2?

3 Answers   Cap Gemini,


What does the sqlcode of -818 pertain to?

3 Answers  






Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.

2 Answers  


What is tablespace?

3 Answers  


What is the use of value function?

0 Answers  


What is runstats utility in db2?

0 Answers  


How to compare data between two tables in db2?

0 Answers  


What is meant by dclgen?

0 Answers  


What are some characteristics of columns that benefit from indexes?

1 Answers  


Categories