IBM I 7.1 manual DB2 Web Query, ƒ Reduce Report Maintenance, ƒ Remove Dependency on IT

Page 12

IBM Power Systems

DB2 Web Query

9Upgrade Query/400 with DB2 Web Query

ƒGet Better Performance

Up to 5x better performance over Query/400

ƒReduce Report Maintenance

Leverage parameterized reporting or OLAP functions to minimize report maintenance

ƒRemove Dependency on IT

Give the Power of the data to end users in the formats they want it with information in real time

ƒUpgrade into full blown BI

DB2 Web Query enabled Data Mart/Warehouses

9Bring BI and Query Solution Back to IBM i

ƒStop the pain and expense of replicating data

ƒMake decisions with current data

http://www-03.ibm.com/systems/i/software/db2/webquery/

12

© 2010 IBM Corporation

Image 12
Contents IBM i 7.1 Overview Power your planet Power your Planet Workload-Optimizing SystemsPower Technology leadership Power Systems Portfolio Powerr IBM i Strategy and Roadmap ƒ New IBM white paperIBM i Roadmap 20092010 2011 2012Building on the Foundation IBM i 6.1 HighlightsIBM i 7.1 Announcement Highlights Announced on April GA’d onƒ Remote Upgrade to IBM i 6.1.1 or ƒ Strategic replacement for XML Extenders Program Product DB2 for i XML SupportDB2 for i Additional Enhancements ƒ Column Level Encryptionƒ Application Developers ƒ Performanceƒ Reduce Report Maintenance ƒ Upgrade into full blown BI9Bring BI and Query Solution Back to IBM DB2 Web QueryDB2 Web Query Enhancements ƒ New functions for IBM i 5.4, 6.1ƒ DB2 Web Query supports querying XML documents with IBM i PowerHA SystemMirror for ƒ LUN level switching for local HA solutionƒ Space-Efficient Flash Copy PowerHA SystemMirror for IBM i Editions Virtualization Enhancements for IBM ƒ Maintain current IBM i 6.1 partitionsƒ New installation wizard IBM i integration with BladeCenter and Systemƒ iSCSI Software Target Supports Higher Speed Connection ƒ Supported EnvironmentsIBM i Storage Management and SSD Solid-State Disk Drive PCIe SAS RAID Adapter 177GBCntrl Remove Disk Units Without an IPL or Outage Systems Management Enhancements ƒ Systems Director Navigator forƒ Performance Management Enhancements ƒ Systems Director EnhancementsNetwork Upgrade Simplifies Upgrading Multiple Systems POWER6 server POWER7 server IBM i 6.1 or laterBase Support Install or Upgrade using Vscsi Virtual Optical support Electronic Software Download ƒ All currently marketed IBM i releases availableTechnology Refresh TR ƒ Integrated Web Services Server Web Server Enhancementsƒ IBM Http Server for i running Apache ƒ IBM Technology for JavaWeb Integration New Features ƒ Developers can use Web Adminƒ Monitor Web Server Log files WebSphere Support for IBM i ƒ WebSphere Application Serverƒ WebSphere MQ ƒ WebSphere Portalƒ Rational Developer for Power ƒ Rational Team Concert for PowerRational Support for IBM i ƒ Rational Application DeveloperRational Open Access RPG Edition ƒ Extends RPG application reach to pervasive devicesBrowser Web Services Mobile ƒ RPG applications produce 5250 data streamIBM Lab Services LooksoftwareProfound Logic ƒ Simplified Set Up and Management Zend PHP Enhancementsƒ Zend Server Community Edition for ƒ Zend Server forZend Delivers an Open Solution Stack for IBM ƒ Opens up a vast ecosystem of technologiesƒ 4+ million trained PHP developers New Zend Product Offerings for IBM Zend Server Community Edition Replaces Zend CoreLotus Support for IBM i ƒ Lotus Notes and Dominoƒ Lotus Sametime ƒ Lotus Quickrƒ IBM Transform Services for i Enhancement Additional Enhancementsƒ Encrypted ASP Enhancements ƒ Brms Enhancementsƒ IBM i Access Family Enhancements IBM i and Software as a Service Getting to IBM i 7.1 Supported Upgrade paths Installs onImportant planning documents Still have the 6.1 conversionsIBM i License Transfer Making it Easier for Clients toService IBM i Life Cycle5770-SS1 feature IBM i 7.1 Language GroupsGroup Function / Product Recommended Replacement Withdrawals and ChangesRedbook IBM i 7.1 Technical Overview POWER7 August Announcements POWER7 795, 710, 720, 730 Power Power your planet with Power Systems Express servers Power Power 710, 720, 730 and 740 Express HighlightsWhy 720/740 Probably Best for IBM i Clients Similar pricing 710 vs 720 Rack density not that importantPower Systems Express Rack/Tower Positioning PowerPower 710 8231-E2B 4-,6-,8-core ƒ 1 socket ƒ Processor module pick ONEƒ Can not change module Core #8350 3 GHz Core #8349 3.7 GHz Core #8359 3.55 GHzPower 730 8231-E2B 8-,12-,16-core ƒ 2 sockets ƒ Processor module pick TWO of the same featureƒ 4 PCIe slots in base for 710 or ƒ Can not change module ƒFor 8-/12-/16-corePower 720 8202-E4B 4-,6-,8-core Core #8350 3 GHz Core #8351 3 GHz Core #8352 3 GHzƒFor 4-core Power 740 8205-E6B 4-,6- & 8-,12-,16-core ƒ 1 or 2 sockets ƒ Pick processor modulesƒFor 4-,6-core 1 socket ƒFor 8-,12-,16-core 2 socketThank You IBM Power Systems Special notices Revised February 9

I 7.1 specifications

IBM i 7.1, a version of IBM's popular integrated operating system, continues to serve as a robust platform for enterprise computing. Released in 2010, this version is built on the reliable IBMi architecture and has been recognized for its ability to seamlessly manage both traditional and modern workloads. One of its hallmark features is its integrated database, DB2 for i, which provides powerful data management capabilities directly within the operating system.

IBM i 7.1 introduced several enhancements that focused on performance, security, and scalability. Notably, it supports the latest versions of Industry standards like SQL, which allows for advanced database manipulation and retrieval. This version also provided improved scalability for handling larger workloads due to its advanced memory management and processing capabilities.

Another significant feature is the introduction of High Availability solutions to ensure continuous data access and minimal downtime. IBM i 7.1 utilizes a built-in integration with IBM Power Systems, facilitating efficient utilization of hardware resources and providing users with the ability to scale their systems as needed.

The operating system also emphasizes security with advanced tools that enable comprehensive auditing, encryption, and multifaceted authentication measures. These features ensure that sensitive business information remains secure in an increasingly digital environment.

In addition to its robustness in traditional business applications, IBM i 7.1 also supports modern development methodologies, embracing languages such as PHP and Java. This flexibility makes it easier for organizations to innovate without having to migrate to different platforms.

IBM i 7.1 also integrated the option for enhanced cloud capabilities, allowing businesses to leverage hybrid cloud solutions. This ensures that organizations can harness the power of cloud computing while maintaining their traditional systems.

In conclusion, IBM i 7.1 exemplifies a blend of legacy strength and modern capabilities. Its combination of integrated database features, robust security, high availability, and support for contemporary development frameworks makes it an optimal choice for businesses looking to enhance their IT environments while ensuring stability and performance. As companies continue to evolve and adapt to new technologies, IBM i 7.1 remains a critical player in the enterprise landscape.