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 |
wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?
Where would you find information about the type of database authority held by the user?
This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.
What is meant by AUTO COMMIT?
in column y record abc.v abc.s xyz.j abc.h i wan only abc columns how to retrieve thi records
What are the disadvantages of PAGE level lock?
What is an instance database?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
what is the role of the cursor in db2?
what is parm utility
What is cursor in dbms?
What is REORG? When is it used?