How to enable DB2 diagnostic logs and get matching Centrify logs/config files?
On the DB2 server running Centrify DB2 plugin, enable debugging for Centrify DirectControl and the DB2 logging
as shown below:
1) As root:
# /usr/share/centrifydc/bin/addebug on
# /usr/share/centrifydc/bin/addebug clear
2) As DB2 admin:
$ db2 update dbm config using diaglevel 4
$ db2 update dbm config using notifylevel 4
$ db2stop
$ db2start
This will now cause DB2 to print out all messages that the Centrify plugins tells it to print out. The messages will be
printed out to the DB2 log located at: <instanceHome>/sqllib/db2dump/db2diag.log.
All plugin error messages contain the name of the plugin that they come from.
Please remember to revert back to diaglevel and notifylevel 3 after issue is reproduced.
3) db2 get dbm config > /tmp/db2config.txt
4) Attempt db2 connect and let it fail. Note down the **exact error message**
5) Turn off addebug
# /usr/share/centrifydc/bin/addebug off
6) Collect user information:
If using an AD account, run
a) adquery user <AD username> -A > /tmp/adquery.txt
b) dzinfo <AD username> -A > /tmp/dzinfo.txt
If using a local account:
a) grep <local username> /etc/passwd > /tmp/localuser
b) grep <local username> /etc/group > /tmp/group
7) Tar up environment variables and log:
# adinfo -t
8) Email or ftp support the following files.
a) <instanceHome>/sqllib/db2dump/db2diag.log.
b) error message from step 4
c) /tmp/db2config.txt
d) /tmp/adquery.txt
e) /tmp/dzinfo.txt
f) /tmp/localuser
g) /tmp/group
h) /var/centrify/tmp/adinfo_support.tar.gz