From time to time we find it worthwhile running CALIBRATE statements on servers, especially those with fancy disk systems - sometimes the improvement in performance can be quite dramatic.
Usually we just run
ALTER DATABASE CALIBRATE SERVER;which works nicely and according to the docs calibrates all dbspaces except the TEMPORARY dbspace. However in a recent case, we thought we might as well do the TEMPORARY dbspace as well - but
ALTER DATABASE CALIBRATE DBSPACE TEMPORARY;produces this error:
For what it's worth
ALTER DATABASE CALIBRATE DBSPACE SYSTEM;works fine. I've tried it on a variety of systems from v10 to v16 - all with the same result.
Am I doing something idiotic?