What is the significance of DB2 free space and what
parameters control it?



What is the significance of DB2 free space and what parameters control it?..

Answer / s

Free space is used by DB2 to maintain data clustering and
variable length rows. FREE PAGE,PCTFREE

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More DB2 Interview Questions

What are the prerogatives?

0 Answers  


How to resolve -818 sql code in DB2?

2 Answers   Cap Gemini,


What are the functions of Bind?

2 Answers   Amdocs, IBM,


Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?

1 Answers  


What is rebind in db2?

0 Answers  






How to find schema of a table in db2?

0 Answers  


if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.

8 Answers   Wipro,


Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?

1 Answers   IBM,


what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........

1 Answers  


can all users have the privilage to use the sql statement select * (dml)?

0 Answers   IBM,


How do I change the column size in db2?

0 Answers  


what needs to be done if a table is in copy pending / check pending status?

5 Answers   Xansa,


Categories