Transcript IBM Briefing for March 2005

IBM Software Group
LAADB2UG
Romy Albarico
Software I/T Specialist
9/2/2004
Confidential | Date | Other information, if necessary
© 2002 IBM Corporation
IBM Software Group | DB2 Data Management Software
DB2 End of Service Dates
DB2 Versions
Products
V7.2
DB2 Universal Database and ALL
DB2 Connect
V8.1
DB2 Universal Database and ALL
DB2 Connect
V8.2
DB2 Universal Database and
DB2 Connect
V6
DB2 for OS/390
6/30/05
V7
DB2 for OS/390
TBA
V8
DB2 for z/OS
TBA
V7
IMS for OS/390
V8
IMS for z/OS
TBA
V9
IMS for z/OS
TBA
LAADB2UG | Presentation Subtitle | Confidential
Editions
End of Service
Extended to 9/30/04
At least April 2006
TBA
11/30/05
© 2002 IBM Corporation
IBM Software Group | DB2 Data Management Software
Events
LAADB2UG | Presentation Subtitle | Confidential
© 2002 IBM Corporation
IBM Software Group | DB2 Data Management Software
Websphere Information Integrator Proof
of Technology
• Costa Mesa 3/15
– IBM's newest replication technology is designed for DB2 environments
with high transaction rates and the need for low-latency replication.
Websphere Information Integrator
– Queue Replication uses Websphere MQ Series to replicate large numbers
of transaction from one DB2 system to another very quickly. This solution
is a natural fit for high
– Availability/disaster recovery requirements, since both the primary and the
backup sites are available for applications and users. The DB2 source
transactions can also be
– Event Publishing in XML format for use by customer applications.
– This Proof-of-Technology includes a technical overview of Websphere
Information Integration Queue Replication. Hands-on exercises are
included to introduce you to the setup.
LAADB2UG | Presentation Subtitle | Confidential
© 2002 IBM Corporation
IBM Software Group | DB2 Data Management Software
DB2 and BI Technical Conference
Orlando
Sept 12th – 16 2005
Classes
Labs
Vendor Showcase
Certification Testing
Register at http://www306.ibm.com/services/learning/ites.wss/us/en?pageType=page&c=a0000713
LAADB2UG | Presentation Subtitle | Confidential
© 2002 IBM Corporation
IBM Software Group | DB2 Data Management Software
IDUG
When
ƒMay 22 - 26, 2005
Where
ƒClose - Denver
For More Information
ƒhttp://conferences.idug.org/namerica/2005/index.cfm
LAADB2UG | Presentation Subtitle | Confidential
© 2002 IBM Corporation
IBM Software Group | DB2 Data Management Software
Learn
LAADB2UG | Presentation Subtitle | Confidential
© 2002 IBM Corporation
IBM Software Group | DB2 Data Management Software
FREE Technical Webcast #1
Webcast: Migrating to DB2 Version 8 - 3/1 8am pst
Roger Miller, IBM DB2 for z/OS & Large German Bank GAD
This session will familiarize you with productivity-building Version 8 functions
that enable you to more quickly respond to business requirements. Key
improvements include scalability, ability to port applications, and to deliver
continuous availability. Designed to help you quickly take full advantage of the
enhancements in Version 8, the session will focus on the migration process, with
guidance from DB2 experts on advance planning—as well as recommendations
from users.
Webcast Replay Registration
ƒ Go to //http://webevents.broadcast.com/ibm/swg/030105
LAADB2UG | Presentation Subtitle | Confidential
© 2002 IBM Corporation
IBM Software Group | DB2 Data Management Software
FREE Technical Webcast #2
Webcast: Optimizing your performance in DB2 for z/OS® environments
Tools: Omegaman and Other IBM DB2 Performance Tools
Are you meeting your IBM® DB2® Service Level Agreements? Whether
or not, what is causing your performance problems? More specifically,
which SQL statements? Why are they a problem and how will you fix it
without traces and tremendous effort? And more importantly, how will you
move from being reactive to proactive in DB2 for zperformance tuning?
Now, you can look to the IBM DB2 for z Performance Tools to make this all
possible.
Webcast Replay Registration
ƒRegister online right now. Visit ibm.com/software/zseries/telecon/feb2
LAADB2UG | Presentation Subtitle | Confidential
© 2002 IBM Corporation
IBM Software Group | DB2 Data Management Software
Interested?
• For the POT, Onsite Webcasts, Demonstrations
or help migrating to DB2 V8 contact Mark
DePledge [email protected]
LAADB2UG | Presentation Subtitle | Confidential
© 2002 IBM Corporation
IBM Software Group | DB2 Data Management Software
White Paper
• DB2 Performance Expert and Connect Monitoring
– http://www306.ibm.com/services/learning/ites.wss/us/en?pageType=page
&c=a0000713
• DB2 V8 - Migrate Now
– ftp://ftp.software.ibm.com/software/db2storedprocedure/db2z
os390/techdocs/timemigr.pdf
• DB2 V8 Business Value – Executive Summary and ROI
– http://www1.ibm.com/support/docview.wss?rs=64&context=SSEPEK&u
id=swg27005465
LAADB2UG | Presentation Subtitle | Confidential
© 2002 IBM Corporation
IBM Software Group | DB2 Data Management Software
Latest Redbooks
 Draft Redbook - WebSphere Information Integrator Q replication: Fast
Track Implementation Scenarios
Redbook - DB2 for z/OS and WebSphere: The Perfect Couple
Redbook - Systems Programmer's Guide to Resource Recovery Services
(RRS)
Redbook - Disaster Recovery with DB2 UDB for z/OS
Redbook - Large Objects with DB2 for z/OS and OS/390
Redbook - DB2 for z/OS Stored Procedures: Through the CALL and
Beyond
Redbook - DB2 UDB for z/OS V8: Through the Looking Glass and What
SAP Found There
Redbook - DB2 UDB for z/OS Version 8: Everything You Ever Wanted to
Know, ... and More
LAADB2UG | Presentation Subtitle | Confidential
© 2002 IBM Corporation
IBM Software Group | DB2 Data Management Software
DB2 Web Sites
IBM Software for z/OS
ƒ http://www-306.ibm.com/software/os/zseries/
IBM Data Management Tools
ƒ http://www-3.ibm.com/software/data/db2imstools/index.html
DB2 Data Management
ƒ http://www-3.ibm.com/software/data/
DB2 Developer Domain
ƒ http://www7b.boulder.ibm.com/dmdd/
DB2 for z/OS Library
ƒ http://www-306.ibm.com/software/data/db2/zos/library.html
IBM Redbooks
ƒ http://www.redbooks.ibm.com/
LAADB2UG | Presentation Subtitle | Confidential
© 2002 IBM Corporation
IBM Software Group | DB2 Data Management Software
DB2 Web Sites - Support
APAR Search
ƒ https://techsupport.services.ibm.com/server/zseries.srch
Broker
Data Management Consulting
ƒ Health Check
ƒ High Availability Health Check
ƒ Data Management Tools Services Health Check
ƒ Security Health Check
ƒ https://techsupport.services.ibm.com/server/services
DB2 Library
ƒ http://www306.ibm.com/software/data/db2/zos/library.html
LAADB2UG | Presentation Subtitle | Confidential
© 2002 IBM Corporation
IBM Software Group | DB2 Data Management Software
DB2 Products
LAADB2UG | Presentation Subtitle | Confidential
© 2002 IBM Corporation
IBM Software Group | DB2 Data Management Software
DB2 V8.1 for z/OS
DB2 V8.1 GA on March 26, 2004
This new version breaks through many old limitations in the definition of DB2
objects, including:
ƒ SQL performance and compatibility improvements
ƒ 64 Bit means more memory available
ƒ on-line schema evolution
ƒ longer names for tables and columns
ƒ longer SQL statements
ƒ enhanced Java and Unicode support
ƒ enhanced utilities
ƒ more log data sets
ƒ more partitions
SQL enhancements provide for even tighter DB2 UDB family compatibility, which
in turn helps our ISV and application programmers effectively leverage their skills
and resources.
LAADB2UG | Presentation Subtitle | Confidential
© 2002 IBM Corporation
IBM Software Group | DB2 Data Management Software
QMF V8.1 and DB2 Tools
QMF V8.1 GA on March 26, 2004
Dramatically enhanced with:
ƒ new data visualization
ƒ solution building
ƒ drag-and-drop queries and analytics
ƒ executive dashboards
ƒ QMF for WebSphere, which lets any web browser become a zeromaintenance thin client for visual access to DB2 data.
LAADB2UG | Presentation Subtitle | Confidential
© 2002 IBM Corporation
IBM Software Group | DB2 Data Management Software
DB2 Tools
Administration Tools
ƒ DB2 Administration Tools
ƒ DB2 Automation Tools
ƒ DB2 HP Unload
ƒ DB2 Object Comparison Tool
ƒ DB2 Utilities Suite
Application Management Tools
ƒ DB2 Bind Manager
ƒ DB2 Test Database Generator
ƒ DB2 Path Checker
ƒ DB2 Table Editor
ƒ DB2 Web Query Tool
* New Enhancements
LAADB2UG | Presentation Subtitle | Confidential
Performance Management Tools
ƒ DB2 Buffer Pool Analyzer
ƒ DB2 Performance Expert
ƒ DB2 Performance Monitor
ƒ Omegamon
ƒ DB2 Query Monitor
ƒ DB2 SQL Performance Analyzer
Recovery and Replication Management Tools
ƒ DB2 Archive Log Compression
ƒ DB2 Change Accumulation
ƒ Webshere Information Integrator Replication
for z/OS
ƒ DB2 Log Analysis Tool
ƒ DB2 Object Restore Tool
ƒ DB2 Recovery Expert for Multiplatform
ƒ DB2 Data Archive Expert Tool
© 2002 IBM Corporation
IBM Software Group | DB2 Data Management Software
Whats New with DB2 Tools
•
•
•
•
•
•
DB2 Connect Monitoring
SQL Exception Alerting
Exploitation DB2 V8 – More than Toleration
Schema Evolution
System and Application Database Recovery
Queue Replication to increase availability,
flexibility and minimize administration
• Data Archiving
LAADB2UG | Presentation Subtitle | Confidential
© 2002 IBM Corporation
IBM Software Group | DB2 Data Management Software
DB2 Multiplatform Tools
DB2 HP Unload
DB2 Table Editor
DB2 Performance Expert
DB2 Recovery Expert
DB2 Web Query Tool
DB2 Test Database Generator
The DB2 Multiplatform Tools support DB2 Universal Database (UDB) running on
Linux (Intel32), UNIX, and Windows (LUW). All DB2 Multiplatform Tools support
DB2 UDB Version 7 and Version 8. In addition, Try-and-Buy code for DB2
Multiplatform Tools is shipped with every licensed copy of DB2 UDB Enterprise
Server Edition, Version 8.
LAADB2UG | Presentation Subtitle | Confidential
© 2002 IBM Corporation
IBM Software Group | DB2 Data Management Software
DB2 Software Downloads
http://www-306.ibm.com/software/data/db2/zos/dld.html
Control Center for DB2
DB2 Colon Finder
DB2 Estimator
DB2 Installer
DB2 Stored Procedure Builder
SQLJ
Visual Explain
LAADB2UG | Presentation Subtitle | Confidential
© 2002 IBM Corporation