IBM Support

DB2 9.7 to 10.5 database upgrade fails.

Troubleshooting


Problem

The db2 upgrade database command may fail even while the db2ckupgrade command runs success.

Symptom


Resolving The Problem

db2 upgarde database fails with below error.

$ db2 upgrade database testdb
SQL0440N No authorized routine named "DBMS_UTILITY.GETINDEXDEPENDENCY"
of
type "PROCEDURE" having compatible arguments was found. LINE NUMBER=1.
SQLSTATE=42884

When you run one of the below queries you will find some views or tables that are invalidated that db2ckupgrade missed.

SELECT * FROM SYSIBM.SYSTABLES WHERE STATUS <> 'N'

db2 "select substr(OBJECTSCHEMA,1,25) as OBJ,OBJECTNAME, INVALIDATE_TIME, OBJECTTYPE from SYSCAT.INVALIDOBJECTS";

Once you drop the invalid object the upgrade will run successfully.

APAR IT17015 addresses this issue.

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Install\/Migrate\/Upgrade - Licensing","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21991180

Page Feedback