• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • DB2 Connect (Finally) Gets IBM i 7.1 Support

    April 17, 2012 Alex Woodie

    IBM this month announced a new release of DB2 Connect, a piece of middleware used to connect client applications running on Linux, Unix, or Windows platforms to DB2 database servers running on IBM i and z/OS. With DB2 Connect version 10.1, IBM added support for DB2 for i version 7.1. It also added a number of features for taking advantages of the latest enhancements to DB2 for z/OS.

    DB2 Connect enables client applications to create, access, update, control, and manage DB2 databases on host systems using a variety of languages, including SQL, ODBC, JDBC, DB2 APIs, SQLJ DB2 Call Level Interface (CLI), .NET, PHP, Ruby, Python, Perl, and pureQuery. The most common use of the software is serving SQL statements to DB2 on IBM i and z/OS systems, but it can also be used to join tables from multiple DB2/400 databases, including other DB2 versions and Informix, and even Oracle, SQL Server, and Sybase when coupled with that ultimate Big Blue data broker, WebSphere Information Integrator.

    The lone IBM i-related enhancement in DB2 Connect 10.1 is a biggie: support for DB2 for i running on the latest IBM i version 7.1 operating system, which shipped two years ago this month. Late support is better than no support.

    The bulk of the enhancements in DB2 Connect 10.1 focus on the various drivers to support the latest capabilities in DB2 10 for z/OS platform, which IBM shipped in October 2010. This includes: binary XML support in Java drivers; XML-related performance boosts; support for extended vector variables; temporal table support; enhanced timestamp precision; and other performance and high availability enhancements.

    This release also delivers better support for IBM tools, including WebSphere Application Server, Optim Configuration Manager, and Data Studio. Programmers will be happy to hear DB2 Connect 10.1 brings: new JDBC 4.1 capabilities for Java 7; support for the .NET 4.0 framework with Entity Framework; full integration with Visual Studio 2010; and support for migrating applications from other database vendors to DB2 for z/OS.

    IBM has also reworked its various DB2 Connect bundles, including shrinking the footprint of its Data Server (DS) Driver bundle; streamlined activation of DB2 Connect Unlimited Edition for System z; and new gateway options.

    Companies running the advanced IBM pureQuery Runtime for Linux, Unix, and Windows will see new security features, including the capability to prevent SQL injection by restricting the SQL executed by a specific application to specific SQL statements. This release also gives users the capability to convert dynamic SQL to static SQL, which improves performance and security.

    DB2 Connect 10.1 editions become available June 11. For more information on DB2 Connect 10.1, see IBM United States Software Announcement 212-076.

    RELATED STORIES

    Raz-Lee Claims IBM i Data-Access Breakthrough with DB-Gate

    DB2 Connect Gets Better Support for Stored Procedures and Triggers

    IBM Officially Announces i/OS 7.1



                         Post this story to del.icio.us
                   Post this story to Digg
        Post this story to Slashdot

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags:

    Sponsored by
    Raz-Lee Security

    With COVID-19 wreaking havoc, cybercriminals are taking advantage of the global impact that it has had on our families, our businesses and our societies. It is more important now than ever to ensure that IT systems are protected, so that when all of this is behind us, we can get back to business as usual as quickly as possible.

    iSecurity Anti-Ransomware protects organizations against ransomware attacks and other kinds of malware that may access and change business-critical data on your IBM i. It even protects against zero-day attacks. Anti-Viruses can only report on the damage an attack has caused, but not stop it.

    iSecurity Anti-Ransomware has been recently enhanced with a Self-Test feature that allows you to simulate a ransomware attack on your IBM i. The simulated attack is limited to the test folder and cannot harm any other folders or files. This new feature lets organizations see how they are protected against known or unknown ransomware.

    Key Features:

    • Real-time scanning for known and unknown ransomware threats.
    • Blocks and disconnects the intruder.
    • Instantaneously sends alerts to SIEM as well as the offending computer.
    • Self-Test for attack simulation
    • Classification of the attack based on log.
    • Automatic updates with the most current ransomware definitions.

    Contact us at https://www.razlee.com/anti-ransomware

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Sponsored Links

    ARCAD Software:  Change & Release Management: High time to move to a new standard. 4/25 Webinar
    BCD:  Presto instantly gives IBM i green screens a Web GUI. View a 2 minute video or try it FREE
    COMMON:  Join us at the 2012 Conference & Expo, May 6 - 9 in Anaheim, CA

    IT Jungle Store Top Book Picks

    BACK IN STOCK: Easy Steps to Internet Programming for System i: List Price, $49.95

    The iSeries Express Web Implementer's Guide: List Price, $49.95
    The iSeries Pocket Database Guide: List Price, $59
    The iSeries Pocket SQL Guide: List Price, $59
    The iSeries Pocket WebFacing Primer: List Price, $39
    Migrating to WebSphere Express for iSeries: List Price, $49
    Getting Started with WebSphere Express for iSeries: List Price, $49
    The All-Everything Operating System: List Price, $35
    The Best Joomla! Tutorial Ever!: List Price, $19.95

    JDA To Restate Financials From 2008 Through 2011 A Philosophically Engineered Approach to the Processing of Parameters

    Leave a Reply Cancel reply

Volume 12, Number 10 -- April 17, 2012
THIS ISSUE SPONSORED BY:

Help/Systems
ARCAD Software
HiT Software
Tributary Systems
IntelliChief

Table of Contents

  • SAP Fleshes Out HANA’s Roadmap with Heavy Dose of Sybase
  • Velocity Sees Positive Trajectory in ERP Cloud Biz
  • GeneXus Refresh Targets Mobile Apps, Cloud Deployments
  • DB2 Connect (Finally) Gets IBM i 7.1 Support
  • Infor Welcomes Lawson Users to Annual Conference
  • Zend DBi Goes GA
  • INPRO Enables Multiple Time Zones–In Just One LPAR!
  • Joomla’s CMS Surges in Popularity
  • IBM i Homepage Gets Refreshed with PureSystems Launch
  • IBM Buys Varicent for Cloud-Based Sales Performance Management

Content archive

  • The Four Hundred
  • Four Hundred Stuff
  • Four Hundred Guru

Recent Posts

  • DRV Brings More Automation to IBM i Message Monitoring
  • Managed Cloud Saves Money By Cutting System And People Overprovisioning
  • Multiple Security Vulnerabilities Patched on IBM i
  • Four Hundred Monitor, June 22
  • IBM i PTF Guide, Volume 24, Number 25
  • Plotting A Middle Age Career Change To IBM i
  • What Is Code Transformation Even?
  • Guru: The CALL I’ve Been Waiting For
  • A Frank Solstice
  • The Inevitable Wave Of Power9 Withdrawals Begins

Subscribe

To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

Pages

  • About Us
  • Contact
  • Contributors
  • Four Hundred Monitor
  • IBM i PTF Guide
  • Media Kit
  • Subscribe

Search

Copyright © 2022 IT Jungle

loading Cancel
Post was not sent - check your email addresses!
Email check failed, please try again
Sorry, your blog cannot share posts by email.