home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IT08329 Status: Geschlossen

MISSING PASSWORD FOR REMOTE CONNECTIONS AND INVALID STATEMENT HANDLE FOR
STATEMENT TYPE AND SUPPORT OF OCI_ATTR_SPOOL_AUTH

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
This APAR addresses 3 issues as follows: 
 
1)  Adding support of the attribute OCI_ATTR_SPOOL_AUTH; 
 
2)  The function OCIAttrGet returns OCI_INVALID_HANDLE error 
when retrieving statement type (OCI_ATTR_STMT_TYPE) with pooling 
on for a statement prepared using ocistmtprepare2(). 
 
Below is the example of DB2CI trace entries you may see when the 
issue occurs: 
 
OCIAttrGet( hHandle=&2012e060, fHandleType="OCI_HTYPE_STMT", 
pValue=&20019ece, pcbValue=<NULL pointer>, fAttribute="24", 
hError=&20075ff0 ) 
    ---> Time elapsed - +1.024000E-003 seconds 
 
OCIAttrGet( ) 
    <--- OCI_INVALID_HANDLE   Time elapsed - +1.292600E-002 
seconds 
 
 
3) When accessing a remote database and the initial connection 
pool ran out, OCISessionGet function fails to allocate a new 
session with the error - "[IBM][OCI Driver] SQL30082N  Security 
processing failed with reason "3" ("PASSWORD MISSING"). 
SQLSTATE=08001". The issue doesn't occur with a local database. 
 
Below is the example of DB2CI trace entries you may see when the 
issue occurs: 
 
OCISessionGet( envhp=&23cf9150, errhp=&23dc3a40, 
svchp=&23e34c7c, *svchp=<NULL pointer>, authInfop=<NULL 
pointer>, dbName="DB2CISPOOL0", dbname_len=11, tagInfo=<NULL 
pointer>, tagInfo_len=0, retTagInfo=&268bf52c, 
retTagInfo_len=&268bf530, found=&268bf520, mode=1 ) 
    ---> Time elapsed - +1.104000E-003 seconds 
 
OCISessionGet( svchp=<NULL pointer>, retTagInfo_len=0, found=0 ) 
    <--- OCI_ERROR   Time elapsed - +1.402910E-001 seconds 
 
OCIErrorGet( hError=&23dc3a40, iIndex=1, sqlstate=<NULL 
pointer>, sqlcode=&23e45638, message=&23e4564c, 
message_length=512, fHandleType="OCI_HTYPE_ERROR" ) 
    ---> Time elapsed - +1.028000E-003 seconds 
 
OCIErrorGet( sqlcode=-30082, message="[IBM][OCI Driver] 
SQL30082N  Security processing failed with reason "3" ("PASSWORD 
MISSING").  SQLSTATE=08001 
" )
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* -All users using DB2 CI driver                               * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.5 Fix Pack 7                       * 
****************************************************************
Local-Fix:
N/A
Lösung
First fixed in DB2 Version 10.5 Fix Pack 7
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
15.04.2015
25.01.2016
25.01.2016
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.7 FixList