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 IC69230 Status: Closed

UNKNOWN OPTION IN DB2CLI FOR PING-DB

product:
DB2 CONNECT / DB2CONNCT / 970 - DB2
Problem description:
An option 'unknown' is seen with the output of Ping-DB 
attributes 
ex: 
> SQLGetconnectattr 1 sql_attr_ping_request_packet_size 
SQLGetConnectAttr: rc = 0 (SQL_SUCCESS) 
Option (Unknown) = 1 
Output length = 4 
> SQLGetconnectattr 1 sql_attr_ping_ntimes 
SQLGetConnectAttr: rc = 0 (SQL_SUCCESS) 
Option (Unknown) = 32767 
Output length = 4 
 
This is confusing to the user.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All platforms, db2cli users                                  * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* An option 'unknown' is seen with the output of Ping-DB       * 
*                                                              * 
* attributes                                                   * 
*                                                              * 
* ex:                                                          * 
*                                                              * 
* > SQLGetconnectattr 1 sql_attr_ping_request_packet_size      * 
*                                                              * 
* SQLGetConnectAttr: rc = 0 (SQL_SUCCESS)                      * 
*                                                              * 
* Option (Unknown) = 1                                         * 
*                                                              * 
* Output length = 4                                            * 
*                                                              * 
* > SQLGetconnectattr 1 sql_attr_ping_ntimes                   * 
*                                                              * 
* SQLGetConnectAttr: rc = 0 (SQL_SUCCESS)                      * 
*                                                              * 
* Option (Unknown) = 32767                                     * 
*                                                              * 
* Output length = 4                                            * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to db2_v97fp3 or later version                       * 
****************************************************************
Local Fix:
available fix packs:
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
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_v97fp3 
The option value will be given appropriately.
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC69671 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
15.06.2010
16.09.2010
16.09.2010
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.3 FixList
9.7.0.3 FixList