Hey thanks for the response. This legacy (also government) system is killing me. I mean we only have about 900,000 rows in our largest DB, this thing could/should be in SQL Server.
If I get any better info moving forward I'll let you know. > -----Original Message----- > From: Earl, George [mailto:[EMAIL PROTECTED] > Sent: Monday, July 24, 2006 1:52 PM > To: CF-Talk > Subject: RE: CF & DB2 on a z/OS mainframe? > > Loathe said: > > What is the best way from CF (potentially on a web sphere > > server) to have FULL access to DB 2. By this I mean user > > management, stored procedures, and regular SQL statements. > > ... snipped ... > > Can I do user management through JDBC? I hear there are a > > ton of performance gains to be had by using JDBC, is this true? > > We have a test Windows server set up with CF6.1 (soon to be upgraded to > CF7) that accesses DB2 on z/OS. Our DBAs made us use the IBM DB2 Type 2 > JDBC drivers specifically because it would allow them to take 'full > advantage of DB2's capabilities' - whatever that means. We run > successfully against DB2 using both stored procedures and pass through > SQL. > > I don't know about user management through JDBC and I cannot answer your > performance gains question because we are still deep into the CF5 to CF7 > migration project that won't end, but we ran some pretty heavy load > testing (for our environment) and we didn't run into any issues. I > should say that we do only reads, no creates, updates, deletes. > > George > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247550 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4