Re: RXSQL talking to DB2 UDB on Linux/IFL
Hi Ed I don't have any experience with RXSQL, but on the VSE side... In order to use ISQL (a CICS transaction that allows interactive sql statements), you have to export the ISQL packages and import them over on UDB. I assume the same thing will have to be done for any product/code that you can't recompile using the UDB as the keeper of the packages. Tom Duerbusch THD Consulting >>> Ed Zell <[EMAIL PROTECTED]> 7/19/2007 1:53 PM >>> We are looking at a Z series box and the possibility of getting off DB/2 for VM and moving it to DB/2 UDB which would run under Linux on an IFL. Is anyone doing this and using RXSQL on VM to access the DB/2 UDB database? We have a couple of custom applications that depend on RXSQL and need to make sure that this environment would be viable and supported. Thanks. Ed Zell Illinois Mutual Life (309) 674-8255 x-107 . CONFIDENTIAL NOTICE: This communication, including any attachments, is intended only for the use of the individual or entity to which it is addressed and contains information which may be confidential. If you are not the intended recipient, any distribution or copying of this communication is strictly prohibited. If you have received this communication in error, notify the sender immediately, delete the communication and destroy all copies. Thank you for your compliance.
Re: RXSQL talking to DB2 UDB on Linux/IFL
> Appendix L of this manual lists from DRDA protocol > info/restrictions > > ftp://ftp.software.ibm.com/ps/products/db2/info/vr7/vmvse/db2v71ae.pdf Thanks Eric. This should help answer my question. Thanks to Rich and Roland as well. Ed Zell Illinois Mutual Life (309) 674-8255 x-107 . CONFIDENTIAL NOTICE: This communication, including any attachments, is intended only for the use of the individual or entity to which it is addressed and contains information which may be confidential. If you are not the intended recipient, any distribution or copying of this communication is strictly prohibited. If you have received this communication in error, notify the sender immediately, delete the communication and destroy all copies. Thank you for your compliance.
Re: RXSQL talking to DB2 UDB on Linux/IFL
Hello Ed, there is a problem using RXSQL to run against DB2 for z/OS V8: "Getting SQLCODE -301 when inserting undefined variable (never assigned a value or RXSQL DROPped) to DB2 for z/OS V8. When a variable was undefined, it was considered to have a NULL value. The application works fine with DB2 for z/OS V7 but failed with SQLCODE -301 with DB2 for z/OS V8." The reason being: Prior to DB2 for z/OS V8 when an indicator variable is set to a negative number that indicates that you are specifying NULL value. The value of the actual variable did not matter when indicator variable is negative. DB2 for Z/OS V8 has added an extra restriction: the value of the actual variable must have a valid value. I understood UDB LUW has adopted the same changes in V8. So, you have to watch out for that. A temporary RXSQL FIX has been provided to circumvent the customer's situation. Contact DB2/VSE&VM support if you encounter similiar problem. Other than that, all RXSQL application running against DB2 for z/OS are fine. I hope this helps. ...Roland Ed Zell <[EMAIL PROTECTED]> wrote: We are looking at a Z series box and the possibility of getting off DB/2 for VM and moving it to DB/2 UDB which would run under Linux on an IFL. Is anyone doing this and using RXSQL on VM to access the DB/2 UDB database? We have a couple of custom applications that depend on RXSQL and need to make sure that this environment would be viable and supported. Thanks. Ed Zell Illinois Mutual Life (309) 674-8255 x-107 . CONFIDENTIAL NOTICE: This communication, including any attachments, is intended only for the use of the individual or entity to which it is addressed and contains information which may be confidential. If you are not the intended recipient, any distribution or copying of this communication is strictly prohibited. If you have received this communication in error, notify the sender immediately, delete the communication and destroy all copies. Thank you for your compliance. With best regards, ...Roland Chung Senior 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 ** Live simply. Love generously. Care deeply. Speak kindly. Leave the rest to God. I think this is something we should all live by. - An Old Farmer's Advice **
Re: RXSQL talking to DB2 UDB on Linux/IFL
If a communications path is available to the UDB server from VM and the DB2 client code on VM can connect to it, then RXSQL should have no problem with access. Subject to the restrictions that Eric mentioned. Ed Zell wrote: We are looking at a Z series box and the possibility of getting off DB/2 for VM and moving it to DB/2 UDB which would run under Linux on an IFL. Is anyone doing this and using RXSQL on VM to access the DB/2 UDB database? We have a couple of custom applications that depend on RXSQL and need to make sure that this environment would be viable and supported. Thanks. Ed Zell Illinois Mutual Life (309) 674-8255 x-107 . CONFIDENTIAL NOTICE: This communication, including any attachments, is intended only for the use of the individual or entity to which it is addressed and contains information which may be confidential. If you are not the intended recipient, any distribution or copying of this communication is strictly prohibited. If you have received this communication in error, notify the sender immediately, delete the communication and destroy all copies. Thank you for your compliance. -- Rich Smrcina VM Assist, Inc. Phone: 414-491-6001 Ans Service: 360-715-2467 rich.smrcina at vmassist.com http://www.linkedin.com/in/richsmrcina Catch the WAVV! http://www.wavv.org WAVV 2008 - Chattanooga - April 18-22, 2008
Re: RXSQL talking to DB2 UDB on Linux/IFL
Ed Appendix L of this manual lists from DRDA protocol info/restrictions ftp://ftp.software.ibm.com/ps/products/db2/info/vr7/vmvse/db2v71ae.pdf It may depend on what release level of DB2/vm you are running... Ask you BP about a DB2/VM client license.. This may save you some money when the database is moved from VM to DB2/UDB Eric At 02:53 PM 7/19/2007, you wrote: >We are looking at a Z series box and the possibility >of getting off DB/2 for VM and moving it to DB/2 UDB >which would run under Linux on an IFL. > >Is anyone doing this and using RXSQL on VM to access >the DB/2 UDB database? > >We have a couple of custom applications that depend on >RXSQL and need to make sure that this environment would >be viable and supported. Thanks. > >Ed Zell >Illinois Mutual Life >(309) 674-8255 x-107 >. > > >CONFIDENTIAL NOTICE: This communication, including any attachments, is i= >ntended only for the use of the individual or entity to which it is addre= >ssed and contains information which may be confidential. If you are not = >the intended recipient, any distribution or copying of this communication= >=20is strictly prohibited. If you have received this communication in er= >ror, notify the sender immediately, delete the communication and destroy = >all copies. Thank you for your compliance. Eric Schadow Mainframe Technical Support www.davisvision.com Driving a car versus riding a bike is on par with watching television rather than living your own life Cyclist Bruce MacAlister The information contained in this communication is intended only for the use of the recipient(s) named above. It may contain information that is privileged or confidential, and may be protected by State and/or Federal Regulations. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please return it to the sender immediately and delete the original message and any copy of it from your computer system. If you have any questions concerning this message, please contact the sender.
RXSQL talking to DB2 UDB on Linux/IFL
We are looking at a Z series box and the possibility of getting off DB/2 for VM and moving it to DB/2 UDB which would run under Linux on an IFL. Is anyone doing this and using RXSQL on VM to access the DB/2 UDB database? We have a couple of custom applications that depend on RXSQL and need to make sure that this environment would be viable and supported. Thanks. Ed Zell Illinois Mutual Life (309) 674-8255 x-107 . CONFIDENTIAL NOTICE: This communication, including any attachments, is intended only for the use of the individual or entity to which it is addressed and contains information which may be confidential. If you are not the intended recipient, any distribution or copying of this communication is strictly prohibited. If you have received this communication in error, notify the sender immediately, delete the communication and destroy all copies. Thank you for your compliance.