Troubleshooting
Problem
After applying a patch for DB2, Java Webstart client connection fails with error KFWITM402E.
Symptom
The error in the <hostname>_cq_<hextimestamp>-01. log:
SQL2439N The routine could not be run because the routine definition has changed and the db2updvXX tool has not been used to update routine definitions., GENERIC SQLSTATE: , ERR: -2439
Cause
Stored Procedure problem after DB2 patch.
Environment
Tivoli Enterprise Portal Server v6.3.0.7
DB2 to version 11.1.4FP7
Diagnosing The Problem
After applying a special build, the invocation of system defined stored procedures and user defined functions results in SQL2439N.
e.g.
Db2 "select prod_release from
table(sysproc.env_get_prod_info())"
Db2 "select prod_release from
table(sysproc.env_get_prod_info())"
SQL2439N The routine could not be run because the routine definition has changed and the db2updvXX tool has not been used to update routine definitions.
(More details on this SQL message are available via
https://www.ibm.com/docs/en/db2/11.5?topic=messages-sql2250-sql2499#sql2439n)
Resolving The Problem
The DBA must execute db2updvXX against the database with the -a option where XX means the current version of DB2. The XX value changes each time db2updvXX is run.
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"","label":""},"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SSCTLMQ","label":"ITM Tivoli Enterprise Portal Server V6"},"ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"},{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSFHEG","label":"DB2 Enterprise Server Edition"},"ARM Category":[{"code":"a8m500000008PkiAAE","label":"Administrative Tools"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Product Synonym
ITM
Was this topic helpful?
Document Information
Modified date:
01 August 2022
UID
ibm16595471