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
Remember that 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 archived by the storage saver, set
the following special register at the beginning of the SQL code, preferably below 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: