Tracing the user ID and Password plug-in

1. Ensure that the server has write authority to the ~/sqllib/db2dump/ directory.
2. Add the following text to the ~instance/sqllib/userprofile file:

   export DB2_DSMDB2PW_TRACEFILE=filename

   where filename is a fully qualified path and file name of the trace file, for example ~/sqllib/db2dump/dsmdb2pw.trc.
3. Restart Db2.

After Db2 restarts, trace output is stored in the specified file and directory.

1. To verify that the DB2_VENDOR_INI db2set is set, run the db2set command.
2. If the DB2_VENDOR_INI variable is not set, create a configuration file, for example:

   c:\Program Files\Tivoli\TSM\s1\tsmdbmgr.env

3. Update the configuration file that is listed in the DB2_VENDOR_INI with the location of the trace file:

   DB2_DSMDB2PW_TRACEFILE=c:\Program Files\Tivoli\TSM\s1\sqllib\dsmdb2pw.trc

4. Set up the trace file by issuing the following command:

   db2set -i server_instance DB2_VENDOR_INI=configuration_file_location

   for example:

   db2set -i s1 DB2_VENDOR_INI=c:\Program Files\Tivoli\TSM\s1\tsmdbmgr.env

5. Stop the IBM Storage Protect server and restart it by issuing the following commands:

   halt

   dsmserv -k server_instance

After the server restarts, trace output is stored in the specified file and directory.