Symptom
SQL5154N error occurs when attempting to change DB2 parameters TRUST_ALLCLNTS and TRUST_CLNTAUTH as follows:
- UPDATE DBM CFG USING TRUST_ALLCLNTS NO
SQL5154N The requested combination of configuration values for
"authentication" and "trust_allclnts" is not allowed. Reason code = "1".
- UPDATE DBM CFG USING TRUST_CLNTAUTH SERVER
SQL5154N The requested combination of configuration values for
"authentication" and "trust_clntauth" is not allowed. Reason code = "1".
- The error message displayed is "SQL5154N The requested combination of configuration values for 'authentication' and 'trust_allclnts' is not allowed. Reason code = '1'." and "SQL5154N The requested combination of configuration values for 'authentication' and 'trust_clntauth' is not allowed. Reason code = '1'."
Read more...
Environment
- SAP on IBM DB2 for Linux, UNIX, and Windows
- Db2 version older than 11.5 Fix Pack 9
Product
SAP ERP 6.0 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5
Keywords
TRUST_ALLCLNTS, TRUST_CLNTAUTH, SQL5154N, AUTHENTICATION , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-DB-DB6-DBA , Database Administration , 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.
SAP Knowledge Base Article - Preview