SAP Knowledge Base Article - Preview

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

Symptom

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

LINE.jpg
|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
LINE.jpg

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).

LINE.jpg
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"
LINE.jpg


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

LINE.jpg
[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 )

LINE.jpg


Read more...

Environment

DB2 z/OS any version
Netweaver ABAP any version

Product

SAP ERP 6.0 ; SAP NetWeaver all versions

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.