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

1

• Dr. Pat Selinger

IBM Fellow and VP of Data Management Architecture and Technology IBM, USA

HTTP HTTP Browsers Browsers SOAP SOAP Requests Requests

• Dir. &
• Dir. &

Security Security MQSeries MQSeries WebSphere WebSphere WebSphere WebSphere (SOAP) (SOAP)

E E D D G G E E S S E E R R V V E E R R S S

DB2 Web Services DB2 XML Extender DB2 Stored Procedures DB2 Federated Support heterogeneous data sources application specific sources IBM UDDI IBM UDDI Registry Registry

• n DB2
• n DB2

DB2 LDAP Support DB2 LDAP Support DB2 XML support store shred /compose search DB2 / MQ DB2 / MQ Integration Integration Messaging Messaging Warehousing Warehousing DB2 Everyplace

DB2 and e-business Infrastructure

DB2 J2EE Support JDBC, SQLJ, JTA EJB Stored Procedures Data Access Beans UNICODE

2

DB2 DB2

Oracle Oracle Informix Informix

TCP/IP TCP/IP Oracle SQL* Net Informix client

Sybase Sybase

Sybase Open Client

MS SQL Server MS SQL Server

MS SQL Srvr ODBC Client Blast Blast

DB2 390 DB2 390 DB2 400 DB2 400 DB2 Windows DB2 Windows DB2 UNIX DB2 UNIX

TCP/IP APPC NetBIOS APPC, TCP/IP DRDA Driver DB2 LAN Driver Flatfile Flatfile Excel Excel Documentum Documentum

Any ODBC Any ODBC Data Data source source

ODBC

Solution: DB2 heterogeneous data federation technology for structured and unstructured data

Engine Enhancements for Federated

• Optimizer
• Rewrite
• Runtime

Generalized Garlic wrapper architecture

XML XML

Challenge: Integrate ALL Data 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

3

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

4

(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

Health Center