| Message: 62586 |
 |
BY: Francesco Pellegrini (kranz)
DATE: 2008-11-28 22:36
SUBJECT: RE: Problems with connection to iseries DB Hi Praveen,
i did what you suggest and here is the trace
[ Process: 7692, Thread: -1210726736 ]
[ Date & Time: 11/28/2008 22:35:12.728338 ]
[ Product: QDB2/LINUX DB2 v9.5.0.0 ]
[ Level Identifier: 03010107 ]
[ CLI Driver Version: 09.02.0000 ]
[ Informational Tokens: "DB2 v9.5.0.0","s071001","LINUXIA3295","Fixpack 0" ]
[ Install Path: /opt/ibm/db2/V9.5 ]
[ db2cli.ini Location: /var/log/db2cli.ini ]
[ CLI Driver Type: IBM DB2 Application Runtime Client ]
SQLAllocHandle( fHandleType=SQL_HANDLE_ENV, hInput=0:0, phOutput=&08628b18 )
---> Time elapsed - 0 seconds
SQLAllocHandle( phOutput=0:1 )
<--- SQL_SUCCESS Time elapsed - +7.490000E-004 seconds
SQLSetEnvAttr( hEnv=0:1, fAttribute=SQL_ATTR_ODBC_VERSION, vParam=3, cbParam=0 )
---> Time elapsed - +1.310000E-004 seconds
SQLSetEnvAttr( )
<--- SQL_SUCCESS Time elapsed - +5.500000E-005 seconds
SQLAllocHandle( fHandleType=SQL_HANDLE_DBC, hInput=0:1, phOutput=&08628b1c )
---> Time elapsed - +1.900000E-005 seconds
SQLAllocHandle( phOutput=0:1 )
<--- SQL_SUCCESS Time elapsed - +4.160000E-004 seconds
SQLSetConnectAttr( hDbc=0:1, fOption=SQL_ATTR_AUTOCOMMIT, pvParam=&00000001, iStrLen=-3 )
---> Time elapsed - +2.900000E-005 seconds
SQLSetConnectAttr( )
<--- SQL_SUCCESS Time elapsed - +5.600000E-005 seconds
SQLSetConnectAttr( hDbc=0:1, fOption=SQL_ATTR_INFO_APPLNAME, pvParam=&0877ada8, iStrLen=-3 )
---> Time elapsed - +6.200000E-005 seconds
SQLSetConnectAttr( )
<--- SQL_SUCCESS Time elapsed - +5.500000E-005 seconds
SQLSetConnectAttr( hDbc=0:1, fOption=SQL_ATTR_INFO_ACCTSTR, pvParam=&08798b38, iStrLen=-3 )
---> Time elapsed - +1.700000E-005 seconds
SQLSetConnectAttr( )
<--- SQL_SUCCESS Time elapsed - +3.300000E-005 seconds
SQLDriverConnect( hDbc=0:1, hwnd=0:0, szConnStrIn="DRIVER={IBM DB2 ODBC DRIVER}; DATABASE=S653568C; HOSTNAME=s44a3312.sogegross.it; PORT=446; PROTOCOL=TCPIP; UID=QPGMR; PWD=*****;", cbConnStrIn=-3, szConnStrOut=<NULL pointer>, cbConnStrOutMax=0, pcbConnStrOut=<NULL pointer>, fDriverCompletion=SQL_DRIVER_NOPROMPT )
---> Time elapsed - +4.100000E-005 seconds
SQLDriverConnect( )
<--- SQL_ERROR Time elapsed - +1.841060E-001 seconds
SQLGetDiagRec( fHandleType=SQL_HANDLE_DBC, hHandle=0:1, iRecNumber=1, pszSqlState=&bf8d814a, pfNativeError=&bf8d8150, pszErrorMsg=&bf8d8567, cbErrorMsgMax=1025, pcbErrorMsg=&bf8d8156 )
---> Time elapsed - +8.300000E-005 seconds
( iRowNumber=-1, iColumnNumber=-2 )
SQLGetDiagRec( pszSqlState="08001", pfNativeError=-30082, pszErrorMsg="[IBM][CLI Driver] SQL30082N Security processing failed with reason "17" ("UNSUPPORTED FUNCTION"). SQLSTATE=08001
", pcbErrorMsg=115 )
<--- SQL_SUCCESS Time elapsed - +3.364000E-003 seconds
SQLFreeHandle( fHandleType=SQL_HANDLE_DBC, hHandle=0:1 )
---> Time elapsed - +6.800000E-005 seconds
( Number of allocations left before we freed the Pool=1 )
SQLFreeHandle( )
<--- SQL_SUCCESS Time elapsed - +1.130000E-004 seconds
SQLFreeHandle( fHandleType=SQL_HANDLE_ENV, hHandle=0:1 )
---> Time elapsed - +1.700000E-005 seconds
SQLFreeHandle( )
<--- SQL_SUCCESS Time elapsed - +7.600000E-005 seconds
The error is always the same, but i cannot reproduce the case i described before.
This is because I think I made some confusion in repeating the commands while in debug mode. Anyway the problem still resist
| |
Start New Thread
Problems with connection to iseries DB