Re: JDBC and DB2/VM
Hello Herny, one of my clients was able to access DB2/VSE from MS/Excel after installing the appropriate "Schema stored procedures for CLI/ODBC/JDBC/OLE DB Client Applications" fix. (BTW, it never made to be an APAR). Have you instlled the "Schema stored procedures for CLI/ODBC/JDBC/OLE DB Client Applications" fix in your DB2/VM system? If not, I would suggest you call IBM DB2/VSE&VM services to order: 1) any missing APAR/PTFs for your DB2/VM V7.20 system. 2) request to have a "Schema stored procedures for CLI/ODBC/JDBC/OLE DB Client Applications" FIXTEST. 3) install the above and try again. I know you will not get too much support from IBM because DB2/VM V7.20 is out of services. However, you still can get all existing APAR/PTF/FIXes, etc. for DB2/VSE 7.20. Good luck. ...Roland Henry Wilusz <[EMAIL PROTECTED]> wrote: HelloJust a short question to see if anyone has gotten JDBC drivers on awindows machine to successfully access DB2/VM. We know that the driverswork with DB2/universal. but fail miserably with DB2/VM. DB2/VM is atversion 7.2The attempt to access DB2/VM returns a authorization failure message tothe windows machine (incorrect message there) and a data capture dump onDB2/VM. The reason for exploring the JDBC angle is that ODBC connections tothis database sometimes hang with no error messages, and we cannot seemto reproduce the hang conditions. An interesting part of the DB2 dump is below. Note that the probablecause section does not tell what the unsupported value was that it istrying to deal with.SYMPTOM STRING: MS/ARI2909I PIDS/5697F4201 RIDS/ARITPAC PRCS/11PROBABLE CAUSE OF FAILURE:DDM VALUE NOT SUPPORTEDIf anyone has gotten cold fusion or JDBC to work to DB2/VM, and iswilling to share the secrets, I would like to hear from them thanks Henry Wilusz[EMAIL PROTECTED]Failure is not an option . . . . .. . . . . It comes standard with windowsWith best regards,...Roland ChungSenior Technical Specialist (S/390,VM/VSE,DB2/VSE&VM)MAXC Consultants Inc.Voice/Fax: 416-901-9442 (If busy, call: 416-469-2268)197 Hastings Ave., Toronto, Ontario, Canada. M4L 2L6** Life is short. Stop once in a while and smell the roses. **
AW: JDBC and DB2/VM
You need to use the db2 "connect". The normal drivers for db2 does not support connects to a vm database. -Ursprüngliche Nachricht- Von: The IBM z/VM Operating System [mailto:[EMAIL PROTECTED] Im Auftrag von Alan Ackerman Gesendet: Sonntag, 8. Oktober 2006 07:17 An: IBMVM@LISTSERV.UARK.EDU Betreff: Re: JDBC and DB2/VM I'm afraid we've only got DB2 Connect on a PC to work with DB2/VM (7.4 and earlier). Are you using DB2 Connect? I don't know if anyone is using JDBC or not. On Fri, 6 Oct 2006 16:16:26 -0400, Henry Wilusz <[EMAIL PROTECTED]> wrote: >Hello >Just a short question to see if anyone has gotten JDBC drivers on a >windows machine to successfully access DB2/VM. We know that the >drivers work with DB2/universal. but fail miserably with DB2/VM. >DB2/VM is at version 7.2 The attempt to access DB2/VM returns a >authorization failure message to the windows machine (incorrect message >there) and a data capture dump on DB2/VM. > >The reason for exploring the JDBC angle is that ODBC connections to >this database sometimes hang with no error messages, and we cannot seem >to reproduce the hang conditions. > >An interesting part of the DB2 dump is below. Note that the probable >cause section does not tell what the unsupported value was that it is >trying to deal with.DDM VALUE > >SYMPTOM STRING:MS/ARI2909I PIDS/5697F4201 RIDS/ARITPAC PRCS/11 > >PROBABLE CAUSE OF FAILURE: >DDM VALUE NOT SUPPORTED > > >If anyone has gotten cold fusion or JDBC to work to DB2/VM, and is >willing to share the secrets, I would like to hear from them > >thanks > >Henry Wilusz >[EMAIL PROTECTED] > >Failure is not an option . . . . . >. . . . . It comes standard with windows >=== ==
Re: JDBC and DB2/VM
I'm afraid we've only got DB2 Connect on a PC to work with DB2/VM (7.4 an d earlier). Are you using DB2 Connect? I don't know if anyone is using JDBC or not. On Fri, 6 Oct 2006 16:16:26 -0400, Henry Wilusz <[EMAIL PROTECTED]> wro te: >Hello >Just a short question to see if anyone has gotten JDBC drivers on a >windows machine to successfully access DB2/VM. We know that the drivers >work with DB2/universal. but fail miserably with DB2/VM. DB2/VM is at >version 7.2 >The attempt to access DB2/VM returns a authorization failure message to >the windows machine (incorrect message there) and a data capture dump on >DB2/VM. > >The reason for exploring the JDBC angle is that ODBC connections to >this database sometimes hang with no error messages, and we cannot seem >to reproduce the hang conditions. > >An interesting part of the DB2 dump is below. Note that the probable >cause section does not tell what the unsupported value was that it is >trying to deal with.DDM VALUE > >SYMPTOM STRING:MS/ARI2909I PIDS/5697F4201 RIDS/ARITPAC PRCS/11 > >PROBABLE CAUSE OF FAILURE: >DDM VALUE NOT SUPPORTED > > >If anyone has gotten cold fusion or JDBC to work to DB2/VM, and is >willing to share the secrets, I would like to hear from them > >thanks > >Henry Wilusz >[EMAIL PROTECTED] > >Failure is not an option . . . . . >. . . . . It comes standard with windows > = == ==
JDBC and DB2/VM
Hello Just a short question to see if anyone has gotten JDBC drivers on a windows machine to successfully access DB2/VM. We know that the drivers work with DB2/universal. but fail miserably with DB2/VM. DB2/VM is at version 7.2 The attempt to access DB2/VM returns a authorization failure message to the windows machine (incorrect message there) and a data capture dump on DB2/VM. The reason for exploring the JDBC angle is that ODBC connections to this database sometimes hang with no error messages, and we cannot seem to reproduce the hang conditions. An interesting part of the DB2 dump is below. Note that the probable cause section does not tell what the unsupported value was that it is trying to deal with. SYMPTOM STRING:MS/ARI2909I PIDS/5697F4201 RIDS/ARITPAC PRCS/11 PROBABLE CAUSE OF FAILURE: DDM VALUE NOT SUPPORTED If anyone has gotten cold fusion or JDBC to work to DB2/VM, and is willing to share the secrets, I would like to hear from them thanks Henry Wilusz [EMAIL PROTECTED] Failure is not an option . . . . . . . . . . It comes standard with windows