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

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

Question Posted / rama

Answer Posted / rama

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

Is This Answer Correct ?

5 Yes

2 No

Please Help Members By Posting Answers For Below Questions

List out the buffer pools in db2

1131

What is explain in db2?

1080

What is with ur in db2?

1389

What does db2 stand for?

1095

What is copy pending status in db2?

1186

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3637

Is schema the same as database?

1108

What are the rules for db2 programming?

1156

What is scrollable cursor in db2?

1128

What is the difference between cursor and select statement?

1154

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1325

What does a deadlock mean in DB2?

1222

Where do you specify them?

1376

What is the difference between dbm cfg and db cfg file in db2 ?

1595

Why do we use cursor?

1166