To query data that has been archived by the storage saver, you must add a special
register to the SQL code of the query. You can also set a ZPARM if you always want to include this
type of data in your queries.
About this task
Query acceleration must be used because the data to be accessed resides in the Db2 Warehouse target database only. For more
information, see query acceleration.
Procedure
- To instruct a single query so that it includes data that is archived by the storage
saver, set the following special register at the beginning of the SQL code, preferably after the
statement that enables query acceleration (unless query acceleration is enabled by a ZPARM). For
example:
SET CURRENT QUERY ACCELERATION ALL
SET CURRENT GET_ACCEL_ARCHIVE YES
- To set a ZPARM so that queries always include data that was archived by the storage
saver, add the following entry on the DSNTIP82 installation panel of your Db2
for z/OS system: