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.