ARCHIVESENSITIVE bind option

The ARCHIVESENSITIVE option determines whether references to archive-enabled tables in both static and dynamic SQL statements are affected by the value of the SYSIBMADM.GET_ARCHIVE global variable.

Command option	Option values	Used with
ARCHIVESENSITIVE	(YES) (NO)	BIND PACKAGE BIND SERVICE REBIND PACKAGE ¹ REBIND TRIGGER PACKAGE

Note:

The ARCHIVESENSITIVE bind option is not valid for REBIND of packages for complied SQL functions, native SQL procedures, or advanced triggers.

Option descriptions for ARCHIVESENSITIVE

ARCHIVESENSITIVE(YES): References to archive-enabled tables are affected by the value of the SYSIBMADM.GET_ARCHIVE built-in global variable.
ARCHIVESENSITIVE(NO): References to archive-enabled tables are not affected by the value of the SYSIBMADM.GET_ARCHIVE built-in global variable.

Start of change Interactions with the PLANMGMT option: If you plan to change this option and the PLANMGMT option in a REBIND command, see PLANMGMT bind option for the implications. End of change

Defaults for ARCHIVESENSITIVE

Process	Default value
BIND SERVICE	YES
BIND PLAN	N/A
BIND PACKAGE	YES
REBIND PLAN	N/A
REBIND PACKAGE	Existing value
REBIND TRIGGER PACKAGE	Existing value