Db2 for i Enhancements

The following article contains an overview of the Db2 for i enhancements.  The article covers both IBM i 7.1 TR9 and IBM i 7.2 TR1 database enhancements.
MC Press Article: "Step right up and hear about Db2 and TR9!"

http://www.mcpressonline.com/ibm-i-os/400-i5/os/step-right-up-and-hear-about-db2-and-tr9.html

Db2 for i Functional Enhancements

• Pipelined Table Functions
• Regular Expressions
• LPAD & RPAD Scalar Functions
• JOB_NAME & SERVER_MODE_JOB_NAME - Db2 built-in global variables
• RUNSQL control of output listing
• LOCK TABLE ability to target non-FIRST members
• QUSRJOBI() retrieval of Db2 built-in global variables

Db2 for i Database Management Enhancements

• Some SQL messages changed to return SQL column names
• Debugger support for EVAL within SQL Routines and SQL Triggers

Db2 for i Performance Enhancements

• Database monitor with condensed host variables capture
• Comprehensive support for ‘Keep In Memory’
• Automated DBE tasks for Navigator
• Index creation date added to Navigator’s Schemas & Db2 for i Catalogs
• Visual Explain ability to drill into a UDTF

Db2 for i Security Enhancements

• Add OR REPLACE for masks and permissions (7.2 only enhancement)
• Add the HOSTVAR parameter to the STRDBMON command

Db2 for i - New IBM i Services

• QSYS2.JOBLOG_INFO
• QSYS2.LIBRARY_LIST_INFO
• QSYS2.REPLY_LIST_INFO
• SYSTOOLS.GROUP_PTF_CURRENCY (7.2 only enhancement)
• QSYS2.JOURNAL_INFO
• System Limits Phase 3 - IFS file system object tracking (7.2 only enhancement)

Db2 for i Availability & Recovery Enhancements

• Faster IASP vary on

Db2 for i - Navigator Enhancements

• IBM i Navigator - database enhancements in IBM i 7.1 TR9 & IBM i 7.2 TR1

---

Systems Management

The Web Navigator has been significantly updated to include a number of new features, functions, as well as many new usability and performance updates. The Database component was a significant area of focus for this delivery.

Integrated Web Services Server - REST-based services

The integrated web services server has been updated to now include the ability to create and host REST-based web services on top of your ILE-based RPG and COBOL programs. The IBM Web Administration for i GUI interface (http://hostname:2001/HTTPAdmin) has been updated to allow users to quickly and easily create new web services that leverage REST as well as the existing SOAP web services support. Additionally new Qshell scripts have been added to give you the ability to easily save and restore your web services servers from one system to another. The restoreWebServices script has been enhanced to support the migration from version 1.5 to the latest Liberty-based support.

Details can be found at - HERE

Application Development

Rational Developer for i (RDi) has been updated to RDi V9.1. This latest updated contains several important updates that are focused on helping the developer significantly improve the quality of their applications leveraging the new interactive Code Coverage support as well as the existing batch Code Coverage support. Additionally, the ability to distribute and maintain RDi across a team of developers have been greatly improved with the addition of Push to Client support. This allows a central IBM i server to distribute standardized template, connection information, filters, and many other aspects of your RDi deployment. For details see - http://www-03.ibm.com/software/products/en/dev-ibm-i/

Node.JS

Open source continues to play an important role in applications on IBM i. To continue to meet this need, Node.js, a platform built on Chrome's JavaScript runtime for 'server-side' and networking applications. This includes extensions to all access to Db2 for i, and many other native ILE objects. Details can be found at: HERE

Note: Node.js is a registered trademark of Joyent, Inc. in the United states and other countries. This module is not formally related to or endorsed by the official Joyent Node.js project.

Software Group Updates

IBM WebSphere Commerce V7 Feature Pack 8 

The Commerce solution has been updated with a number of new features and is now available on IBM i. This is a cumulative delivery including all previous feature packs. 

IBM MQ V8

The IBM MQ product has been updated and is now available on IBM i. This is a significant update. In addition to enhancements to the main MQ products, this update includes a packaging change to include the File Transfer edition and the IBM Advanced Message Security support now all running native on IBM i.   For details see  - HERE

---