DB2 - SQL0471N Invocation of routine error message

Troubleshooting

Problem

The DB2 database was upgraded. The version of the database and the used database client are supported with the used IBM Cognos Impromptu 7.4 version. But if you open the catalog and verify the tables the following error message occurs:

Symptom

[IBM][CLI Driver][DB2] SQL0471N Invocation of routine "SYSIBM.SQLTABLES" failed due to reason "00E7900C". SQLSTATE=55023

Cause

The required stored procedures are not enabled in the database after upgrade.

Environment

Windows Cognos Impromptu 7.4 IBM Cognos Impromptu Web Reports 7.4 Database DB2 8.1.0 on OS/390

Resolving The Problem

Contact your DBAdmins and let them verify if the required stored procedures are enabled on the DB2 database. The required stored procedures are: JAVA Database Connectivity (JDBC) Open Database Connectivity (ODBC)

[{"Product":{"code":"SSTQPQ","label":"IBM Cognos Series 7 PowerPlay"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Impromptu","Platform":[{"code":"PF033","label":"Windows"}],"Version":"Impromptu 7.4","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Historical Number

1033799

Was this topic helpful?

Document Information

Modified date:
15 June 2018

UID

swg21351101

Tips