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 DB2X HAS FAILED USING.
BPA0010E: CONNECTION TO DB2 SSID DB2B HAS FAILED USING PLAN: RBPAR190.
These were executed on DB2V12, CATALOG LEVEL(V12R1M500), FUNCTION LEVEL(V12R1M100) on DB2 Tools R19 at Current Maintenance Levels.
Release : 19.0
Component : CA RC/Update for DB2 for z/OS
DB2 V12
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.