UNIT 6 PART 2

Question 1

When should we turn off table buffering?

Answer 1

1) If the table is larger than 1mb
2) If the table experiences many invalidations
3) If we have a high number of rows affected

Question 2

When should we buffer a table?

Answer 2

1) When table is often access
2) It’s it seldom changes
3) If it’s over 1mb in special cases

Question 3

What happens if a buffered table is updated (changed)?

Answer 3

The database is updated and the buffer of the current app server is invalidated

Changes are written to table DD log

The other app servers

Question 4

What transactions can be used to identify table buffering problems?

Answer 4

ST13

ST10