IBM this month introduced a brand new free up of DB2 connect, a bit of middleware used to join customer applications working on Linux, Unix, or home windows structures to DB2 database servers operating on IBM i and z/OS. With DB2 connect edition 10.1, IBM introduced help for DB2 for i edition 7.1. It additionally introduced a number of features for taking advantages of the newest enhancements to DB2 for z/OS.
DB2 join enables client applications to create, entry, update, control, and manipulate DB2 databases on host methods using quite a lot of languages, together with SQL, ODBC, JDBC, DB2 APIs, SQLJ DB2 call degree Interface (CLI), .web, php, Ruby, Python, Perl, and pureQuery. essentially the most common use of the application is serving SQL statements to DB2 on IBM i and z/OS systems, but it surely can even be used to be part of tables from distinct DB2/400 databases, including different DB2 models and Informix, and even Oracle, SQL Server, and Sybase when coupled with that surest huge Blue information broker, WebSphere advice Integrator.
The lone IBM i-connected enhancement in DB2 connect 10.1 is a biggie: guide for DB2 for i running on the latest IBM i edition 7.1 working system, which shipped two years in the past this month. Late help is improved than no help.
the bulk of the enhancements in DB2 join 10.1 focal point on the numerous drivers to help the latest capabilities in DB2 10 for z/OS platform, which IBM shipped in October 2010. This comprises: binary XML assist in Java drivers; XML-related performance boosts; aid for extended vector variables; temporal table assist; improved timestamp precision; and other performance and high availability enhancements.
This free up also promises superior aid for IBM equipment, including WebSphere utility Server, Optim Configuration supervisor, and statistics Studio. Programmers can be happy to listen to DB2 join 10.1 brings: new JDBC four.1 capabilities for Java 7; assist for the .net four.0 framework with Entity Framework; full integration with visual Studio 2010; and aid for migrating applications from other database providers to DB2 for z/OS.
IBM has also reworked its quite a lot of DB2 connect bundles, together with shrinking the footprint of its information Server (DS) Driver bundle; streamlined activation of DB2 connect limitless version for equipment z; and new gateway options.
organizations working the superior IBM pureQuery Runtime for Linux, Unix, and home windows will see new safety elements, including the ability to prevent SQL injection by way of restricting the SQL completed via a particular software to particular SQL statements. This unencumber additionally gives clients the means to convert dynamic SQL to static SQL, which improves performance and protection.
DB2 join 10.1 variations develop into available June 11. For greater information on DB2 connect 10.1, see IBM u.s. utility Announcement 212-076.
Raz-Lee Claims IBM i records-access leap forward with DB-Gate
DB2 join gets better help for saved procedures and Triggers
IBM officially proclaims i/OS 7.1
publish this story to del.icio.us post this story to Digg submit this story to Slashdot