Transcript Title Slide

IBM Topics – Dec 8, 2010
Debra Eaton
Information Management
IBM Software Group
[email protected]
0
Go Green – Save a Tree
Presentations are now available for download:
WWW.MWDUG.ORG
Chicago IBM Information Management Team
DB2 for Linux, UNIX and Windows Technical Sales Specialist
– Robert Beal
847-805-2315 [email protected]
– David Chiou
312-529-1356 [email protected]
– Debra Eaton
312-635-1474 [email protected]
Data Management Software Sales Specialists
– Mark Brenner
630-568-1371
[email protected]
– Eric Christy
630-430-8215
[email protected]
– Lee Gallerano
630-362-1311
[email protected]
– Bill McMullen
612-397-2265
[email protected]
– Tom Novello
630-338-9989
[email protected]
– Alex Olin
312-455-0599
[email protected]
– Jim Pagel
262-391-1173
[email protected]
Agenda
08:30am - 09:00am
Registration: Coffee and juice
09:00am - 09:15am
IBM Topics
09:15am – 10:30am Workload Consolidation Using DB2 LUW
Andrew Buckler, IBM Toronto Lab
10:30am – 10:45am Break
10:45am – 12:00pm Data Integration with IBM’s Change Data
Capture and Replication Solution
Davendra Paltoo, IBM
12:00pm – 01:00pm
Lunch Onsite – Free
01:00pm – 02:15pm
Best Practices for Upgrading to DB2 9.7
Brian Mealman, IBM Minneapolis
02:15pm – 02:30pm
Break
02:30pm – 03:45pm
IBM Infosphere Guardium: A
Comprehensive Database Security Solution
Brian Mealman, IBM Minneapolis
Speaker Biographies
Andrew Buckler, IBM - DB2 Emerging Technologies - Customer Enablement. Andrew was part of the
DB2 LUW development organization for nearly ten years. During that time he worked on a variety of DB2
engine and tools products, including the DB2 Web Health Center and Web Command Center, the DB2
Health Monitor, the optimizer, and a variety of high availability technologies. His final development project
was working as a development lead on DB2 pureScale's failure recovery and cluster management system.
Currently, Andrew is working on customer and sales enablement for new DB2 technologies emerging from
IBM's labs.
Brian Mealman, IBM - IBM Certified, Consulting IT Specialist and Information Management Technical
Sales Specialist. Brian has 30 years of experience in the IT industry. He was an IBM customer for 4 years
and has been an IT Specialist for 26 years with IBM. Brian started as a VM Systems Programmer and then
moved to Relational Database Technology soon after he joined IBM. He has worked with most IBM
Relational Database Technology including: SQL/DS, OS/2 Database Manager, DB2 for VM & VSE, DB2 for
Linux, UNIX and Windows, and DB2 for z/OS.
Davendra Paltoo, IBM - Manager of QA and Automation. Davendra has 10 years experience working with
CDC technologies and databases. In 2000, he joined Datamirror Corporation, a company that specialized in
real-time data integration primarily between databases. Datamirror Corp. was acquired by IBM in 2007.
While at Datamirror, Davendra worked in Technical Support working with customers to solve issues with
Datamirror products and in Product Development focusing on Quality Assurance. After the IBM acquisition,
Davendra joined IBM’s Software Group. He currently manages the CDC Quality Assurance team at the
Toronto Lab. He is certified as an Oracle DBA.
New DB2 Connect Users Group – Curt Cotner Session
DB2 LUW Flashes
– DB2 HIPER APAR IC72335 - Extent movement can cause Incremental Backup
Corruption
– Extent movement in DB2 9.7 can cause corruption in Incremental backups. This
technote discribes the issue, a workaround, and when the issue will be...
– 04 Nov 2010 Known issues for DB2 on AIX 5.2, 5.3, 6.1, and 7.1
– This document describes known AIX® issues and APARs related to DB2®.
Fixes for the AIX APARs described below can be obtained from Fix Central at...
– 29 Oct 2010 Security Vulnerabilities and HIPER APARs fixed in DB2 for Linux,
UNIX, and Windows Version 9.7
– This document contains a list of fixes for Security and HIPER APARs in DB2
Version 9.7 IBM® recommends that you review the APAR descriptions and
deploy...
– 13 Oct 2010 Security Vulnerabilities and HIPER APARs fixed in DB2 for Linux,
UNIX, and Windows Version 9.5 Fix Pack 6a
– Fix Pack 6a for DB2 V9.5 is now available which includes fixes for some security
vulnerabilities and HIPER APARs. These fixes, where applicable, are...
– 04 Oct 2010 DB2 9.5 FP6 and DB2 9.7 FP3 fix pack images have been
replaced.
– The fix pack images for DB2 9.7 FP3 and DB2 9.5 FP6 have been replaced with
images containing fixes for two Hiper APARs.
Beta Programs
– DB2 Merge Backup for Linux, UNIX and Windows is a new tool
for merging DB2 incremental/ delta backups with older full
backups to create a brand new backup, essentially reducing the
amount of time it takes to take a full backup.
– DB2 Recovery Expert (completely re-architected) and we are
now trying to market this as part of a new bundle that also
includes DB2 Merge Backup and HPU
– Ask your IBM Representative about participating
Product Announcements
Des cription
Date
Num ber
Surface new information insights w ith IBM Mashup Center V3.0
2010-11-16
210-403
IBM InfoSphere Optim Configuration Manager V1.1 centralizes management of database configurations w ith registration of key database information
2010-11-16
210-437
IBM InfoSphere Change Data Capture for z/OS , V6.5 delivers real-time data integration
2010-11-09
210-407
IBM InfoSphere Streams V1.2.1 offers new Resource Value Unit pricing and offers a Developer Edition
2010-10-26
210-428
IBM DB2 10 for z/OS improves efficiency and resiliency
2010-10-19
210-380
IBM InfoSphere Replication Server for z/OS and IBM InfoSphere Data Event Publisher for z/OS extend real-time data integration solutions for IBM DB2 for
z/OS
2010-10-19
210-382
IBM Cognos Business Intelligence V10.1
2010-10-19
210-348
IBM Optim Query Workload Tuner for DB2 for z/OS , V2.2.1 can help cut cost and improve performance
2010-10-19
210-406
IBM DB2 : New tools help you better manage your environment
2010-10-19
210-345
IBM InfoSphere Optim solutions for z/OS offer Test Data Management and Data Grow th solutions for IMS/VSAM/SEQ, Adabas, CA-IDMS, and CADatacom w ith InfoSphere Classic Federation
2010-10-19
210-325
IBM InfoSphere Optim Application Repository Analyzer delivers ability to analyze metadata repository of packaged applications such as Oracle EBusiness Suite, JD Edw ards, PeopleSoft, and Siebel
2010-10-19
210-286
IBM Smart Analytics System 7700 harnesses the massive parallelization of POWER7 processor-based systems to deliver pow erful analytics, delivering
information how , w hen, and w here it is needed
2010-10-12
210-126
IBM Smart Analytics System 7700 R1.1 meets your evolving business analytics requirements w ith fast time-to-value solutions
2010-10-12
210-115
IBM Informix 11.7 delivers grid and enhanced embed capabilities for industry-leading flexibility, reliability, speed, and efficiency
2010-10-12
210-367
IBM InfoSphere Information Server V8.5 including IBM InfoSphere Foundation Tools helps deliver trustw orthy information
2010-10-12
210-177
IBM Optim High Performance Unload for DB2 for Linux , UNIX , and Window s V4.2 provides a high speed w ay to unload data from DB2
2010-10-05
210-354
Unleash your information w ith DB2 9.7 Advanced Enterprise Server Edition and enterprise mashup capabilities in InfoSphere Warehouse 9.7.2
2010-10-05
210-377
IBM Smart Analytics System 5600 offers pow erful analytics, delivering information w henever and w herever needed
2010-10-05
110-221
IBM Optim distributed products Version 7.3 offer new database and operating system support, extract and archive performance improvements, and
deeper Optim Designer support
2010-09-21
210-279
IBM InfoSphere Change Data Capture V6.5 and IBM InfoSphere Change Data Delivery V6.5 help deliver real-time data integration
2010-09-14
210-270
DB2 Advanced Enterprise Edition 9.7
Small Incremental Cost Over DB2 Enterprise Edition,
Includes:
– Homogeneous Replication (Q-Replication for DB2 LUW to DB2
LUW point to point only)
– Storage Optimization (Compression of Rows, Indexes, Temp
Tables)
– DB2 Advanced Access Control (LBAC)
– Performance Optimization Feature (WLM, Query Patroller, Data
Studio Workload Analyzer, and Optim Performance Manager)
– Federation Server (Oracle Data Sources only)
InfoSphere Warehouse 9.7.2
New functionality added to IW Base Edition at no additional
cost:
– Optim Data Base Administrator
– Optim Development Studio
– Homogeneous Replication (Q-Replication for DB2 LUW to DB2
LUW point to point only)
– Cognos Business Intelligence
New functionality added to IW Enterprise Edition at no
additional cost .. The above features plus:
– Enterprise Mashup Center
– Federation Server (Oracle Data Sources only)
Other ‘Free’ Features Now Added to DB2 Licenses
DB2 LUW and DB2 Connect
– Optim Data Administrator
– Optim Development Center
DB2 WorkGroup Edition
– pureScale included for free in DB2 V9.8 Workgroup Edition …
limited to 4 sockets running across the cluster
– Memory constraint lifted to 64gb
Listen to the experts who develop breakthrough technology and get your questions answered
• DB2 – See schedule and replays available:
www‐01.ibm.com/software/data/db2/9/labchats.html
• Business Intelligence and Data Warehousing
www-01.ibm.com/software/data/education/bichat.html
• Informix – See schedule and replays available:
www‐01.ibm.com/software/data/informix/webcasts/replay.html
Webcasts, etc
DB2 Night Show – Scott Hayes, DBI
www.dbisoftware.com/db2nightshow/
Information Management Sites
IBM Information Management Links
–
Information Management Training
www-01.ibm.com/software/data/education/blogs.html
–
IBM Training Classes
www-304.ibm.com/jct03001c/services/learning/ites.wss/us/en?pageType=page&c=B768303T50066D41
–
Information Management ‐ Downloads, Trial Offers, White Papers
www14.software.ibm.com/webapp/download/featured.jsp?b=Information+Management
–
IBM Data Management Community
www-01.ibm.com/software/data/management/community.html
–
IBM Data Mangement Magazine
www.ibm.com/developerworks/data/dmmag/
–
IBM Database Magazine Newsletter
www.ibmdatabasemag.com/newsletter/
–
IBM Data Management Community
www‐01.ibm.com/software/data/management/community.html
–
Integrated Data Management (Optim and Data Studio) -www.ibm.com/developerworks/spaces/datastudio?ca=dgp‐my
–
Data Governance (Encryption, Data Privacy/Masking (prod/test/qa), Security)
–
http://www-306.ibm.com/software/data/db2imstools/solutions/compliance.html
–
Social Media Connects (facebook ,Twitter ,YouTube, Communities) 304.ibm.com/jct03001c/services/learning/ites.wss/us/en?pageType=page&c=J522048D22090L87
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.
www.ibm.com/developerworks/spaces/
Learn more about DB2
www-01.ibm.com/software/data/db2/express/
developerWorks
IBM's resource for developers and IT professionals
www.ibm.com/developerworks
ENJOY
TODAY’S
PROGRAM