®

IBM Software Group

International Technical Support Organization

Redbook SG24-6948:
Using Informix Dynamic Server with WebSphere
Chuck Ballard
Data Management Consultant
ITSO San Jose Center
 IBM Software Group | DB2 Information Management Software

Topics

§ The Project

§ Informix Dynamic Server

§ IBM WebSphere Product Family

§ Using IDS and WebSphere

§ Related Technologies

§ Sample Applications

§ Conclusions
 IBM Software Group | DB2 Information Management Software

The First IBM Informix Redbook!

§ Covers IDS / WebSphere Topics
4 IDS 9.4 and WAS 5 (J2EE development, JSP,
Servlets, JMS, etc.)
4 IDS and WebSphere Studio
4 IDS and XML Support
4 IDS and Web Services
4 IDS and WebSphere Portal Server
4 IDS and WebSphere MQ
4 Informix 4GL and WebSphere Studio Integration
§ Lots of examples (and downloadable code)
4 Hands-on development exercises
4 Application executables - for demo purposes
§ Used Linux and Windows platforms
§ Downloads at: http://www.ibm.com/redbooks
§ Redbook ID: SG24-6948
 IBM Software Group | DB2 Information Management Software

The team that wrote the:

IDS/WebSphere Redbook

Martin Lurie (USA)

Remote Team Member

The Onsite Team: From left to right - Pagadala J. Suresh (India), Eduardo Akisue (USA),
Chuck Ballard (USA, project leader), Alexander Koerner (Germany)
 IBM Software Group | DB2 Information Management Software

Using Informix Dynamic Server and WebSphere

§ Residency
4 ITSO San Jose Center
4 Test the integration of IDS and WebSphere
§ Objectives:
4 Install, test, and configure IDS and WebSphere
4 Demonstrate integration using sample applications
4 Develop applications with WSAD that use IDS
4 Evaluate complementary products and technologies
§ WebSphere Components Used
4 WebSphere Application Server
4 WebSphere Studio Application Developer
4 WebSphere Portal Server
4 WebSphere MQ
§ Deliverables
4 Redbook SG24-6948
4 Sample Applications
4 Sample Applications Implementation Guide
4 Hints and Tips
4 Presentation
 IBM Software Group | DB2 Information Management Software

Why WebSphere?
IBM WebSphere is the leading software platform for e-business on demand

IBM WebSphere Software Advantages

§ Powerful/Robust e-Business Application Development
§ Product & Technical Leadership Across the Platform
§ Comprehensive Integration Platform
§ Reliability, Security, and Scalability
§ Open Standards & Web Services
 IBM Software Group | DB2 Information Management Software

IBM WebSphere
Optimize Software Platform
Operations
WebSphere Portal
A single point of personalized interaction with
applications, content, processes and people

WebSphere Commerce
Powerful sell- and buy-side solutions to WebSphere Business Integration
handle the challenges encountered in Software that delivers end-to-end integration
customer and trading partner environments through five proven capabilities: model,
integrate, connect, monitor and manage
WebSphere Everyplace
Software for extending e-business WebSphere MQ
applications to mobile devices Software to connect internal
and external applications to
WebSphere Voice exchange information reliably
Software for enabling natural voice and securely
interactions with applications and data

WebSphere Studio WebSphere Application Server WebSphere Host Integration

An open comprehensive development A high-performance and extremely scalable Software to leverage and extend legacy
environment for building dynamic transaction engine for dynamic e-business assets for new e-business solutions
e-business applications applications
 IBM Software Group | DB2 Information Management Software

IBM WebSphere Application Server Family

A high-performance and extremely scalable transaction engine
for dynamic e-business applications
AJ2EE certified configuration
optimized to the unique
A next generation application server that simplifies build-to- qualities of service provided
integrate tasks, accelerates application development and by z/OS
enables real-time adaptable capabilities

WebSphere Application Server

The mainstream Web WebSphere
services J2EE certified Enterprise Application
application server enabling Server for
industry leading qualities of
service and flexible z/OS
deployment options WebSphere Application Server

WebSphere Application Server - Express

An easily approachable “on-ramp” to e-business, providing fast and productive

development, deployment of dynamic web applications
 IBM Software Group | DB2 Information Management Software

The WebSphere Studio Family

WebSphere Studio
• Web site development
• Java application and web service development and integration
• Enterprise modernization and application integration

IBM eServer & Partner Tools

Middleware Tools & Middleware

WebSphere Studio

Web Java Rapid development

HTML, DHTML, XML, JSP J2EE, J2SE, J2ME Visual development Scripting
Wireless JCA Connectivity and 4GLCode and data
generation Application
Web Services Asset componentization templates
Creation, Consumption Impact analysis
Visually Compose and COBOL and PL/1
choreograph Unit Test development
Functional and Performance
 IBM Software Group | DB2 Information Management Software

IBM WebSphere Portal Family

A single point of personalized interaction with applications, content,
processes and people Portal Experience
Provides the capability for developing, deploying
Portal Extend and maintaining advanced enterprise portals
Allows your portal users
to act on information and
applications accessed by Portal Experience
collaborating with other
portal users.
Portal Extend Portal Express Plus

Portal Enable Portal Express

Portal Enable Portal - Express

Enables you to build scalable portals that Designed for Small Medium size
simplify and speed a user's access to businesses, with simple installation,
personalized information and applications affordable pricing, and function
 IBM Software Group | DB2 Information Management Software

IDS and WebSphere Studio 5 / Application Server 5

§ Rapid development, test and deployment of all Web application

server related components (e.g. EJB, JSP, HTML etc.) against IDS
§ WebSphere Application Server (WAS) 5 supports IDS for EJB
persistence
§ WAS 4.0.5 supports IDS as a configuration repository
§ Low cost entry options:
4 WebSphere Studio Site Developer (WSSD, no J2EE support)
4 WebSphere Application Server Express (no J2EE support)

§ Easy deployment from WebSphere Studio to WAS and other J2EE

servers (e.g. Apache Tomcat)
 IBM Software Group | DB2 Information Management Software

IDS and WebSphere Application Server 5 (Architecture)

 IBM Software Group | DB2 Information Management Software

Web application development with WS Studio and IDS

 IBM Software Group | DB2 Information Management Software

IDS, WebSphere Studio and XML Support

§ IDS already supports XML in different areas
4 Web DataBlade (XML generation)
4 Informix JDBC driver (JAXP support built-in)
4 Spatial DataBlade 8.20 (GML support)
4 XSLT DataBlade (on IBM Alphaworks)
4 XML generating UDRs (on IBM Informix Developer Zone)
4 Object Translator (XML mapping, existing customers)
4 Verity Text Search DataBlade (Searches in XML documents, existing
customers)

§ Much better support in combination with WebSphere Studio!

4 SQLtoXML / XMLtoSQL dynamic mapping framework
4 Complete set of XML related tools
4 Easy Web services integration
 IBM Software Group | DB2 Information Management Software

Dynamic XML Mapping with WS Studio and IDS

<?xml version="1.0" encoding="UTF-8"?>

<SQLResult xmlns="http://www.ibm.com/customer"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.ibm.com/customer
selectOneCustomer.xsd">
<customer>
<customer_num>104</customer_num>
<fname>Anthony</fname>
<lname>Higgins</lname>
<company>Play Ball!</company>
<address1>East Shopping Cntr.</address1>
<address2>422 Bay Road</address2>
<city>Redwood City</city>
<state>CA</state>
<zipcode>94026</zipcode>
<phone>415-368-1100</phone>
</customer>
</SQLResult>
 IBM Software Group | DB2 Information Management Software

IDS and Web Services Integration

§ Web Services
4 Application functions callable on the Internet
4 Exploit XML for information interchange
§ IDS as a Web Service provider
4 Use of WebSphere Studio Web Services Tools
4 Web Services based on Java beans
4 DADX Web Services (Web services based on SQL Statements and Stored Procedures)
4 Enhancements in IDS 9.40 and the JDBC 2.21.JC4 driver for Web Services support

§ IDS as a Web Service consumer

4 Utilization of the leading extensible architecture of IDS 9
4 Java or C user defined routines to access existing Web Services
4 Integration of IDS J/Foundation and the Apache AXIS framework for Web Service access!
 IBM Software Group | DB2 Information Management Software

Web Services development with WS Studio and IDS

 IBM Software Group | DB2 Information Management Software

IDS 9 as a Web service consumer: Examples

Example 2: Google Search

Example 1: Currency Exchange

 IBM Software Group | DB2 Information Management Software

IDS and WebSphere MQ

§ MQSeries Transactional Support
4 Supports the coordination of IDS 7 & 9 servers from MQSeries in an
XA environment
4 MQSeries acts as an XA transaction manager and IDS as an XA
resource manager
4 Limited platform availability: MQSeries 5.2 on Sun Solaris and HP UX,
MQSeries 5.1 on Sun Solaris Intel

§ IBM Informix MQSeries DataBlade

4 New MQ API for IDS 9, modelled after an existing DB2 MQ API
4 Allows an Informix application to easily interact with an MQ based
infrastructure
4 Additional Virtual Table Interface (VTI) support for simple SQL-/Table-
based access to MQ queues!
4 Initial version soon available via IBM Alphaworks
 IBM Software Group | DB2 Information Management Software

IBM Informix MQ DataBlade: Examples

API Example: VTI Example:
execute function insert into vtiMQ (msg) values
MQSend('AMT.SAMPLE.SERVICE', ('Hello World!');
'AMT.SAMPLE.POLICY',
'Hello Queue'); 1 row(s) inserted.

(expression)
1

1 row(s) retrieved. select msg from vtiMQ;

msg Hello World!

execute function 1 row(s) retrieved.

MQReceive('AMT.SAMPLE.SERVICE
','AMT.SAMPLE.POLICY');

(expression) Hello Queue

1 row(s) retrieved.
 IBM Software Group | DB2 Information Management Software

IDS and WebSphere Portal Server

§ Starting with version 4.2.1, Portal

Server supports IDS 9 and
Cloudscape as tier 1 databases!
§ Support includes Portal Server
repository and IDS/Cloudscape as
a portal data source
§ Requires: IDS 9.30 or later
§ Cloudscape comes bundled with
Portal Server and is the default
portal repository database
 IBM Software Group | DB2 Information Management Software

IDS High Availability and WebSphere

The Problem:
§ Most e-business applications not
only need performance and
scalibility, but maybe even more
important: high availability
§ Enterprise Java Beans store their
content (e.g. order entries,
shopping cart contents) in the
underlying database in beteween
invocations
§ Additional critical web application
server configuration data could A typical three tier WebSphere/IDS architecture

be stored in the database too

(e.g. WAS 4.0.5)!
 IBM Software Group | DB2 Information Management Software

IDS High Availability and WebSphere

The Solution:
§ The synergy of IDS High Availability Data Replication (HDR) and WebSphere
HA mechanisms
§ HDR allows an easy to setup primary/secondary database server scenario
§ HDR is a builtin, no additional cost feature in IDS 7 & 9!
§ Starting with IDS 9.4: ER and HDR co-existence

§ Informix JDBC driver supports HDR failover through connection URL

parameters:
4 INFORMIXSERVER_SECONDARY = <secondary_server>;
4 PORTNO_SECONDARY = <secondary_portnumber>;
4 IFXHOST_SECONDARY = <secondary_hostmachine>;
4 ENABLE_HDRSWITCH = true;
 IBM Software Group | DB2 Information Management Software

IBM Informix 4GL and WebSphere Studio

2005
General Availability

WebSphere
Studio, V6.x
Technology
Validation l Utilities for 4GL
2004
to EGL

Shipped Q4’02
WebSphere conversion
4GL-style
Studio, V5.1
l

l Upgrade for 4GL 4.20 4GL Language character based

and 4GL JJ4.30: Extensions New web
l displays
Enhanced connectivity application l Enhanced
to OnLine 4GL development printing support
l AIX 5.1 64-bit Platform 7.32 with EGL
support l DB2 connectivity
2003
Announced with IDS 9.4
4GL GA 03/28/2003
7.31.UC3 l Dynamic Arrays

l INT8/SERIAL8
 IBM Software Group | DB2 Information Management Software

“WebSphere 4GL” Architecture

View Controller Model

4GL
Program
EGL/Struts

IDS DB2
 IBM Software Group | DB2 Information Management Software

IDS / WebSphere product interoperability

Informix Product WebSphere Product Certified? eGA/GA

IDS 7.3/9.21/9.3 WAS v4.05 Y 2002
IDS 7.3/9.3/9.4 WAS v5.0 Y Q2 2003
IDS 7.3/9.3/9.4 WAS Express v5.0x Y Q2 2003
IDS 9.3 WebSphere Portal Enable 4.2.1 Y Q2 2003
IDS 9.3 WebSphere Portal Extended 4.2.1 Y Q2 2003
IDS 9.3/9.4 WebSphere Portal Express for Multiplatforms v5.x N Late Q3 2003
IDS 7.3/9.21 MQ 5.2 Y 2002
IDS 7.3/9.2/9.3 WebSphere Studio v5, Site Developer Y Q1 2003
IDS 7.3/9.2/9.3 WebSphere Studio v5, Application Developer Y Q1 2003
IDS 7.3/9.2/9.3 WebSphere Studio v5, Application Developer Integration Edition Y Q1 2003
IDS 7.3/9.2/9.3 WebSphere Studio v5, Enterprise Developer Y Q1 2003
 IBM Software Group | DB2 Information Management Software

Sample Applications
§ Developed with WebSphere Studio Application Developer
4 Simple SELECT using Database Web Pages
4 INSERT, UPDATE, and DELETE using Database Web Pages
4 Full application using Enterprise Java Beans and Container Managed Persistence
4 Full application using Java Message Services for a distributed environment
§ Used Informix Stores_demo database
§ Step-by-step instructions for all product installs and configurations
§ Step-by-step instructions for development and execution of the sample applications
§ Deployed on WebSphere Application Server
§ Used both Linux and Windows Operating Environments
§ Application executables available for download and demo
 IBM Software Group | DB2 Information Management Software

IDS and WebSphere: Example Application

 IBM Software Group | DB2 Information Management Software

Summary
§ IDS 9.4 is a leading high-end OLTP and extensible database
§ WebSphere is a strategic, robust application development platform
§ Very tight integration of IDS with the WebSphere family allows for easy,
integrated development and deployment.
§ Unique features in IDS, such as High Availability Data Replication (HDR) supports
highly available e-business applications
§ Informix IDS 9.4 is a Tier 1 database for all WebSphere products
§ New versions of IDS to deliver more, and more powerful, features
§ Continued improvement in IDS integration with WebSphere and DB2
§ Redbook delivers comprehensive information
§ Redbook delivers practical implementation exercises
§ Redbook validates the integration capabilities of IDS and WebSphere
 IBM Software Group | DB2 Information Management Software

Helpful Links / Info

IBM Redbooks Website
4 http://www.ibm.com/redbooks

IBM Information Management Website for Informix

4 http://www.ibm.com/software/data/informix

IBM Website for WebSphere

4 http://www.ibm.com/software/websphere

IBM Informix Dynamic Server 9.40

4 http://www-3.ibm.com/software/data/informix/ids94/

Informix Today Newsletter

4 Monthly electronic mailing
4 Sign up at http://www.ibm.com/software/data/informix/informixtoday

IIUG / IUG
4 http://www.iiug.org