Rob Wunderlich writes: >z/OS DB2 tends to lag behind Windows in function. Check which >version you are running on z/OS compared to the Windows version.
Just to expand on what Rob is saying, if you're running an older version of DB2 for z/OS, then Rob's concerns likely apply. However, a lot has changed concerning DB2 for z/OS in the past couple versions. If you draw a Venn diagram, there's mostly overlap, but the area outside DB2 z/OS (and inside DB2 Linux/UNIX/Windows) has gotten smaller (and continues in that direction), and the area outside DB2 LUW (and inside DB2 z/OS) has been getting a bit bigger lately. There are a lot of reasons for these trends, but that's a topic for another thread. There's a great bit of documentation, "SQL Reference for Cross-Platform Development," which I would recommend for developer audiences. You can find it here: http://www.ibm.com/developerworks/db2/library/techarticle/0206sqlref/0206sqlref.html Hopefully this book will get updated for DB2 Version 9 very soon, but the DB2 V8 guide is quite valuable. I think every developer who writes code that accesses databases should have a copy of this book close by. As a general rule with WebSphere applications, it's not too hard to redirect them from using DB2 V8 LUW (or earlier) to using DB2 V8 for z/OS. Or V9 to V9 (and often even V9 to V8). Yes, it's something you want to think about and plan, but, "in general," it's not a particular challenge. Actually, I think in an earlier thread I alluded to the fact that mainframes measure and monitor, and that alone can be a shock for developers with code that hasn't been previously measured and monitored. If the code and/or database-related logic is inefficient, you can still run it, but the mainframe will tell you exactly where it is inefficient. And that alone can be a blow to many developer egos. :-) Just make sure you understand and prepare for the psychology involved there. :-) - - - - - Timothy Sipples IBM Consulting Enterprise Software Architect Specializing in Software Architectures Related to System z Based in Tokyo, Serving IBM Japan and IBM Asia-Pacific E-Mail: [EMAIL PROTECTED] ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
