Front cover -- Contents -- Figures -- Tables -- Notices -- Trademarks -- Preface -- The team that wrote this redbook -- Notice -- Comments welcome -- Chapter 1. Introduction -- Chapter 2. Java enablement -- 2.1 JDBC support -- 2.1.1 What is JDBC? -- 2.1.2 DB2 JDBC support -- 2.1.3 Advantages of using JDBC -- 2.1.4 JDBC 2.0 specifications -- 2.1.5 Determining which version of JDBC that DB2 is using -- 2.1.6 Changing the version of JDBC that DB2 is using -- 2.1.7 DB2 and JDBC hints and tips -- 2.2 Overview of DB2's Java enablement -- 2.2.1 Setting the environment -- 2.2.2 Java packages -- 2.2.3 Java file extensions -- 2.2.4 SQL security in Java -- 2.3 SQLJ -- 2.3.1 What is SQLJ? -- 2.3.2 DB2 SQLJ support and restrictions -- 2.3.3 Calling stored procedures and functions within SQLJ -- 2.3.4 Compiling and running SQLJ applications -- 2.4 Accessing stored procedures and UDFs using Java -- 2.4.1 Overview -- 2.4.2 Registering stored procedures -- 2.4.3 Running stored procedures -- Chapter 3. Java application development for Web servers -- 3.1 DB2 UDB Universal Developer's Edition V7.2 (UDE) -- 3.1.1 Overview -- 3.2 WebSphere Application Server -- 3.2.1 Overview -- 3.2.2 WebSphere Application Server Enterprise Edition V4.0 -- 3.2.3 WebSphere Application Server Advanced Edition V4.0 -- 3.2.4 WebSphere Application Server Standard Edition V3.5 -- 3.3 The evolution of WebSphere tooling -- 3.3.1 Relationship between Site Developer and WebSphere Studio -- 3.3.2 Relation between Application Developer and VisualAge for Java -- 3.4 WebSphere Studio Workbench -- 3.4.1 Overview -- 3.4.2 WebSphere Studio Site Developer -- 3.4.3 WebSphere Studio Application Developer -- 3.5 VisualAge for Java -- 3.5.1 Overview -- 3.5.2 Professional Edition V4.0 -- 3.5.3 Enterprise Edition V4.0 -- 3.6 DB2 Stored Procedure Builder -- 3.6.1 Overview -- 3.6.2 Installing and configuring.

3.6.3 Concepts and terminology -- 3.6.4 Choosing a language for your stored procedures -- 3.6.5 Creating stored procedures -- 3.6.6 Example stored procedure -- Chapter 4. WebSphere Studio Application Developer -- 4.1 Introduction -- 4.1.1 J2EE business topologies -- 4.2 Application Developer workbench fundamentals -- 4.2.1 Projects -- 4.2.2 Perspectives -- 4.2.3 Views -- 4.2.4 Editors -- 4.2.5 Team development -- 4.3 Application Development tools -- 4.3.1 Java development tools -- 4.3.2 Web development tools -- 4.3.3 Web services development -- 4.3.4 Enterprise JavaBeans (EJB) development environment -- 4.3.5 XML development environment -- 4.3.6 Relational database environment -- 4.3.7 Testing and publishing tools -- 4.3.8 Performance profiling -- 4.3.9 Debugger -- 4.4 Working with DB2 UDB -- 4.4.1 Creating a project -- 4.4.2 Connecting to databases -- 4.4.3 Importing DB designs -- 4.4.4 Creating new designs -- 4.4.5 Working with scripts -- 4.4.6 Maintaining your design -- 4.4.7 Querying databases -- Chapter 5. J2EE technical overview -- 5.1 J2EE overview -- 5.2 J2EE platform components -- 5.2.1 Containers -- 5.2.2 J2EE server -- 5.2.3 Resource driver manager -- 5.2.4 Database -- 5.2.5 J2EE standard services -- 5.3 Java Transaction Management -- 5.4 Enterprise JavaBeans -- Chapter 6. Create e-business applications -- 6.1 WebSphere programming environment -- 6.1.1 WebSphere programming model -- 6.2 WebSphere application architecture support -- 6.2.1 Web-based client/server applications -- 6.2.2 Distributed object-based applications -- 6.2.3 Web-based distributed applications -- 6.3 Content presentation -- 6.3.1 Servlets -- 6.3.2 JavaServer Pages (JSP) -- 6.4 Developing applications with VisualAge for Java -- 6.4.1 Developing servlets -- 6.4.2 Developing JSPs -- 6.4.3 Testing application using WebSphere Test Environment (WTE).

6.4.4 Deploying application -- Chapter 7. Installing and configuring IBM WebSphere -- 7.1 Planning for WebSphere Application Server -- 7.1.1 Hardware requirements -- 7.1.2 Software requirements -- 7.1.3 Hardware used in our test environment -- 7.1.4 Software used in our test environment -- 7.2 WebSphere installation -- 7.2.1 Creating an Admin ID on Windows platforms -- 7.2.2 Install IBM HTTP Server -- 7.2.3 Install database server -- 7.2.4 Post-configuration for WebSphere -- 7.2.5 Install WebSphere Application Server -- 7.2.6 Uninstall WebSphere -- 7.3 Configuring WebSphere -- 7.3.1 The administration model in WebSphere -- 7.3.2 Configuring WebSphere to host applications -- Chapter 8. Accessing DB2 UDB via WebSphere -- 8.1 Configuring DB2 for Java applications -- 8.2 JDBC providers -- 8.2.1 What is a JDBC provider -- 8.2.2 Creating a JDBC Provider resource -- 8.3 Datasources in WebSphere -- 8.3.1 What is a datasource -- 8.3.2 Creating a datasource in WebSphere -- 8.3.3 WebSphere datasource tuning -- 8.4 Connection pooling -- 8.4.1 WebSphere connection pooling implementation -- 8.4.2 WebSphere statement cache -- 8.4.3 Benefits of WebSphere connection pooling -- 8.4.4 Who should use WebSphere connection pooling -- 8.4.5 What's new In Version 4.0? -- 8.4.6 Connection pooling best practices -- 8.4.7 Connection pooling worst practices -- 8.5 Connecting enterprise data -- 8.5.1 Creating a connection to enterprise data -- 8.5.2 DB2 Connect connection pooling -- 8.5.3 DB2 Connect connection concentrator -- 8.5.4 DB2 Connect support for Java -- 8.6 DB2 Connect and WebSphere -- 8.7 WebSphere and DB2 UDB V7.2 EE clustering -- 8.7.1 Solaris 8 -- 8.7.2 AIX 4.3.3 -- 8.7.3 Microsoft Windows NT/2000 -- Chapter 9. DB2 application development extensions -- 9.1 DB2 Extenders overview -- 9.2 XML Extender -- 9.2.1 Document Type Definition (DTD) -- 9.2.2 Location path.

9.2.3 Administrative support tables, UDTs, and UDFs -- 9.2.4 DTD repository -- 9.2.5 Document Access Definitions (DAD) -- 9.2.6 XML Column method -- 9.2.7 XML collection -- 9.2.8 XML Extender administration tools -- 9.2.9 XML MQSeries enablement -- 9.3 Text Extender -- 9.3.1 Index types supported by Text Extender -- 9.3.2 Search functions supported by all indexes -- 9.3.3 Text document formats supported -- 9.3.4 Text Extender administration UDFs -- 9.3.5 Text Extender application development -- 9.4 Net Search Extender -- 9.4.1 Inverted index -- 9.4.2 Net Search Extender overall process -- 9.4.3 What gets indexed -- 9.4.4 Net Search uses in-memory tables -- 9.4.5 Net Search indexing example -- 9.4.6 Performing the search -- 9.4.7 Net Search application development -- 9.4.8 Index update considerations -- 9.4.9 Index size considerations -- 9.4.10 NetSearch benefits -- 9.4.11 When should you use other extenders -- 9.5 AIV Extenders -- 9.5.1 How the audio, video, image data are stored -- 9.5.2 Administrative support tables -- 9.5.3 Query By Image Content (QBIC) catalog for image type -- 9.5.4 Video indexes and shot catalog -- 9.5.5 Application development -- 9.6 Other tools and DB2 as a Web services extension -- 9.6.1 Net.Data -- 9.6.2 DB2 MQ enablement -- 9.6.3 DB2 as a Web services extension -- Chapter 10. Case study: IBM Video Central for e-business -- 10.1 Case study - business rationale -- 10.1.1 IBM Video Central - business scenario -- 10.1.2 IBM Video Central architecture -- 10.1.3 IBM XML and Web Services Development Environment -- 10.2 Application design -- 10.2.1 Class definitions -- 10.2.2 Database design -- 10.3 Installation and verification -- 10.3.1 Enabling the DB2 environment for IBM VideoCentral -- 10.3.2 WebSphere Studio Application Developer -- 10.3.3 Preparing the project in Application Developer -- 10.3.4 Deployment to WebSphere.

10.3.5 Deploy the Web Services into WebSphere -- 10.3.6 Creating and running a sample client -- 10.3.7 Running the sample client -- 10.3.8 Solving common problems -- Chapter 11. Problem determination -- 11.1 Basic information for problem determination -- 11.1.1 Determining the location -- 11.1.2 Determining the problem -- 11.2 DB2 tracing -- 11.2.1 db2diag.log -- 11.2.2 JDBC trace -- 11.2.3 CLI trace -- 11.2.4 db2trc -- 11.2.5 ddcstrc -- 11.2.6 Putting the traces together -- 11.3 WebSphere tracing -- 11.3.1 Log and trap files in the administration server -- 11.3.2 The stdout and stderr in the application server environment -- 11.3.3 Tracing the WebSphere administration server -- 11.3.4 Tracing a WebSphere application server -- 11.4 Difficult platform problems -- 11.4.1 DB2 and WebSphere on distributed platforms -- 11.4.2 Using DB2 on S/390 for the WebSphere repository -- Related publications -- IBM Redbooks -- Other resources -- Referenced Web sites -- How to get IBM Redbooks -- IBM Redbooks collections -- Index -- Back cover.