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

Product

SAP ERP 6.0

Keywords

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

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.