2872807 - Incorrect handling of remote CCMS_DB2_* connections within the tasks called by job RSDB2_RUN_HOURLY_REMOTE.

You observe the following connect errors in the Netweaver ABAP system log (tcode SM21) every time scheduled job RSDB2_RUN_HOURLY_REMOTE runs.

|06/05/2019|01:38:09|PRDSAPFI001_PRD_00|BTC |044|000|DDIC|BYI|Connect to the database with ID CCMS_DB2_A failed
|06/05/2019|01:38:09|PRDSAPFI001_PRD_00|BTC |044|000|DDIC|BZY|Unexpected return value 8192 when calling up DBDS
|06/05/2019|03:37:41|PRDSAPFI001_PRD_00|BTC |044|000|DDIC|BYI|Connect to the database with ID CCMS_DB2_O failed
|06/05/2019|03:37:41|PRDSAPFI001_PRD_00|BTC |044|000|DDIC|BZY|Unexpected return value 8192 when calling up DBDS
|06/05/2019|05:37:42|PRDSAPFI001_PRD_00|BTC |043|000|DDIC|BYI|Connect to the database with ID CCMS_DB2_J failed
|06/05/2019|05:37:42|PRDSAPFI001_PRD_00|BTC |043|000|DDIC|BZY|Unexpected return value 8192 when calling up DBDS
|06/05/2019|07:37:44|PRDSAPFI001_PRD_00|BTC |043|000|DDIC|BYI|Connect to the database with ID CCMS_DB2_E failed
|06/05/2019|07:37:44|PRDSAPFI001_PRD_00|BTC |043|000|DDIC|BZY|Unexpected return value 8192 when calling up DBDS
|06/05/2019|09:37:38|PRDSAPFI001_PRD_00|BTC |045|000|DDIC|BYI|Connect to the database with ID CCMS_DB2_D failed
|06/05/2019|09:37:38|PRDSAPFI001_PRD_00|BTC |045|000|DDIC|BZY|Unexpected return value 8192 when calling up DBDS
|06/05/2019|10:38:38|PRDSAPFI001_PRD_00|BTC |038|000|DDIC|BYI|Connect to the database with ID CCMS_DB2_X failed
|06/05/2019|10:38:38|PRDSAPFI001_PRD_00|BTC |038|000|DDIC|BZY|Unexpected return value 8192 when calling up DBDS
|06/05/2019|11:37:43|PRDSAPFI001_PRD_00|BTC |045|000|DDIC|BYI|Connect to the database with ID CCMS_DB2_A failed
|06/05/2019|11:37:43|PRDSAPFI001_PRD_00|BTC |045|000|DDIC|BZY|Unexpected return value 8192 when calling up DBDS
|06/05/2019|13:37:42|PRDSAPFI001_PRD_00|BTC |045|000|DDIC|BYI|Connect to the database with ID CCMS_DB2_U failed
|06/05/2019|13:37:42|PRDSAPFI001_PRD_00|BTC |045|000|DDIC|BZY|Unexpected return value 8192 when calling up DBDS
|06/05/2019|15:37:43|PRDSAPFI001_PRD_00|BTC |045|000|DDIC|BYI|Connect to the database with ID CCMS_DB2_R failed
|06/05/2019|15:37:43|PRDSAPFI001_PRD_00|BTC |045|000|DDIC|BZY|Unexpected return value 8192 when calling up DBDS

The Netweaver developer trace reports the full connection name with error sqlcode SQL1336N "Remote host not found".  These connection names (ie, CCMS_DB2_RWCJAFNVRCDQYNZJ) don't even exist in DBCO (DBCON table).

C Fri Jun 7 11:37:58:742 2019
C *** ERROR => DB2 Call 'SQLDriverConnectW' Error: conHdl = 01 SQLCODE = -1336 : [IBM][CLI Driver] SQL1336N The remote host "db1t" was not found. SQLSTATE=08001
[dbdb2cli.c 6579]
C {root-id=005056B846541ED9A2A746F7E524413F}_{conn-id=00000000000000000000000000000000}_0
C *** ERROR => CONNECT failed with SQL error '-1336'
[dbdb2s.c 1174]
B ***LOG BYI=>connect failed for connection CCMS_DB2_RWCJAFNVRCDQYNZJ [dbds 999]
B ***LOG BZY=> unexpected return code 8192 calling DBDS [dbacds 2054]
B *** ERROR => Unexpected RC when calling dsql_connect
[dbacds.c 2055]
Connect to CCMS_DB2_RWCJAFNVRCDQYNZJ as withSAPDBHOST=db2t;PORT=3064;LOCATION=AOICDB0T C COLLECTION ID used is "SAP1101V12R1M500U"

A CLI trace of a failed connection attempt shows that CCMS_DB2_* connection information is obtained from Db2 table DB2MISC.

[1559921841.319950 - 06/07/2019 11:37:21.319950] SQLDriverConnectW( )
[1559921841.319959 - 06/07/2019 11:37:21.319959] <--- SQL_SUCCESS Time elapsed - +3.387800E-00 2 seconds
.............................
.............................
[1559921841.418091 - 06/07/2019 11:37:21.418091] SQLExtendedPrepareW( hStmt=1:106, pszSqlStr="SELECT
"THEVALUE" FROM "DB2MISC" WHERE "THEKEY" = 'CCMS_SSID_DETERMINATION' AND "SUBKEY" = ' ' FETCH FIRST
1 ROWS ONLY OPTIMIZE FOR 2 ROWS FOR READ ONLY WITH UR ", cbSqlStr=161, cPars=0, sStmtType=SQL_CLI_STMT_SELECT, cStmtAttrs=1 )
[1559921841.418105 - 06/07/2019 11:37:21.418105] ---> Time elapsed - +9.000000E-006 seconds
[1559921841.418112 - 06/07/2019 11:37:21.418112] ( Attribute=1, piStmtAttr=SQL_CURSOR_HOLD, pvParams=0 )
[1559921841.418121 - 06/07/2019 11:37:21.418121]
.............................
.............................
[1559921841.421876 - 06/07/2019 11:37:21.421876] SQLExtendedPrepareW( hStmt=1:108, pszSqlStr="SELECT
"THEVALUE" FROM "DB2MISC" WHERE "THEKEY" = 'CCMS_DB2_DBCON_HOSTNAME_FORMAT' AND "SUBKEY" = ' ' FETCH
FIRST 1 ROWS ONLY OPTIMIZE FOR 2 ROWS FOR READ ONLY WITH UR ", cbSqlStr=168, cPars=0, sStmtType=SQ
L_CLI_STMT_SELECT, cStmtAttrs=1 )
.............................
.............................
[1559921841.424941 - 06/07/2019 11:37:21.424941] SQLExecute( hStmt=1:279 )
[1559921841.424948 - 06/07/2019 11:37:21.424948] ---> Time elapsed - +1.000000E-005 seconds
[1559921841.424958 - 06/07/2019 11:37:21.424958] ( Package="SYSLH100 ", Section=71 )
[1559921841.424966 - 06/07/2019 11:37:21.424966]
[1559921841.424984 - 06/07/2019 11:37:21.424984] ( Row=1, iPar=1, fCType=SQL_C_WCHAR, rgbValue="CCMS_DB2_RWCJAFNVRCDQYNZJ" -
x'430043004D0053005F004400420032005F005200570043004A00410046004E00560052004
3004400510059004E005A004A00', pcbValue=50, piIndicatorPtr=50 )

DB2 z/OS any version
Netweaver ABAP any version

DBCON , KBA , BC-DB-DB2 , DB2 for z/OS , Problem