2777452 - DB6: Database update hangs due to missing ATM policy

Symptom

You notice SWPM tool gets hang at phase of updating database.
The database update log file shows it is trying to adapt ATM (Automatic Table Maintenance) policy.
But the policy table does not exist.

sapinst_dev.log
...

INFO 2019-06-19 01:02:03.252 (root/sapinst) (startInstallation) 
Output of /tmp/sapinst_instdir/<Release_Info>/AS-ABAP/DB6/CENTRAL/db6_update_db.sh -d <DBSID> -k -a is written to the logfile db6_update_db.log.

db6_update_db.log
...

DEBUG: () : ACTION_TEXT: Adapt ATM policy if rquired

Adapt ATM policy if rquired

db2diag.log

2019-06-19-01.02.03.754221+330 I7418256E348 LEVEL: Warning
PID : 12345 TID : 111111111111080 PROC : db2fmp (
INSTANCE: db2abc NODE : 000
APPID : *LOCAL.db2abc.190618202723
HOSTNAME: abc123
FUNCTION: DB2 UDB, Policy, sqlpiCheckPolicyTable, probe:100
DATA #1 : <preformatted>
Policy Table does not exist

Environment

SAP on IBM Db2 for Linux, UNIX, and Windows

Product

SAP ERP 6.0

Keywords

db6_update_db, ATM policy , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-DB-DB6-INS , Installation SAP System , 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.