SAP Knowledge Base Article - Preview

2664241 - DB6: SQL5153N error when updating logarchmeth1

Symptom

For a non-production system, you want to turn off log archiving temporarily. 
You get following error when updating the database configuration parameter "logarchmeth1".

2018-06-01-11.56.18.123456+240                      LEVEL: Warning
PID     : 17629364             TID : 23456          PROC : db2sysc 0
INSTANCE: db2ABC               NODE : 000           DB   : ABC
APPHDL  : 0-12345              APPID: *LOCAL.db2ABC.xxxxxxxxx
AUTHID  : DB2ABC               HOSTNAME: xxxxxxxx
EDUID   : 23456                EDUNAME: db2agent (ABC) 0
FUNCTION: DB2 UDB, config/install, sqlfdbchk, probe:2927
MESSAGE : ZRC=0xFFFFEBDF=-5153
          SQL5153N  The update cannot be completed because the following

          relationship would be violated: "".
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -5153   sqlerrml: 60
sqlerrmc: logsecond can only be set to -1 if log archiving is enabled


Read more...

Environment

SAP on IBM Db2 for Linux, UNIX, and Windows

Keywords

SQL5153N, violated, logsecond, logarchmeth1 , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-DB-DB6-DBA , Database Administration , How To

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.