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 information is held in SYSIBM.SYSCOPY?
On which levels locks can be applied?
What is the picture clause of the null indicator variable?
What is the cascade rule and how does it relate to deletions made with a subselect?
what is Runstats? Whem will u choose to runatats?
Explain about dbrm.
I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.
What is meant by union and union all?
How many databases are there?
In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?
max number of columns in a db2 table?
What do you mean by storage group (stogroup)?