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 |
Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.
Do we need cursor for Count(*)?
Explain the use of the WHERE clause?
How do I copy a table in db2?
What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?
When is the skeleton cursor table created?
What is load utility in db2?
i have cobol+ db2 program but it contains n number of subprograms for this how many dbrm members i need to mention in bind process
What is the difference between SYNONYM and ALIAS?
Explain in brief how does db2 determine what lock-size to use?
I am getting a error multiple row fetched while executing a Cobol-DB2 program.How can I solve it without using a cursor.
What is the difference between cursor stability and repeatable read isolation levels?