PTIDB2-CAF BPA0010E RC=008 RCODE=0024 ADDRESS SPACE CONNECTED with DIFFERENT NAME or TYPE
search cancel

PTIDB2-CAF BPA0010E RC=008 RCODE=0024 ADDRESS SPACE CONNECTED with DIFFERENT NAME or TYPE

book

Article ID: 197063

calendar_today

Updated On:

Products

RC/Update for DB2 for z/OS SQL-Ease for DB2 for z/OS Database Management for DB2 for z/OS - Administration Suite Database Management for DB2 for z/OS - Performance Suite Database Management for DB2 for z/OS - Recovery Suite Database Management for DB2 for z/OS - SQL Performance Suite Database Management for DB2 for z/OS - Utilities Suite DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS

Issue/Introduction

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.

Resolution

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.