IBM InfoSphere Solutions For System Z
IBM InfoSphere Solutions for System zKaren Durwardproduct managerIBMkdurward@us.ibm.comAugust 2, 2010
IBM InfoSphere Solutions for System zLeverage the unique characteristics of z/OS and Linux on System z tocreate, manage and deliver trusted information throughout the enterprise.This session will introduce you to IBM's InfoSphere System z solutionsincluding Foundation Tools, Information Server, MDM Server, Warehouseand more. This session will present ways to: Deliver better business intelligence, faster Create a single view of the business Consolidate application infrastructure Discover, model and map information Prevent fraud with identity analysis Trace the movement of information Copyright IBM Corportation 20102
Important Disclaimer Copyright IBM Corporation 2010. All rights reserved.U.S. Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBMCorp.The information contained in this presentation is provided for informational purposes only. While efforts were made to verify thecompleteness and accuracy of the information contained in this presentation, it is provided “as is” without warranty of any kind,express or implied. In addition, this information is based on ibm’s current product plans and strategy, which are subject tochange by ibm without notice. The information on new products is for informational purposes only and may not be incorporatedinto any contract. The information on any new products in not a commitment, proimse, or legal obligation to deliver any material,code or functionality. The development, release, and timing of any features or functionality described for our products remains atthe sole discretion of ibm. Ibm shall not be responsible for any damages arising out of the use of, or otherwise related to, thispresentation or any other documentation. Nothing contained in this presentation is intended to, nor shall have the effect of,creating any warranties or representations from ibm (or its suppliers or licensors), or altering the terms and conditions of anyagreement or license governing the use of ibm products and/or software.IBM, the IBM logo, ibm.com, InfoSphere, IBM InfoSphere Information Server, IBM InfoSphere MDM Server, IBM InfoSphereWarehouse, IBM InfoSphere Business Glossary, IBM InfoSphere Business Glossary Anywhere, IBM InfoSphere InformationAnalyzer, IBM InfoSphere QualityStage, IBM InfoSphere Global Name Recognition, IBM InfoSphere DataStage, IBM InfoSphereDataStage MVS Edition, IBM InfoSphere Federation Server, IBM InfoSphere Classic Federation Server, IBM InfoSphere ChangeData Capture, IBM InfoSphere Replication Server, IBM InfoSphere Classic Replication Server, and IBM InfoSphere Classic DataEvent Publisher are trademarks or registered trademarks of International Business Machines Corporation in the United States,other countries, or both. If these and other IBM trademarked terms are marked on their first occurrence in this information with atrademark symbol ( or ), these symbols indicate U.S. registered or common law trademarks owned by IBM at the time thisinformation was published. Such trademarks may also be registered or common law trademarks in other countries. A current listof IBM trademarks is available on the Web at “Copyright and trademark information” at www.ibm.com/legal/copytrade.shtmlOther company, product, or service names may be trademarks or service marks of others. Copyright IBM Corportation 20103
Agenda The Business Information Challenge IBM InfoSphere Solutions for System z InfoSphere Information Server InfoSphere Foundation Tools and Models InfoSphere Warehouse for System z InfoSphere Master Data Management Why System z? Wrap-up and Additional Q&A Copyright IBM Corportation 20104
The world is changing and becomingmore InstrumentedInterconnectedIntelligentThe resulting explosion of informationcreates a need for a new kind of intelligence to help build a Smarter Planet Copyright IBM Corportation 20105
With this change comes anexplosion in information Yet organizations areoperating with blind spotsLack of InsightVolume of Digital Data1 in 3 managers frequently makecritical decisions without theinformation they needInefficient AccessVariety of Information1 in 2 don’t have access to theinformation across their organizationneeded to do their jobsInability to PredictVelocity of Decision Making3 in 4 business leaders say morepredictive information would drivebetter decisions Copyright IBM Corportation 2010Source: IBM Institute for Business Value6
Trusted Information at the Core of BusinessOptimizationBusinessValueMaturity ofInformation Use Copyright IBM Corportation 20107
Leveraging information for business optimizationInformation-Led TransformationPlan aninformationagenda Establish aflexibleinformationplatformApply businessanalytics tooptimizedecisionsIndustry over-performers are 8 times more likely to pursueinformation-led transformation at an enterprise level thanunder-performers**Source: IBM Institute for Business Value Copyright IBM Corportation 20108
Leveraging information for business optimizationInformation-Led TransformationPlan aninformationagenda Establish aflexibleinformationplatformApply businessanalytics tooptimizedecisionsCreate a single, trusted view of information across theorganization managed over a strategic period Copyright2010 Value*Source:IBMIBMCorportationInstitute for Business9
Agenda The Business Information Challenge IBM InfoSphere Solutions for System z InfoSphere Information Server InfoSphere Foundation Tools and Models InfoSphere Warehouse for System z InfoSphere Master Data Management Why System z? Wrap-up and Additional Q&A Copyright IBM Corportation 201010
Trusted Information Across The EnterpriseA Range Of Capabilities Are NeededGet a single view of your business with Trusted Information Meets Business Needs Addresses multiple data domains Customer Product Location Functionality across the fullspectrum of use cases Flexible Deployment MDM functionality supported with User Interfaces Workflow Business Services Scales as MDM needs evolve Copyright IBM Corportation 201011
Trusted Information Across The EnterpriseA Range Of Capabilities Are NeededDeliver better business intelligence faster with Trusted Information Unified, powerful data warehouse foundation Advanced partitioning Data mining Retention Cubing features Flexible environment Optimized performance foroperational and transactional use As big or as small as you need Copyright IBM Corportation 201012
Trusted Information Across The EnterpriseA Range Of Capabilities Are NeededDiscover, design and govern your data for Trusted Information Enhance business & IT collaborationCreate, manage and share an enterprise vocabularyGain a true understanding of your data sourcesEnsure information stays trusted acrossthe enterprise Copyright IBM Corportation 201013
Trusted Information Across The EnterpriseA Range Of Capabilities Are NeededSimplify the complexity of information integration with Trusted Information Accelerate data integration projects Metadata-driven design Business - IT alignment Leverage Existing Resources Broad native connectivity Architect for Growth Massive scalability Parallel processing Diverse deployment models Traditional batch Service oriented environments Scheduled and dynamic real time Copyright IBM Corportation 201014
InfoSphere Information ServerIBM InfoSphere Information ServerUnderstandCleanseTransformDeliverDiscover, model, andgovern informationstructure and contentStandardize, merge,and correct informationCombine andrestructure informationfor new usesReplicate, virtualizeand move informationfor in-line deliveryPlatform icesMetadataservicesAdministrationservices Copyright IBM Corportation 2010Deploymentservices15
InfoSphere Information Server & Foundation ToolsIBM InfoSphere Information ServerUnderstandDiscover, model, andgovern informationstructure and contentParallelprocessingservicesTransform RequirementsDeliverCleanseStandardize, merge,and correct informationConnectivityservices Understand the impactof making changestoCombine andReplicate, virtualizethe informationrestructure informationand move informationfor new usesenvironment for in-line delivery Visualize and tracePlatform Services information flows acrossthe enterprise landscapeMetadataservices eport onoperational metadata Increase compliance tostandards Increase confidence andtrust in your information Copyright IBM Corportation 201016
InfoSphere Information Server & Foundation ToolsRequirementsUnderstandDiscover, model, andgovern informationstructure and contentParallelprocessingservices Capture business termsand classificationsIBM InfoSphere Information Server Link business terms andCleanseTransformclassificationsto IT assets Perform data qualityassessment Combine andStandardize, merge,informationandcorrectbusinessinformation rulesrestructureDefinetofor new usesmonitor data quality Discover dataPlatform Servicestransformation rules onships servicesAdministrationservicesDeliverReplicate, virtualizeand move informationfor in-line deliveryDeploymentservices Identify hidden sensitivedata for privacy Define business object forarchival and test dataapplications Copyright IBM Corportation 201017
InfoSphere Information Server & Foundation ToolsRequirementsUnderstandDiscover, model, andgovern informationstructure and contentParallelprocessingservices EffectivelymanageIBM InfoSphere InformationServercomplex challenges ofCleanseTransform namesmulticulturalStandardize, merge,and correct information Support initiatives forCRM,threat and fraud,Combine andReplicate, virtualizeand morerestructureinformationand move informationfor new usesConnectivityservicesDeliverfor in-line delivery Manage complexmulticultural namesPlatform Services Support initiatives thaton consistentMetadata dependAdministrationservices data like: services- CRM- fraud detections- threat management, Copyright IBM Corportation 2010Deploymentservices18
RequirementsInfoSphere Information Server & Foundation Tools Integrate and transformmultiple, complex, anddisparate sources ofinformation to feed:InfoSphere Information Server- data IBMwarehousesTransformUnderstand - MDM initiativesCleanse- Business analytics- eCommerce, Discover, model, andDeliver criticalinformationStandardize,merge,govern information to the pointand correctinformationof actionstructure and contentParallelprocessingservicesCombine andrestructure informationfor new uses Minimize impact onproduction systemsPlatform Services Guarantee data integrity ConnectivityservicesEnabledata deliveryMetadatain servicesAdministrationservicesDeliverReplicate, virtualizeand move informationfor in-line deliveryDeploymentservicesbatch or real time basedon resource and latencyconstraints Seamlessly supportmainframe, distributed,structured andunstructured data sources Copyright IBM Corportation 201019
Multiple Data Delivery Methods for Enterprise NeedsVirtual Data DeliveryBulk Data DeliveryAnalytical & Reporting ToolsWeb Applicationsextract,transform, n 2ProductPerformanceRegion 1ProductPerformanceReal-timeInventory LevelIncremental Data Deliverychange data capturePrimaryData Centerchange data captureBackupData CenterDatabasechange data captureETLMessageQueue Copyright IBM Corportation 2010BusinessApplication20
Classic Data Delivery for z/OS Data Sources Virtual, Bulk and Incremental z/OS data integration with enterpriseinformation initiatives Business IntelligenceReplication Master Data Management Data Warehousing Data Archiving & PrivacyMDMClassicData DeliveryCognosIMS, IDMS, Datacom,Adabas, VSAM & sequential Cross silo synchronizationInformationServer Copyright IBM Corportation 2010Optim21
Bringing Multiple Techniques Together Managing a “real time” dynamic data DB2z/OS Appl.ExcelIMSandmore.CADatacomSQLCA eLoadETL AccelerationDataStage is the “bulk” ETL acceleration foundation. E – the data is extracted from the OLTP informationsources across the enterprise T – 100s of embedded transforms and custom builttransforms are applied L – Aggregated and transformed data is loaded intothe warehouse tablesClassic Federation empowers virtual access: VSAM and other System z data inclusionFederation Server empowers virtual access: DataStage reach beyond “connectors” & plug-ins Copyright IBM Corportation 201022
Bringing Multiple Techniques Together Managing a “real time” dynamic data Warehousez/OSQSAMVSAMPDSLoadETL AccelerationPackagedDB2z/OS Appl.Bulk Delivery is No Longer EnoughIMS The Internet enabled 24 by 7 enterprise is shrinkingthe batch window Data volumes are growing exponentially, quicklyoutstripping our ability to “extract” Yesterday’s data is no longer “enough”, operationalBI demands varying degrees of data latencyExcelandmore.CADatacomSQLCA ServerIDMSSAGADABAS Copyright IBM Corportation 201023
Bringing Multiple Techniques Together Managing a “real time” dynamic data edAppl.Bulk aWarehouseor ODSor DataMartz/OSQSAMVSAMPDSLoadETL veryCADatacomAfter initial LOAD, Changed Data Capture: Pushes updates to your ETL environmentCAIDMS SAGADABAS Empowers “near real time” updatingANDStaging data for batch aggregation Optimizes bandwidth utilizationIncrementalDelivery Copyright IBM Corportation 201024
InfoSphere Deployment Models Native System z Hybrid Deployment:Linux on System z and z/OS Efficient Integrated Facility for Linux processingNative Parallel ProcessingNative z/OS Data AccessMetadata managed and protected in DB2 z/OS or UDB on Linux on z Symmetric Multiprocessors Linux, Unix & Windows Distributed Grid Deployment Parallel execution across nodes Copyright IBM Corportation 201025
Information Server for System zWindowsDS, QSz/OSADMIN, BG,ReportsMetadataWorkbenchIAWeb ConsoleMeta BrokersIA ClientWISDWISD ClientSFTP, DRDA orBatch Pipes Roles-based GUI Design Tools work the way "you" do Copyright IBM Corportation 201026
Information Server for System zWindowsDS, QSADMIN,BG,ReportsMetadataWorkbenchIAWISDWeb Console Meta Brokers IA Client WISD Clientz/OSLinux for System z(also Wintel, Unix & distributed Linux)metadata IA/QS/WISDrepository nformation ServiceFrameworkWebsphere Common reusable servicesframework leverages the power of aSOA environment WAS 6.0.2.20 – App Server(In the box) Shared meta data repositorypromotes reuse, compliance, visuallineage & impact analysis DB2 9.1 on Linux on z(In the box)OR DB2 9.x on z/OS Copyright IBM Corportation 201027
Information Server for System zWindowsDS, QSADMIN,BG,ReportsMetadataWorkbenchIAWISDmetadata IA/QS/WISDrepository metadataWeb Console Meta Brokers IA Client WISD Clientz/OSz/OSLinux for System z(also Wintel, Unix & distributed ormation ServiceFrameworkWebsphere Optional DB2 z/OS for Metadata DB2 z/OS v9.#TCP/IP between zLinux & z/OSCan leverage hipersocketQualifies for zIIP offload Copyright IBM Corportation 201028
Information Server for System zWindowsDS, QSADMIN,BG,ReportsMetadataWorkbenchIAWISDmetadata IA/QS/WISDrepository metadataWeb Console Meta Brokers IA Client WISD Clientz/OSz/OSLinux for System z(also Wintel, Unix & distributed horizationDataStage tion ServiceFrameworkDSEnginePX EngineWebsphere Linux for z Operational EnvironmentRobust, parallel processing withminimal impact on z/OS costs SuSe & Red Hat Copyright IBM Corportation 201029
Information Server for System zWindowsDS, QSADMIN,BG,ReportsMetadataWorkbenchIAWISDmetadata IA/QS/WISDrepository metadataWeb Console Meta Brokers IA Client WISD Clientz/OSz/OSLinux for System z(also Wintel, Unix & distributed horizationDataStage tion ServiceFrameworkDSEnginePX EngineNon-z/OSConnectorsz/OSConnectorsWebsphere Robust "z" & remote connectorsSupports integration with z/OS, Linuxon z and distributed data sources DB2, DB2 for z/OS, Oracle, Copyright IBM Corportation 201030
Information Server for System zWindowsADMIN,BG,ReportsDS, QSMetadataWorkbenchIAWISDz/OSz/OSmetadata IA/QS/WISDrepository metadataWeb Console Meta Brokers IA Client WISD ClientLinux for System z(also Wintel, Unix & distributed tage ServerDSEnginePX ngReportingSFTP, DRDA orBatch PipesMetadataAnalysis esInformation ServiceFrameworkClassic FederationServerWebSphere AppServerOracle,SQL Server,Sybase, Distributed Connectivity includes: SEQ.DB2 V9.1 Linux, Unix, WindowsDB2 UDB V7.x, 8.1, 8.2 for Linux Unix WindowsDB2 UDB V5R1, V5R3, V5R4 for iSeriesInformix Dynamic Server 9.3, 9.4, 9.4x, 10, 11MS SQL Server 7.0, 2000, 2005Oracle 8i R2, 8i R3, 9i R1, 9i R2, 10g R1, 10g R2, 11gSybase 11.5, 11.9, 12.0, 12.5x, 15IMSVSAMIDMSAdabas Datacom z/OS Connectivity includes: DB2zStage:-- DB2 UDB v7.x and 8.1 and 8.2 for z/OS-- DB2 v9.1 for z/OS-- Parallel read and load through DB2 Connect-- Parallel load through Batch Pipes Classic Connect for read/write to QSAM, VSAM,IAM, IMS, CA-IDMS, CA-Datacom and Software AG ADABAS Copyright IBM Corportation 201031
Information Server for System zWindowsADMIN,BG,ReportsDS, QSMetadataWorkbenchIAWISDz/OSz/OSmetadata IA/QS/WISDrepository metadataWeb Console Meta Brokers IA Client WISD ClientLinux for System z(also Wintel, Unix & distributed oggingReportingDB2SchedulingAuthorizationDataStage ServerConnectorAccessServicesInformation ServiceFrameworkDSEnginePX EngineNon-z/OSConnectorsSFTP, DRDA orBatch PipesMetadataAnalysis AccessClassic FederationServerWebSphere AppServerz/OSConnectorsOracle,SQL Server,Sybase, SEQ.WebSphereMQChange Data CaptureChangedDataIMSVSAMIDMSAdabas DatacomData Event Publisher Change Data Capture for incremental updating from: DB2 UDB v8.1 and v8.2 for Linux Unix WindowsDB2 UDB v8.1 and v8.2 for z/OSDB2 v9.1 Linux, Unix, WindowsDB2 v9.1 for z/OSVSAM, IMS, CA-IDMS and Software AG ADABAS for z/OS Copyright IBM Corportation 201032
Agenda The Business Information Challenge IBM InfoSphere Solutions for System z InfoSphere Information Server InfoSphere Foundation Tools and Models InfoSphere Warehouse for System z InfoSphere Master Data Management Why System z? Wrap-up and Additional Q&A Copyright IBM Corportation 201033
Why the System z ?Because it is Designed to deliver the power business needsExceptional in securityReliable, available, and scalableIncredibly virtualizedAffordableManageableA platform companies worldwide believe in Copyright IBM Corportation 201034
Built-In Reliability, Availability and Scalability Greater Reliability Built-in hardware redundancy for uninterrupted operations More reliability More availability Reduced risks associated with downtime Higher availability Double instruction setNon-disruptive upgrades for minimal “reboots”Granular disaster recovery solutionsMinimal downtime Maximum uptimeAvoid downtime costs Lost revenue, fines, lawsuits, etc. Highly scalable Capacity on Demand offerings: Pay only for what you use Applications added in minutes rather than days Faster response to meet Expected or unexpected business needs Customer and internal user demands Copyright IBM Corportation 201035
Innovation leader in virtualization technology Innovation and refinement of virtualization for nearly 40 years Virtualization technology invented by IBM in 1967 Hardware- and software-based for optimum performance and flexibility Share resources among various applications z/VM Virtualization to simplify your IT infrastructure Run hundreds of “virtual” servers on one physical piece of hardware withoutsacrificing performance Use virtualization to run multiple copies of Linux on the mainframe Running Linux on the mainframe combines: Benefits of distributed computing Benefits of the mainframe Reduce time and cost of business growth to help maximize ROI“We found the mainframe to be the first and only one to address the wholeenterprise virtualization and management challenge in a comprehensivemanner. It therefore clearly moves the virtualization ‘state-of-the-art’ wellIan Bramleybeyond other vendor offerings.”Managing DirectorSoftware Strategies Copyright IBM Corportation 201036
Unique Mainframe Shared HardwareCapabilities HiperSockets – Availability you can count onIncreasing bandwidth, decreasing latencyNo external network dependencies, components and associated latencyHeightens network security with minimal changeIntegrated function of z/Architecture on zSeries Cross LPAR Communication on System zMEMORY BUS using HiperSockets z/OSAppl Appl ApplABCSHARED I/OLinuxApps1 nNOTHING SHAREDApplAUNIXApplB.CROSS SYSTEMCOMMUNICATION VIA LANUNIX Copyright IBM Corportation 2010ApplXUNIX37
It’s where your data residesAre you one of these z/OS installation? DB2 for z/OS 25 of the Top 25 Worldwide Banks 9 of the Top 10 Global Life/Health Insurance Providers 23 of the Top 25 US Retailers IMS is used by: Approximately 80% of the largest retail banks inthe US, Germany, Japan, and Australia Majority of business in: Automotive manufacturingUS and European insuranceTelecommunicationsPackage shippingKeep your Information Platform close to your mission critical data Copyright IBM Corportation 201038
Summarizing the Mainframe’s ResurgenceIndustry trendsSystem z provides Regulatory focus on security/compliance . . .Enterprise security, encryption Need to withstand catastrophic events.Enterprise business resilience Deep integration requirements forcollaboration.Hub for integration of Data and Apps Staff costs dominate overall IT spending . . .Centralized management Global, 24 by 7 business via the Web.99.999% application availability Virtual servers address hardwareproliferation, data center sprawl.4 decades invested in virtualization Dramatically rising energy costs(power and cooling).Most efficient use of technology Copyright IBM Corportation 201039
Agenda The Business Information Challenge IBM InfoSphere Solutions for System z InfoSphere Information Server InfoSphere Foundation Tools and Models InfoSphere Warehouse for System z InfoSphere Master Data Management Why System z? Wrap-up and Additional Q&A Copyright IBM Corportation 201040
InfoSphere Strategy & Vision Continued Simplicity & Usability AdvancementsRule & Transformation DiscoveryAutomation to OptimizationPlatform Analytics & DashboardsData Governance Tools Copyright IBM Corportation 201041
IBM is Leading the Way ETL ToolsBusiness Intelligence PlatformsData WarehousingData Quality ToolsData Integration ToolsCustomer Data Integration Copyright IBM Corportation 201042
You Have a Choice Point Products? Tools? Models ? Cleansing ? ETL ?MDM ? Warehouse ?BI Information Platform Copyright IBM Corportation 201043
InfoSphere Communities InfoSphere On-line Community – share and interact with peers around theworld www.ibm.com/community/infosphere Information Champions – recognizes individuals who have made the mostoutstanding contributions to the Information Management community www.ibm.com/software/data/champion Copyright IBM Corportation 201044
Copyright IBM Corportation 201045
creating any warranties or representations from ibm (or its suppliers or licensors), or altering the terms and conditions of any agreement or license governing the use of ibm products and/or software. IBM, the IBM logo, ibm.com, InfoSphere, IBM InfoSphere Information Server, IBM InfoSphere
InfoSphere DataStage—Processes changes delivered from InfoSphere CDC that can be used by InfoSphere DataStage jobs. 4. Related information: Supported sources and targets 5-----IBM InfoSphere Change Data Capture, Version 10.2 About InfoSphere CDC and InfoSphere CDC Management Console
IBM & non-IBM InfoSphere MDM DB2 & non-IBM Cognos & SPSS Unica ECM Data Growth Management InfoSphere Optim Rules / BPM iLog & Lombardi Data Warehouse InfoSphere Warehouse IBM Big Data Solutions Client and Partner Solutions Big Data Enterprise Engines Big Data Accelerators Text Image/Vi
The following instructions are for installing IBM InfoSphere Discovery with IBM DB2 Express Edition. Note: If IBM InfoSphere Discovery cannot be installed using these steps, install the product using the instructions in the IBM InfoSphere Discovery Installation Guide. Procedure 1. Make sure the host meets the hardware and software prerequisites. 2.
IBM InfoSphere Change Data Capture (InfoSphere CDC) is a replication solution that captures database changes as they happen and delivers them to target databases, message queues, or an ETL solution such as InfoSphere DataStage based on table mappings configured in the InfoSphere CDC Management Console GUI application.
quality (InfoSphere Information Server, InfoSphere Data Replication, InfoSphere Federation Server), master data management (InfoSphere MDM), data life-cycle management (I nfoSphere Optim), and data security and privacy (I nfoSphere Guardium and InfoSphere Optim). Please see page 21 for an overview of the
Exploring Data Insights with IBM InfoSphere Master Data Management and IBM Watson Explorer 4 InfoSphere Master Data Management provides a trusted view of an entity, such as person, product, or location. The two products are connected through the InfoSphere MDM connector, as shown in Figure 3.
Additional experience available upon request Professional certifications - IBM 2016 - IBM InfoSphere Change Data Capture Technical Mastery 2016 - IBM InfoSphere DataStage v11.3 2014 - IBM Big Data Fundamentals Technical Mastery 2014 - IBM InfoSphere BigInsights Technical Mast
MPhys Astrophysics with a Year Abroad (2021-22) This specification provides a concise summary of the main features of the programme and the learning outcomes that a typical student might reasonably be expected to achieve and demonstrate if s/he takes full advantage of the learning opportunities that are provided. Awarding Institution University of Southampton Teaching Institution University of .
