210 likes | 426 Views
IBM Topics-LUW Track. Midwest Database User Group March 2009 Jim Strand - Information Mgmt Architect jdstrand@us.ibm.com. Agenda. IBM Announcements Jim Strand, IBM, IOD Architect pureXML Database Technology: An Introduction
E N D
IBM Topics-LUW Track Midwest Database User Group March 2009 Jim Strand - Information Mgmt Architect jdstrand@us.ibm.com
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
Chicago IBM Information ManagementTechnical and SalesTeam • DB2 for Linux, UNIX and Windows, Technical Sales Specialists • Jim Strand 847-805-2509 jdstrand@us.ibm.com • Dave Chiou 312-529-1356 dwchiou@us.ibm.com • Rob Beal 847-805-2315 rbeal@us.ibm.com • Data Management Software Sales Specialists • Alex Olin 312-455-0599 aolin@us.ibm.com • Eric Christy 630-428-3855 ewchrist@us.ibm.com • Jim Pagel 414-223-6523 jkpagel@us.ibm.com • Lee Gallerano 630-717 9683 lgallerano@us.ibm.com • Alan Schneider 630-679-0337 aschneider@us.ibm.com • DB2 for z/OS Technical Sales • Jason Arnold 414-223-6279 jaarnold@us.ibm.com • DB2 for z/OS Sales • Matt Russo 630-568-1860 russo2@us.ibm.com
Paperless Society • Presentations are now available for download: • WWW.MWDUG.ORG • Direct Linkhttp://www.mwdug.org/QUARTERLY/2008_4th_Quarter_Handouts.cfm
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/cgi-bin/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/cgi-bin/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/cgi-bin/ssialias?subtype=ca&infotype=an&appname=iSource&supplier=897&letternum=ENUS208-439
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.
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
Information on Demand and the Information Agenda http://www-01.ibm.com/software/data/information-agenda/
Organizations need an Information AgendaAn approach for unlocking the business value of information Make it happen: Info Agenda Workshops
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
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
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
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 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
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/community.html
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
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/
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 Data Studio ww.w.ibm.com/software/data/studio • FAQs • Tutorials • Downloads • Forums • Blogs
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