GET ACCEL ARCHIVE field (GET_ACCEL_ARCHIVE subsystem parameter)

The GET_ACCEL_ARCHIVE subsystem parameter determines the default value that is to be used for the CURRENT GET_ACCEL_ARCHIVE special register.

The GET_ACCEL_ARCHIVE subsystem parameter is used when no value is explicitly set for the CURRENT GET_ACCEL_ARCHIVE special register by the SQL statement SET CURRENT GET_ACCEL_ARCHIVE.

Acceptable values: NO, YES
Default: NO
Update: option 31 on panel DSNTIPB
DSNZPxxx: DSN6SPRM.GET_ACCEL_ARCHIVE
NO
Specifies that if a table is archived in an accelerator server, and a query references that table, the query does not use the data that is archived.
YES
Specifies that if a table is archived in an accelerator server, and a query references that table, the query uses the data that is archived.