Chapter 7. Advanced topics 123
7.1.1 Best practice
Specify CLOSE(NO) for objects that you expect to be GBP-dependent most of
the time and which are sensitive to response time during first access. Most table
spaces should be CLOSE(YES).
7.2 Performance
The question everyone asks is: “How much overhead will I experience in data
sharing over my current non-shared workload?”
That answer cannot be provided here, as it is workload dependent. The most
accurate way to determine it is to provide an isolated environment with
repeatable workload where you can benchmark, but this is impractical. New data
sharing users are left with commonly accepted rules of thumb (ROT) that are
stated something like, “For a 2-way group, expect overhead of x% and for ea ...