DB2 Gateway Program for OS/2 Warp

This file contains information about the DB2 Gateway feature for IBM's Internet Connection Server 
for OS/2 Warp.  This feature is also known as the DB2 WWW Connection for OS/2.

Installation Information
--------------------- 

After installation, the following directories will be created in the
DB2 WWW Connection installation directory (default is c:\db2www):

        doc\                   Documentation and the readme file
        macro\                DB2 WWW Macro files
        db2v1\                Extra copies of the executable and bind file for
                                   DB2/2 Version 1.2
        db2v2\                Extra copies of the executable and bind file for
                                   DB2/2 Version 2.1
        tools\                 Command files to switch support for different
                                   DB2/2 versions
        db2data\             Sample database import files
        icons\                 DB2 WWW icons for the desktop
        nls\                    National Language Support DLL and catalog files

In addition, the following files will be installed into the appropriate
Web Server directories where <cgi-bin> is the directory
where your Web Server CGI executable programs are stored (e.g. c:\www\cgi-bin),
<html> is the document root directory where HTML source files are stored
(e.g. c:\www\html), and <icons> is the directory where images that are used
in HTML files are stored (e.g. c:\www\icons):

 <cgi-bin>\db2www.exe   Executable program from db2v2 directory
 <cgi-bin>\db2sql.bnd       Database bind file from db2v2 directory
 <html>\db2www.ini         DB2 WWW initialization file
 <html>\*.htm                 DB2 WWW HTML files
 <icons>\*.gif                  Image files used by the above HTML files
 <html>\tmplobs              Directory to store temporary LOBS from queries

Note: Some of the above files will only be installed if you select the
corresponding component during installation.  Further, they may reside in
different directories, depending on your specification during the installation.

Configuration Information
-----------------------

Configuration information for DB2 WWW Connection is in the file
'db2www.ini', which resides in the Web Server's document root directory
(e.g. c:\www\html).  Inside the file, there are two entries:

        MACRO_PATH -specifies where the directory for the macro files are
        BINDFILE   -specifies the location of the bind file for DB2 WWW

This file can be configured remotely by pointing your browser to:
        http://yourhostname/admin-bin/db2in.

The IBM Internet Connection server protects the admin-bin directory, a
User name and Password are required.  The default User name is WEBADMIN.
The default Password is WEBIBM.

Before Running DB2 WWW Connection
-----------------------------------

     1. Make sure that your Web Server is up and running.
     2. Make sure that the OS/2 environment variable DB2INSTANCE is set
        appropriately.  See your DB2/2 documentation for details.
     3. Make sure that DB2/2 Database Manager is running.

Authentication
--------------

DB2 WWW Connection macro variables LOGIN and PASSWORD are only
supported if DB2 WWW Connection is configured for DB2/2 Version 2.1,
since only this DB2/2 version supports connections using LOGIN and PASSWORD.

DB2 WWW Connection Sample Application
-------------------------------------

If you selected the "Sample Application" component during installation,
double click on the "Install Demo" icon in the DB2 WWW Connection folder on
your OS/2 desktop to install the sample database for your version of DB2/2.

To run the sample application, make sure your Web Server is started.
Then, open the URL: http://<your machine>/celdemo.htm with your Web Browser.

For users installing the sample application on a DBCS server machine, add
'MODIFIED BY FORCEIN' to each IMPORT command in the command file,
'setdemo.cmd'.  This file is located in the <db2www base directory>\db2data
directory.  This modifier directs DB2/2 to accept the data with no code page
conversion.  In addition, see the "DB2 WWW Connection User's Guide" for the
proper setting of the CONVERT_CODE_PAGE macro variable.

Using DB2 WWW Connection with Different DB2/2 Versions
------------------------------------------------------

DB2 WWW Connection defaults to supporting DB2/2 Version 2.1 during
installation.  If you plan to use DB2/2 Version 2.1 or later, you
do not need to do anything to support this environment.  If you plan to
use DB2/2 Version 1.2, you must reconfigure DB2 WWW Connection's DB2/2 support.

To reconfigure DB2 WWW Connection's DB2/2 support, use the utilities in the
<db2www base directory>\tools subdirectory.  Run upd2w2v1.cmd to support
DB2/2 Version 1.2, or run upd2w2v2.cmd to support DB2/2 Version 2.1 or later.

Macro Template
--------------

A template macro file (template.d2w) is provided in the macro directory
to help you get started writing your own macro files.

Miscellaneous
-------------

If you use the BLOB and CLOB features of DB2 WWW, be sure to periodically
remove old temporary files in <Web Server document root>\tmplobs directory.

If you want to display messages in languages other than English, install the
NLS package component and set the OS/2 environment variable LANG to the
appropriate value.  The DB2 WWW Connection NLS package supports the following
languages:

        Brazilian Portuguese, English, French, German, Italian, Japanese,
        Korean, Simplified Chinese, Spanish, and Traditional Chinese

Since the file 'db2www.ini' is viewable by other people using
a Web Browser, we recommend that appropriate access restrictions
on that file be enforced using the access control protocol provided by
the IBM Internet Connection server.
