DB2 - Problem description
Problem IT34697 | Status: Closed |
DB2BATCH FAILS TO CAPTURE MONITORING STATISTICS FOR REMOTE INSTANCES IN A KERBEROS ENVIRONMENT | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
In a kerberos environment where no userid and password is used for remote connections, "db2batch -mms" without the "-a" parameter fails to issue snapshots on remote instances. An error message "CLI error in capturing monitoring statistics" is returned. Here are example messages including the error message: cat $HOME/my-sql select count(*) from syscat.tables ; --#SET SNAPSHOT agent_id; db2batch -d sample -f $HOME/my-sql -mss agent_id * Timestamp: Tue Oct 06 2020 11:36:39 EDT --------------------------------------------- * SQL Statement Number 1: select count(*) from syscat.tables ; 1 ----------- 479 *** SQLERRP=SQLJCMN SQL1032N No start database manager command was issued. SQLSTATE=57019 *** CLI error in capturing monitoring statistics * Summary Table: Type Number Repetitions Total Time (s) Min Time (s) Max Time (s) Arithmetic Mean Geometric Mean Row(s) Fetched Row(s) Output --------- ----------- ----------- -------------- -------------- -------------- --------------- -------------- -------------- ------------- * Total Entries: 0 * Total Time: 0.000000 seconds * Minimum Time: 0.000000 seconds * Maximum Time: 0.000000 seconds * Arithmetic Mean Time: 0.000000 seconds * Geometric Mean Time: 0.000000 seconds | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All users using Kerberos with db2batch * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1 Mod 4 Fixpack 6 or higher * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * All users using Kerberos with db2batch * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1 Mod 4 Fixpack 6 or higher * **************************************************************** | |
Comment | |
First fixed in Db2 11.1 Mod 4 Fixpack 6 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 27.10.2020 15.03.2021 15.03.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |