What is the significance of DB2 free space and what
parameters control it?
Answer Posted / 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 View All Answers
Explain dclgen.
Mention the various locks that are available in db2.
What is cursor in dbms?
What is dclgen (declaration generator)?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
Define db2.
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What is temporal table in db2?
How do I copy a table in db2?
What are the various data types available in db2?
What is ibm db2 client?
What is declare cursor?
Is db2 a mainframe?
What is db2 plan table?