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 |
What are the prerogatives?
How to resolve -818 sql code in DB2?
What are the functions of Bind?
Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?
What is rebind in db2?
How to find schema of a table in db2?
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.
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?
what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........
can all users have the privilage to use the sql statement select * (dml)?
How do I change the column size in db2?
what needs to be done if a table is in copy pending / check pending status?