ADSM-L
[Top] [All Lists]
<prev [Date] next>
[Advanced]
 <prev [Thread] next>

Re: Connect to TSM ODBC Driver with Regina and Rexx/SQL for ODBC no longer possible

2003-04-15 11:54:00
Subject: Re: Connect to TSM ODBC Driver with Regina and Rexx/SQL for ODBC no longer possible
From: Christian Bagard <christian.bagard AT WANADOO DOT FR>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 15 Apr 2003 17:55:52 +0200 
Andy,

Thanks for your answer.
The problem occurs when Tracing tab in the ODBC Data Source Administrator is
enabled.

At the end of this file, I have copied the begining of the "TSM-specific
ODBC driver tracing"
(when it works) where we can see that the "set auto-commit"  is also present
!

We use Rexx Regina and Rexx/SQL-ODBC from Mark Hessling (during this
prototyping step)
http://www.lightlink.com/hessling/index.html
It seems than Rexx/SQL doesn't react correctly (on the return codes ?) when
this tracing is enabled.
Apart this, it works fine.

The SQLSetConnectOption is performed by Rexx/SQL interface (not by Regina
itself).
And we have no control on it.
In Regina we send a SQLConnect command  like this :
--------------------------------------------------------
username = 'SOSLOG'
password = 'SOSLOG'
database = 'TSMODBC'
/* name of TSM ODBC Driver
server   = ''
If RxFuncQuery('SQLLoadFuncs') then do                     /*Load Rexx/SQL */
   call RxFuncAdd 'SQLLoadFuncs', 'rexxsql', 'SQLLoadFuncs'
   call SQLLoadFuncs
end
rtt = SQLConnect( 'SOS', username, password, database, server )  
if rtt < 0 Then Abort( 'connecting' )
----------------------------------------------------------

If you need the whole trace file, I'll send it you directly.

We have also the length message (256) problem but you already answered.
In France, West Tivoli Software Support Team says that il will be fixed in
TSM 5.1.7.0 in may/june.
But 5.2 is already there ?

Best regards and thanks again

Christian Bagard
Tél : (33) 04 42 93 08 13
email : c.bagard AT sos-restore DOT com

SOS-Restore - 32 cours Mirabeau - 13100 Aix-en-Provence - France
www.sos-restore.com


Tue Apr 15 16:37:21 2003 00000608 0000054c
DllMain.cpp( 218): --------------------------------- BEGIN
TRACE ---------------------------------

Tue Apr 15 16:37:21 2003 00000608 0000054c DllMain.cpp( 220): Tivoli Storage
Manager ODBC Driver
Tue Apr 15 16:37:21 2003 00000608 0000054c DllMain.cpp( 229): Version
5.1.5.0

Tue Apr 15 16:37:21 2003 00000608 0000054c DllMain.cpp( 230): Entering
DllMain() - DLL_PROCESS_ATTACH.
Tue Apr 15 16:37:21 2003 00000608 0000054c DllMain.cpp( 289): Exiting
DllMain(), rc = 'true'.
Tue Apr 15 16:37:21 2003 00000608 0000054c SQLAllocHandle.cpp( 207):
Entering SQLAllocHandle()
Tue Apr 15 16:37:21 2003 00000608 0000054c SQLAllocHandle.cpp( 238):
HandleType = Environment (1)
Tue Apr 15 16:37:21 2003 00000608 0000054c SQLAllocHandle.cpp( 240):
InputHandle = 0x00000000
Tue Apr 15 16:37:21 2003 00000608 0000054c SQLAllocHandle.cpp( 242):
OutputHandle = 0x009817a4
Tue Apr 15 16:37:21 2003 00000608 0000054c SQLAllocHandle.cpp( 296):
Entering tsmAllocHandleEnv()
Tue Apr 15 16:37:21 2003 00000608 0000054c SQLAllocHandle.cpp( 298): hEnv =
0x009817a4
Tue Apr 15 16:37:21 2003 00000608 0000054c Common.cpp( 502): Entering
tsmCreateMutex()
Tue Apr 15 16:37:21 2003 00000608 0000054c Common.cpp( 518): Exiting
tsmCreateMutex()
Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 4527): Entering
tsmMapSqlState()
Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 4529): stateStr =
0x015df13a
Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 4531): stateCode = 0
Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 4533): odbcVer = 3
Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 4535): funcName =
'SQLAllocHandle'
Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 4750): Exiting
tsmMapSqlState(), stateStr = '00000'
Tue Apr 15 16:37:22 2003 00000608 0000054c SQLAllocHandle.cpp( 409): hEnv =
0x015df118

------------
----------- etc.
-----------

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLConnect.cpp( 139):
ConnectionHandle = 0x015e79d4.

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLConnect.cpp( 141): ServerName
= 0x00981878.

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLConnect.cpp( 143): NameLength1
= 7.

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLConnect.cpp( 145): UserName =
0x00981898.

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLConnect.cpp( 147): NameLength2
= 6.

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLConnect.cpp( 149):
Authentication = 0x009818b8.

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLConnect.cpp( 151): NameLength3
= 6.

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 533): Entering
tsmLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 535): mutex =
0x000000b8

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 552): Exiting
tsmLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 533): Entering
tsmLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 535): mutex =
0x000000a0

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 552): Exiting
tsmLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLConnect.cpp( 222): ServerName
= 'TSMODBC'.

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLConnect.cpp( 224): UserName =
'SOSLOG'.

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLConnect.cpp( 226):
Authentication = 'SOSLOG'.

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 4771): Entering
GetDsnValue()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 4773): hDbc =
015e79d4

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 4780): tsmValueType =
TSM_REG_TCPADDR (1)

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 4782): szValue =
015e7bc5

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 4784): bufferLen = 65

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 4786): iValue =
00000000

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 4805): Retrieved
TCP/IP server address, string='192.168.1.15'



------------
----------- etc.
-----------

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetInfo.cpp( 160): InfoType =
SQL_CURSOR_COMMIT_BEHAVIOR (23)

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetInfo.cpp( 162):
InfoValuePtr = 9967600

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetInfo.cpp( 164):
BufferLength = 2

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetInfo.cpp( 166):
StringLengthPtr = 1241304

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 533): Entering
tsmLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 535): mutex =
0x000000b8

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 552): Exiting
tsmLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 533): Entering
tsmLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 535): mutex =
0x000000a0

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 552): Exiting
tsmLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetInfo.cpp( 1131): Exiting
SQLGetInfo(), rc = 0

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 567): Entering
tsmUnLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 569): mutex =
0x000000a0

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 586): Exiting
tsmUnlockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 567): Entering
tsmUnLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 569): mutex =
0x000000b8

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 586): Exiting
tsmUnlockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetInfo.cpp( 151): Entering
SQLGetInfo()

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetInfo.cpp( 153):
ConnectionHandle = 0x015e79d4

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetInfo.cpp( 160): InfoType =
SQL_CURSOR_ROLLBACK_BEHAVIOR (24)

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetInfo.cpp( 162):
InfoValuePtr = 9967602

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetInfo.cpp( 164):
BufferLength = 2

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetInfo.cpp( 166):
StringLengthPtr = 1241304

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 533): Entering
tsmLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 535): mutex =
0x000000b8

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 552): Exiting
tsmLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 533): Entering
tsmLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 535): mutex =
0x000000a0

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 552): Exiting
tsmLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetInfo.cpp( 1131): Exiting
SQLGetInfo(), rc = 0

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 567): Entering
tsmUnLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 569): mutex =
0x000000a0

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 586): Exiting
tsmUnlockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 567): Entering
tsmUnLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 569): mutex =
0x000000b8

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 586): Exiting
tsmUnlockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLSetConnectAttr.cpp( 128):
Entering SQLSetConnectAttr()

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLSetConnectAttr.cpp( 130):
ConnectionHandle = 0x015e79d4

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLSetConnectAttr.cpp( 132):
Attribute = 102

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLSetConnectAttr.cpp( 134):
ValuePtr = 0x00000000

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLSetConnectAttr.cpp( 136):
StringLength = 0

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 533): Entering
tsmLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 535): mutex =
0x000000b8

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 552): Exiting
tsmLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLSetConnectAttr.cpp( 197):
Attribute = SQL_ATTR_AUTOCOMMIT

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 4527): Entering
tsmMapSqlState()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 4529): stateStr =
0x015e7ac0

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 4531): stateCode = 99

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 4533): odbcVer = 2

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 4535): funcName =
'SQLSetConnectAttr'

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 4750): Exiting
tsmMapSqlState(), stateStr = 'S1C00'

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 567): Entering
tsmUnLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 569): mutex =
0x000000b8

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 586): Exiting
tsmUnlockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLSetConnectAttr.cpp( 361):
Exiting SQLSetConnectAttr(), rc = -1

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetDiagRec.cpp( 134): Entering
SQLGetDiagRec()

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetDiagRec.cpp( 164):
HandleType = Connection (2)

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetDiagRec.cpp( 166): Handle =
0x015e79d4

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetDiagRec.cpp( 168):
RecNumber = 1

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetDiagRec.cpp( 170): SqlState
= 0x0012eb5c

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetDiagRec.cpp( 172):
NativeErrorPtr = 0x0012f058

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetDiagRec.cpp( 174):
MessageText = 0x00981898

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetDiagRec.cpp( 176):
BufferLength = 512

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetDiagRec.cpp( 178):
TextLengthPtr = 0x0012f068

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 533): Entering
tsmLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 535): mutex =
0x000000b8

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 552): Exiting
tsmLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 567): Entering
tsmUnLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 569): mutex =
0x000000b8

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 586): Exiting
tsmUnlockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetDiagRec.cpp( 367): SQL
state = 'S1C00'

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetDiagRec.cpp( 369): Error
message = 'Optional feature not implemented.'

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetDiagRec.cpp( 378): Exiting
SQLGetDiagRec(), rc = 0

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetDiagRec.cpp( 134): Entering
SQLGetDiagRec()

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetDiagRec.cpp( 164):
HandleType = Connection (2)

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetDiagRec.cpp( 166): Handle =
0x015e79d4

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetDiagRec.cpp( 168):
RecNumber = 2

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetDiagRec.cpp( 170): SqlState
= 0x0012eb5c

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetDiagRec.cpp( 172):
NativeErrorPtr = 0x0012f058

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetDiagRec.cpp( 174):
MessageText = 0x00981898

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetDiagRec.cpp( 176):
BufferLength = 512

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetDiagRec.cpp( 178):
TextLengthPtr = 0x0012f068

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 533): Entering
tsmLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 535): mutex =
0x000000b8

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 552): Exiting
tsmLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetDiagRec.cpp( 274): Exiting
SQLGetDiagRec(), rc = 100

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 567): Entering
tsmUnLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 569): mutex =
0x000000b8

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 586): Exiting
tsmUnlockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetInfo.cpp( 151): Entering
SQLGetInfo()

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetInfo.cpp( 153):
ConnectionHandle = 0x015e79d4

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetInfo.cpp( 160): InfoType =
SQL_GETDATA_EXTENSIONS (81)

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetInfo.cpp( 162):
InfoValuePtr = 1241824

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetInfo.cpp( 164):
BufferLength = 4

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetInfo.cpp( 166):
StringLengthPtr = 1241830

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 533): Entering
tsmLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 535): mutex =
0x000000b8

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 552): Exiting
tsmLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 533): Entering
tsmLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 535): mutex =
0x000000a0

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 552): Exiting
tsmLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetInfo.cpp( 1131): Exiting
SQLGetInfo(), rc = 0

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 567): Entering
tsmUnLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 569): mutex =
0x000000a0

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 586): Exiting
tsmUnlockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 567): Entering
tsmUnLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 569): mutex =
0x000000b8

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 586): Exiting
tsmUnlockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetInfo.cpp( 151): Entering
SQLGetInfo()

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetInfo.cpp( 153):
ConnectionHandle = 0x015e79d4

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetInfo.cpp( 160): InfoType =
SQL_TXN_CAPABLE (46)

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetInfo.cpp( 162):
InfoValuePtr = 1241752

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetInfo.cpp( 164):
BufferLength = 2

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetInfo.cpp( 166):
StringLengthPtr = 1241756

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 533): Entering
tsmLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 535): mutex =
0x000000b8

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 552): Exiting
tsmLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 533): Entering
tsmLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 535): mutex =
0x000000a0

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 552): Exiting
tsmLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetInfo.cpp( 1131): Exiting
SQLGetInfo(), rc = 0

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 567): Entering
tsmUnLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 569): mutex =
0x000000a0

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 586): Exiting
tsmUnlockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 567): Entering
tsmUnLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 569): mutex =
0x000000b8

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 586): Exiting
tsmUnlockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLAllocHandle.cpp( 207):
Entering SQLAllocHandle()

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLAllocHandle.cpp( 238):
HandleType = Statement (3)

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLAllocHandle.cpp( 240):
InputHandle = 0x015e79d4

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLAllocHandle.cpp( 242):
OutputHandle = 0x009818d0

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLAllocHandle.cpp( 632):
Entering tsmAllocHandleStmt()

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLAllocHandle.cpp( 634): hDbc =
0x015e79d4

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLAllocHandle.cpp( 636): hStmt =
0x009818d0

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLAllocHandle.cpp( 637): Calling
tsmLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 533): Entering
tsmLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 535): mutex =
0x000000b8

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 552): Exiting
tsmLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLAllocHandle.cpp( 649): Calling
tsmLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 533): Entering
tsmLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 535): mutex =
0x000000a0

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 552): Exiting
tsmLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 502): Entering
tsmCreateMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 518): Exiting
tsmCreateMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLAllocHandle.cpp( 906):
Statement session opened successfully.

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLAllocHandle.cpp( 919): Server
version = 5.1.6.3

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 4360): Entering
tsmAddStmtToList()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 4362): hDbc =
0x015e79d4

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 4364): hStmt =
0x015f26fc

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 4428): Entering
tsmFindStmtInList()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 4430): hDbc =
0x015e79d4

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 4432): hStmt =
0x015f26fc

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 4453): stmt was not
found in the list

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 4455): Exiting
tsmFindStmtInList()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 4370): stmt does not
exist in the list

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 4390): New stmt added
successfully

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 4410): Exiting
tsmAddStmtToList(), hDbc->odbcStmtList = 0x0160933c

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 4527): Entering
tsmMapSqlState()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 4529): stateStr =
0x015f30eb

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 4531): stateCode = 0

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 4533): odbcVer = 2

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 4535): funcName =
'SQLAllocHandle'

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 4750): Exiting
tsmMapSqlState(), stateStr = '00000'

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 567): Entering
tsmUnLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 569): mutex =
0x000000a0

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 586): Exiting
tsmUnlockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 567): Entering
tsmUnLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 569): mutex =
0x000000b8

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 586): Exiting
tsmUnlockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLAllocHandle.cpp( 954): hStmt =
0x015f26fc

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLAllocHandle.cpp( 274): Exiting
SQLAllocHandle()

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetStmtAttr.cpp( 116):
Entering SQLGetStmtAttr()

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetStmtAttr.cpp( 118):
StatementHandle = 0x015f26fc

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetStmtAttr.cpp( 120):
Attribute = 10010

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetStmtAttr.cpp( 122):
ValuePtr = 0x009819b0

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetStmtAttr.cpp( 124):
BufferLength = -4

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetStmtAttr.cpp( 126):
StringLengthPtr = 0x0012f1f4

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 533): Entering
tsmLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 535): mutex =
0x0000019c

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 552): Exiting
tsmLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetStmtAttr.cpp( 171):
Attribute = SQL_ATTR_APP_ROW_DESC

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 567): Entering
tsmUnLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 569): mutex =
0x0000019c

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 586): Exiting
tsmUnlockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetStmtAttr.cpp( 450): Exiting
SQLGetStmtAttr(), rc = 0

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetStmtAttr.cpp( 116):
Entering SQLGetStmtAttr()

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetStmtAttr.cpp( 118):
StatementHandle = 0x015f26fc

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetStmtAttr.cpp( 120):
Attribute = 10011

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetStmtAttr.cpp( 122):
ValuePtr = 0x00981a3c

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetStmtAttr.cpp( 124):
BufferLength = -4

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetStmtAttr.cpp( 126):
StringLengthPtr = 0x0012f1f4

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 533): Entering
tsmLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 535): mutex =
0x0000019c

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 552): Exiting
tsmLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetStmtAttr.cpp( 165):
Attribute = SQL_ATTR_APP_PARAM_DESC

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 567): Entering
tsmUnLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 569): mutex =
0x0000019c

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 586): Exiting
tsmUnlockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetStmtAttr.cpp( 450): Exiting
SQLGetStmtAttr(), rc = 0

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetStmtAttr.cpp( 116):
Entering SQLGetStmtAttr()

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetStmtAttr.cpp( 118):
StatementHandle = 0x015f26fc

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetStmtAttr.cpp( 120):
Attribute = 10012

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetStmtAttr.cpp( 122):
ValuePtr = 0x00981ac8

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetStmtAttr.cpp( 124):
BufferLength = -4

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetStmtAttr.cpp( 126):
StringLengthPtr = 0x0012f1f4

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 533): Entering
tsmLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 535): mutex =
0x0000019c

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 552): Exiting
tsmLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetStmtAttr.cpp( 243):
Attribute = SQL_ATTR_IMP_ROW_DESC

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 567): Entering
tsmUnLockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 569): mutex =
0x0000019c

Tue Apr 15 16:37:22 2003 00000608 0000054c Common.cpp( 586): Exiting
tsmUnlockMutex()

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetStmtAttr.cpp( 450): Exiting
SQLGetStmtAttr(), rc = 0

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetStmtAttr.cpp( 116):
Entering SQLGetStmtAttr()

Tue Apr 15 16:37:22 2003 00000608 0000054c SQLGetStmtAttr.cpp( 118):
StatementHandle = 0x015f26fc
[More with this subject...]
<Prev in Thread] Current Thread [Next in Thread>
Previous by Date:  unsubscribe, Wise, Joanna m
Next by Date:  unsubscribe, Dr. Paolo Sarchini
Previous by Thread:  Re: Connect to TSM ODBC Driver with Regina and Rexx/SQL for ODBC no longer possible, Andrew Raibeck
Next by Thread:  Re: AW: AW: TSM on Mainframe, Using STK 9840 Drives in 359 0 Image Mo de, John Naylor
Indexes:  [Date] [Thread] [Top] [All Lists]