Dr. Pat Selinger IBM Fellow and VP of Data Management Architecture - PDF document

Dr. Pat Selinger IBM Fellow and VP of Data Management Architecture and Technology IBM, USA DB2 and e-business Infrastructure DB2 J2EE Support JDBC, SQLJ, JTA DB2 EJB Everyplace Stored Procedures DB2 LDAP Support DB2 LDAP Support Data Access Dir. & E E Dir. & Beans D Security Security HTTP HTTP D UNICODE Browsers G G Browsers E E WebSphere WebSphere S S E E DB2 / MQ MQSeries DB2 / MQ MQSeries R R Integration Integration V V DB2 XML support Messaging Messaging E E store Warehousing SOAP Warehousing SOAP R R shred /compose Requests Requests WebSphere S S WebSphere search (SOAP) (SOAP) DB2 Web Services IBM UDDI IBM UDDI DB2 XML Extender Registry Registry DB2 Stored on DB2 DB2 Federated on DB2 Procedures Support heterogeneous data sources application specific sources 1

Challenge: Integrate ALL Data Solution: DB2 390 DB2 390 DB2 400 DB2 400 DB2 APPC, TCP/IP DB2 Windows DB2 Windows heterogeneous TCP/IP DB2 DB2 DRDA Driver DB2 UNIX APPC DB2 UNIX NetBIOS DB2 LAN Driver data federation Oracle Engine TCP/IP Oracle SQL* Net Oracle technology for Enhancements Informix client for Federated TCP/IP Sybase structured and - Optimizer Open Client Informix Informix - Rewrite MS SQL Srvr ODBC Client - Runtime unstructured ODBC Sybase Sybase data Flatfile Flatfile Generalized Garlic wrapper architecture MS SQL Server MS SQL Server Excel Excel Any ODBC Any ODBC Blast Blast Data Data Documentum Documentum source source XML XML DB2 VLDB Federation Features • Auto-discovery of servers • Cost and function models for remote data sources • Global heterogeneous query optimization • Full DB2 function for low function sources: e.g. sophisticated analysis against flat files • Wrappers proven against non-relational sources (XML, flat files, Excel, Documentum, ..) • Complementary to DB2's web services producer/consumer capabilities 2

Challenge: Speed of Application Development • Solution: DB Integration with Queues • select MQSend(e.lastname || ' ' || d.manager) from employee e, dept d where e.deptno = d.deptno • insert into MESSAGE_ARCHIVE(time, msg) values (current time, MQRead()) • CREATE TRIGGER new_employee AFTER INSERT ON employee REFERENCING NEW AS n FOR EACH ROW • MODE DB2SQL VALUES MQPublish('HR_INFO_PUB', current date || ' ' || lastname || ' ' || DEPARTMENT,'NEW_EMP') • dxxmqShred - decompose a single XML message • dxxmqShredAll - decompose all XML messages in a queue Challenge: Complexity of DB Admin and Maintenance • DB2's Approach: automatically – Monitor system health – Recognize potential problems – Identify causes – Fix or allay causes – Before they're fatal! – Cause no harm! – A major headache for DBAs (time, complexity) • Solution: The DB2 Health Center – Low-overhead monitoring of system health – Automatically diagnose & fix potential problems 3

Health Center (horman@healthy) /home/horman $ db2 get health snapshot for DBM Database Manager Health Snapshot Node type = Database Server with local clients Instance name = horman Snapshot timestamp = 03-27-2002 13:24:51.799180 Database Manager Health Indicators: Health Indicator ID = 2 (db2.sort_privmem_util) Value = 86 Evaluation timestamp = 03-27-2002 13:20:07.910561 Alert state = warning 4