DB2 FOR LUW / DB2FORLUW / B10 - DB2

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

****************************************************************
* 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                *
****************************************************************

****************************************************************
* 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                *
****************************************************************

First fixed in Db2 11.1 Mod 4 Fixpack 6

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

27.10.2020
15.03.2021
15.03.2021