|
Problem IC76622
|
Status: Closed |
MEMORY FAULT : WHEN AUTHENTICATION IS CLIENT AT THE SERVER AND NEWPWD IS SPECIFIED FROM THE CLIENT WITHOUT USERID. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
When authentication is client at the server and trying to
connect to server using NEWPWD in the connection string and
there is no UID in the connection string, Memory Fault is
received.
Steps
1. Set the authentication as client at the server.
db2 update dbm cfg using authentication client
2. Now in the client pass this commands
opt callerror on
opt echo on
SQLAllocEnv 1
SQLAllocconnect 1 1
db2trc on
sqldriverconnect 1 0
"PROTOCOL=TCPIP;HOSTNAME=9.124.100.24;DATABASE=test123;PORT=5000
0;newpwd=sdsdsd"
-3 500 SQL_DRIVER_NOPROMPT
There is a Memory Fault.
Issue can be reproducible from all clients. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* When CLI driver is used for remote server. *
****************************************************************
* PROBLEM DESCRIPTION: *
* When authentication is client at the server and trying to *
* connect to server using NEWPWD in the connection string and *
* there is no UID in the connection string, Memory Fault is *
* received. *
* Steps *
* 1. Set the authentication as client at the server. *
* db2 update dbm cfg using authentication client *
* *
* 2. Now in the client pass this commands *
* *
* opt callerror on *
* opt echo on *
* SQLAllocEnv 1 *
* SQLAllocconnect 1 1 *
* db2trc on *
* sqldriverconnect 1 0 *
* "PROTOCOL=TCPIP;HOSTNAME=9.124.100.24;DATABASE=test123;PORT= *
* 50000;newpwd=sdsdsd" -3 500 SQL_DRIVER_NOPROMPT *
* *
* There is a Memory Fault. *
* *
* Issue can be reproducible from all clients. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to db2_v97fp5 or later releases. *
**************************************************************** |
| Local Fix: |
use NEWPWD with UID and PWD in the connection string. |
| 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 |
db2_v97fp5 contains the fix. After the fix, CLI will give proper
error without any memory fault. |
| Workaround |
use NEWPWD with UID and PWD in the connection string. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 25.05.2011
12.12.2011
12.12.2011 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
