IT19925: ENCRLIB AND ENCROPTS VALUES MAY BE DISPLAYED INCORRECTLY, OR NOTDISPLAYED AT ALL, WHEN USING A V11.1 CLIENT TO DOWNLEVEL SERVER

DB2 Version 11.1 Mod 2 Fix Pack 2 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod2 Fix Pack2 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod2 Fix Pack2 iFix002 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod4 Fix Pack4 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 4 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 5 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 7 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• When an v11.1 db2 client is connected to a downlevel database
  server, then a GET DATABASE CONFIG operation performed on the
  client may incorrectly display the ENCRLIB and ENCROPTS values,
  as described below:
  
  When connected to a v10.1 fixpack4 or later db2 server, or a
  v10.5 fixpack3 or later db2 server, the ENCRLIB and ENCROPTS
  values will never be displayed, even if they are configured on
  the database server.
  
  When connected to a v10.1 fixpack3 or earlier db2 server, or a
  v10.5 fixpack2 or earlier db2 server, or a db2 server from v9.7
  or previous releases, the ENCRLIB and ENCROPTS values will be
  displayed with garbage values, even though they do not exist on
  the database server.
  

Local fix

• Execute the GET DB CONFIG operation directly on the database
  server, or use the DBCFG administrative view or the DB_GET_CFG
  table function to query the database configuration values.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * ALL                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to DB2 11.1 Mod 2 Fix Pack 2 or higher               *
  ****************************************************************
  

Problem conclusion

• First fixed in DB2 11.1 Mod 2 Fix Pack 2
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels

• RB10 PSN

     UP