If we have 100 records in the PF, we deleted all the records then what is the S

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

Question Posted / venna

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

More DB2 Interview Questions

What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?

What is RUNSTATS?

Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?

What do you mean by NOT NULL WITH DEFAULT? When will you use it?

What is the difference between using bind () and rebind () methods of naming class?

How do you run JCL in cobol program

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

What is isolation level in db2?

Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?

What is dbrm? When it will be created?

What is the function of the Data Manager?

in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert

For more DB2 Interview Questions Click Here