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.