SAP Knowledge Base Article - Preview

3258697 - Intermittent SQL10013N errors

Symptom

You are seeing intermittent '[IBM][CLI Driver] SQL10013N  The specified library "" could not be loaded' errors in the SAP system accompanied by DBIF_RSQL_SQL_ERROR dumps.
====================================================================================
Category               Installation Errors
Runtime Errors         DBIF_RSQL_SQL_ERROR
Except.                CX_SY_OPEN_SQL_DB
Date and Time          16.08.2022 10.46

Short text
     SQL error "-10013" when accessing table "tabname".

What happened?
     Error Text of the Database: "SQL10013N The specified library "" could not be loaded. SQLSTATE=42724"
====================================================================================

Developer traces report the same.
====================================================================================
C Tue Aug 16 10:46:00 2022
C  *** ERROR in DB6Connect[dbdb6.c, 2009] CON = 1 CACHEID = -1 (BEGIN)
C  &+     DbSlConnectDB6( SQLConnect ): [IBM][CLI Driver] SQL10013N  The specified library "" could not be loaded.  SQLSTATE
C  &+     =42724
C  &+
C  &+
C  &+     ABAP location info 'SAPLSO02', 1401
C  &+     SAP user '**********', transaction code '****'
C  &+
C  *** ERROR in DB6Connect[dbdb6.c, 2009] (END)
C  *** ERROR => DbSlConnect to 'SAP' as 'sapsr3' failed
 [dbdb6.c      2016]
C  {root-id=12C10F305D051EDD87A90215AA8ED983}_{conn-id=00000000000000000000000000000000}_0
B  ***LOG BY4=> sql error -10013 performing DEL on table tabname                                                    [dbtran       10043]
B  ***LOG BY0=> SQL10013N  The specified library "" could not be loaded.  SQLSTATE=42724               [dbtran       10043]
====================================================================================

With the client side db2diag.log reporting GSKit Error=17
====================================================================================
2022-08-16-10.46.25.460423+000 I839475865E726        LEVEL: Error
PID     : 24369                TID : 47445786596672  PROC : dw.sapSAP_D00
INSTANCE: db2sap               NODE : 000
HOSTNAME: agpw03sapap4
FUNCTION: DB2 UDB, common communication, sqlccCreateDefaultKeyDB, probe:261
MESSAGE : ZRC=0x00000011=17
          SQL0017N  A RETURN statement must be specified and executed in an SQL 
          function or method.

          DIA8017C Cannot access table token "" with a DROP or ALTER table 
          pending.
DATA #1 : <preformatted>
GSKKM_OpenKeyDbData: GSKit Error = 17,
KeyDB = ,
EncPassLen = 32, PwdLen = 1024, DefaultKeyDBUsed = 1,
ServerCert = /sapmnt/SAP/global/SSL_client/sap_db2sap_agpw03sapdb_ssl_comm_1.arm.

2022-08-16-10.46.25.513224+000 I839476592E416        LEVEL: Error
PID     : 24369                TID : 47445786596672  PROC : dw.sapSAP_D00
INSTANCE: db2sap               NODE : 000
HOSTNAME: agpw03sapap4
FUNCTION: DB2 UDB, common communication, sqlccMapSSLErrorToDB2Error, probe:261
MESSAGE : DIA3604E The SSL function "GSKKM_OpenKeyDbData" failed with the 
                 return code "17" in "sqlccCreateDefaultKeyDB".
====================================================================================


Read more...

Environment

  • Netweaver AS any release
  • Db2 v11.5 GA through v11.5.5.0

Keywords

SQL10013N , -10013 , SQL0017N , SSL , GSKIT , GSKKM , OpenKeyDbData , KBA , XX-INT-DB-DB6PMR , PMR processing by IBM DB2 L2 Support , Problem

About this page

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

Search for additional results

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