While in Split Screen on various products (SQLEASE, RC/Update, ISQL) it fails with:
PTIDB2-CAF: ADDRESS SPACE CONNECTED WITH DIFFERENT NAME OR TYPE BPA0010E: CONNECTION TO DB2 SSID xxxx HAS FAILED USING.
BPA0010E: CONNECTION TO DB2 SSID xxxx HAS FAILED USING PLAN: RBPAxxxx.
These were executed on Db2 12, CATALOG LEVEL(V12R1M500), FUNCTION LEVEL(V12R1M100) on Database Management tools r19 at current maintenance levels.
The CONNECT(AUTO) option is mainly used for RRSAF authorization when using Enhanced Explain function DDLFILE. Batch processor switches
Db2 connection to RRSAF while executing SQL statement when CONNECT(AUTO) is specified in CDBAPARM and this looks to be the reason for the failure.
In the future Broadcom will actively work on the resolving the current CAF/RRSAF issue, it will be available in near future.
Eliminate use of the CONNECT keyword in favor of our products determining proper behavior.
Force RRSAF-only usage in TSO
Force AUTO in batch to allow mixed usage as needed
There are two known instance where connection remains active even when user gets the control back from product. One when browsing a table in
RC/Edit using background fetch option along with PAUSE mode and second while using SQL editor in ISQL online.
Until the above formulated plan gets implemented, its recommended to avoid using split screen when using SQL editor in ISQL or Plan Analyzer use
case when CONNECT(AUTO) is in place.