The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

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:

Error Message - SQLCODE-860

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?

asked 16 Jan '15, 13:36

Justin%20Willey's gravatar image

Justin Willey
6.4k101132197
accept rate: 20%

edited 16 Jan '15, 14:00


Try growing the temporary file first, as with this query on a large table:

   SELECT a.* INTO #t FROM t AS a, t AS b;
permanent link

answered 16 Jan '15, 15:20

Breck%20Carter's gravatar image

Breck Carter
26.6k418575824
accept rate: 21%

edited 16 Jan '15, 15:49

That'll be it then - ooops.

(16 Jan '15, 16:55) Justin Willey
1

As Breck originally said - but then tactfully edited out, if I'd looked up SQLCode -860 properly, I'd have seen that the issue is that the TEMPORARY DBSPACE can't be calibrated until it has reached an unspecified minimum size.

As you have to have exclusive access to the database to run a calibration, I was doing it after a restart of the database, at which point the temporary dbspace would have been tiny. So as Breck points out, the solution is to do something to grow it using your own connection, before trying to calibrate it.

Moral of the story (as so often) - RTFM.

(17 Jan '15, 07:43) Justin Willey
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×186
×113
×5

question asked: 16 Jan '15, 13:36

question was seen: 1,617 times

last updated: 17 Jan '15, 07:44