Transcript Slide 1
® IBM Software Group IBM Topics-LUW Track Midwest Database User Group March 2009 Jim Strand - Information Mgmt Architect [email protected] © 2004 IBM Corporation IBM Software Group | DB2 information management software Agenda IBM Announcements Jim Strand, IBM, IOD Architect pureXML Database Technology: An Introduction Susan Malaika, Senior Technical Staff Member, IBM's Information Management Group Querying and Managing pureXML Databases: An Overview Susan Malaika, Senior Technical Staff Member, IBM's Information Management Group Best Practice on Using External Stored Procedures and UDFs Benjamin Leung, Staff Software Developer, IBM Toronto Lab Best Practice on transaction log file management Ron Castelletto, Software Developer, IBM Toronto Lab IBM Software Group | DB2 information management software Chicago IBM Information Management Technical and SalesTeam DB2 for Linux, UNIX and Windows, Technical Sales Specialists Jim Strand Dave Chiou Rob Beal 847-805-2509 312-529-1356 847-805-2315 [email protected] [email protected] [email protected] Data Management Software Sales Specialists Alex Olin Eric Christy Jim Pagel Lee Gallerano Alan Schneider 312-455-0599 630-428-3855 414-223-6523 630-717 9683 630-679-0337 [email protected] [email protected] [email protected] [email protected] [email protected] DB2 for z/OS Technical Sales Jason Arnold 414-223-6279 [email protected] 630-568-1860 [email protected] DB2 for z/OS Sales Matt Russo IBM Software Group | DB2 information management software Paperless Society Presentations are now available for download: WWW.MWDUG.ORG Direct Link http://www.mwdug.org/QUARTERLY/2008_4th_Quarter_Handouts.cfm IBM Software Group | DB2 information management software New Product Announcements Performance Expert Extended Insight Feature V3.2 Delivers end-to-end database monitoring of Java database applications See where workloads, transactions, and SQL requests originate in the application, and how the time spent spread across the database client, the application server, the database server, and the network between them. http://www-01.ibm.com/common/ssi/cgibin/ssialias?subtype=ca&infotype=an&appname=iSource&supplier=897&letternum=ENUS208-422 IBM Data Studio V2.1 Deliver and deploy enterprise-ready applications faster and with better performance, security, and manageability http://www-01.ibm.com/common/ssi/cgibin/ssialias?subtype=ca&infotype=an&appname=iSource&supplier=897&letternum=ENUS208-454 Infosphere Information Server 8.1 New features/changes in Version 8.1 IBM InfoSphere Information Server http://www-01.ibm.com/support/docview.wss?rs=14&uid=swg27013419 IBM InfoSphere Traceability Server 2.0 Previously known as WebSphere RFID Information Center http://www-01.ibm.com/software/data/infosphere/traceability-server/ IBM Industry Models V8.1 IBM Industry Data Models for Banking, Retail, Insurance and Health Plans http://www-01.ibm.com/common/ssi/cgibin/ssialias?subtype=ca&infotype=an&appname=iSource&supplier=897&letternum=ENUS208-439 IBM Software Group | DB2 information management software IBM Industry Models Accelerate the definition, development, and deployment of projects. These models are: Proven: The top three banks and insurance companies worldwide are using the IBM Industry Models in various facets of their business-driven IT strategies, such as risk and compliance reporting and process transformation. Business-ready: The models foster collaboration between business and IT, turning business requirements into actionable solutions. Regulation-aware: Subject matter experts distilled compliance regulations into statutory reporting and business process requirements, without the need for external development. Comprehensive: Content garnered from multiple client engagements is turned into a suite of interrelated data, process, and service models, with a proven methodology and with models that require minimal customization. Enterprise standards-compliant: The models support architecture-standardization projects for the enterprise related to process and information-centric initiatives. These initiatives include core system renewal, process transformation, integration through service-oriented architecture (SOA), data governance, and consolidated operational insight, risk and compliance, and performance management projects. IBM Software Group | DB2 information management software Information On Demand Conference Information On Demand 2009 October 25 - 30, 2009 Mandalay, Las Vegas Highlights included: 900 Elective sessions 1,040 Certification exams 200 EXPO Sponsors and 120 IBM Pedestals 225 Customer and Business Partner speakers Hands-on Labs Meet the Experts Community Receptions Customer Reference Lounge IBM Software Group | DB2 information management software Information on Demand and the Information Agenda http://www-01.ibm.com/software/data/information-agenda/ IBM Software Group | DB2 information management software Organizations need an Information Agenda An approach for unlocking the business value of information Strategy Creating a vision to guide decisions & align with business priorities Information Infrastructure Identifying the technology components & capabilities to establish a common information framework Establishing a plan for Implementing cross line of business policies & practices for managing, using, improving & protecting information Information Governance executing discrete projects to realize short and long-term returns on investment Roadmap Make it happen: Info Agenda Workshops IBM Software Group | DB2 information management software Local Events & Proof of Technology 3/19/09 - Informix Dynamic Server 11.50 - delivering MACH-11 Chicago, IL 3/24/09 - DB2 9.5 Administration for the Oracle DBA - Chicago, IL 4/02/09 - Optim TDM and Archiving – Milwaukee, WI 4/14/09 - Optim TDM and Archiving - Chicago, IL 4/15/09 - Data Studio pureQuery For DBAs and Application Developers (v1.2a) - Chicago, IL 4/23/09 - Data Studio pureQuery For DBAs and Application Developers (v1.2a) – Milwaukee, WI 5/7/09 - solidDB Workshop - Chicago, IL IBM Software Group | DB2 information management software Webinars 3/5/09 - Managing your JD Edwards Data in Today's Economy http://www.informationmanagementrequest.com/ 3/10/09 - Availability and Scale-Out Technologies for DB2 https://www2.gotomeeting.com/register/808707279 3/11/09 - Best Practice: Plotting a Course to a Successful Siebel Archiving Project https://www.informationmanagementrequest.com/mk/get/OPTIM_SAWEB1_REG 3/18/09 - The Essentials of Test Data Management https://www.informationmanagementrequest.com/mk/get/ 3/25/09 - Application and Database Instance Consolidation 4/2/09 - Managing your Oracle E-Business Suite Data in Today's Economy IBM Software Group | DB2 information management software Chat with the Labs Listen to the experts who develop breakthrough technology and get your questions answered DB2 – See schedule and replays available: http://www‐01.ibm.com/software/data/db2/9/labchats.html Business Intelligence and Data Warehousing – Please contact your DM Sales Rep Informix – See schedule and replays available: http://www‐01.ibm.com/software/data/informix/webcasts/replay.html IBM Software Group | DB2 information management software WDUG Special Event – Wednesday April 22nd and Thursday April 23rd Melanie Stopfer Where: West Bend Mutual, West Bend Wisconsin When: 8am – 4:30pm How Much: $100/person/day or $175/person/two days, cost includes breakfast, snacks, and lunch Worth: Priceless … many LUW topics as well as DB2 Connect Performance and Problem resolution Registration: www.wdug.com IBM Software Group | DB2 information management software IBM Information Management Links Information on Demand Group on YouTube http://www.youtube.com/infoondemand Information on Demand Group on facebook www.facebook.com Data Governance Encryption Data Privacy/Masking (prod/test/qa) Security White Papers found at http://www-306.ibm.com/software/data/db2imstools/solutions/compliance.html Infosphere Warehouse Forum http://www-128.ibm.com/developerworks/forums/forum.jspa?forumID=1062 IBM Data Management Community http://www-01.ibm.com/software/data/management/community.html IBM Software Group | DB2 information management software DB2 Magazine/Newsletter Monthly magazine Includes Questions and Answers Blogs IBM news Books recommendations Skills set IBM Database Magazine – http://www.ibmdatabasemag.com/ IBM Database Magazine Newsletter – http://www.ibmdatabasemag.com/newsletter/ IBM Data Management Community – http://www‐01.ibm.com/software/data/management/com munity.html IBM Software Group | DB2 information management software DB2 e-books Previously Featured Titles: > Beginning DB2: From Novice to Professional > Administering Informix Dynamic Server: Building the Foundation > Executing SOA > SOA for the Business Developer: Concepts, BPEL, and SCA > Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL > Understanding DB2(R): Learning Visually with Examples, Second Edition www.db2mag.com/Bookstore IBM Software Group | DB2 information management software DeveloperWorks Spaces developerWorks spaces are micro-sites focused on a software project, development activity, user group community, technical expert, or any other technical subject of interest to you. Join one of the spaces or apply for your own. http://www.ibm.com/developerworks/spaces/ IBM Software Group | DB2 information management software DB2 Certification Exam Study Information Study Aids and Technical References http://www-01.ibm.com/software/data/education/ http://www-01.ibm.com/software/data/education/certprep.html IBM Software Group | DB2 information management software IBM Data Studio ww.w.ibm.com/software/data/studio FAQs Tutorials Downloads Forums Blogs IBM Software Group | DB2 information management software Learn more about DB2 www.ibm.com/developerworks - Information Management -Techincal Library Take advantage of the free IBM Migration Toolkit Simplifies and improves your migration to DB2 for Linux, UNIX, and Windows Provides a wizard and an easy-to-use, five-step interface Build the next generation application using DB2 9 and ASP.NET 2.0 Help newcomers to IBM DB2 9 learn how to use ASP.NET Acts as a quick, interactive guide Business Intelligence Reporting Tool with DB2 Data Warehouse Edition (BIRT) An open source tool for report generation Ability to generate reports based on relational data and provide interactivity between them This series of tutorials demonstrates the best practices for installing BIRT