home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC75895 Status: Closed

SQL30082 RC=17 RETURNED WHEN AUTHENTICATION=DATA_ENCRYPT AND
ALTERNATE_AUTH_ENC IS NOT SET TO NOT_SPECIFIED

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
ALTERNATE_AUTH_ENC is not supported when 
AUTHENTICATION=DATA_ENCRYPT 
 
The UPDATE DBM CFG USING ALTERNATE_AUTH_ENC <AES_CMP OR 
AES_ONLY> 
should fail if Authentication=DATA_ENCRYPT 
and 
UPDATE DBM CFG USING AUTHENTICATION DATA_ENCRYPT 
should fail if ALTERNATE_AUTH_ENC = <AES_CMP OR AES_ONLY>
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* SQL30082 RC=17 Returned when AUTHENTICATION=DATA_ENCRYPT and * 
* ALTERNATE_AUTH_ENC <> NOT_SPECIFIED                          * 
*                                                              * 
* ALTERNATE_AUTH_ENC is not supported when                     * 
* AUTHENTICATION=DATA_ENCRYPT                                  * 
*                                                              * 
*                                                              * 
*                                                              * 
* The UPDATE DBM CFG USING ALTERNATE_AUTH_ENC <AES_CMP OR      * 
* AES_ONLY>                                                    * 
*                                                              * 
* should fail if Authentication=DATA_ENCRYPT                   * 
*                                                              * 
* and                                                          * 
*                                                              * 
*                                                              * 
* UPDATE DBM CFG USING AUTHENTICATION DATA_ENCRYPT             * 
*                                                              * 
* should fail if ALTERNATE_AUTH_ENC = <AES_CMP OR AES_ONLY>    * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 UDB Version 9.7 Fix Pack 5.                   * 
****************************************************************
Local Fix:
When using AUTHENTICATION=DATA_ENCRYPT set ALTERNATE_AUTH_ENC to 
NOT_SPECIFIED.
available fix packs:
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Solution
Problem was first fixed in DB2 UDB Version 9.7 Fix Pack 5
Workaround
When using AUTHENTICATION=DATA_ENCRYPT set ALTERNATE_AUTH_ENC to 
NOT_SPECIFIED.
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
20.04.2011
17.01.2012
17.01.2012
Problem solved at the following versions (IBM BugInfos)
9.7.FP5
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.5 FixList