Does ALTER DATABASE RESTORE CACHE run in the background?

The 17.0.11 SP1 docs state for the ALTER DATABASE RESTORE CACHE statement:

The effect of the statement is the same as that of calling the sp_read_db_pages system procedure for each dbspace with the bitmap stored in the prefetch_column of the SYSDBSPACE system view.

Question: Does this run in the background? The sp_read_db_pages() procedure has an optional "in_background" parameter but AFAIK the docs don't tell whether this parameter is set as default or not, and therefore it's not clear for ALTER DATABASE RESTORE CACHE either.

We think about using that statement within a database start event if cache contents has been stored beforehand (as noted in SYSDBSPACE.saved_cache_pages), say for a regular restart. However, it should NOT disturb the database's availability, so background processing would be strongly favoured.

sa-17 cache documentation

asked 11 Nov '22, 04:26

Volker Barth
40.2k●361●550●822
accept rate: 34%

Any information from the doc team would be appreciated... :)

(22 Nov '22, 01:10) Volker Barth

flat view

Be the first one to answer this question!

toggle preview

community wiki:

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

learn more about Markdown

Question tags:

sa-17 ×246
documentation ×93
cache ×26

question asked: 11 Nov '22, 04:26

question was seen: 419 times

last updated: 08 Dec '22, 06:10

SAP SQL Anywhere

Does ALTER DATABASE RESTORE CACHE run in the background?

Follow this question

Related questions