• Personal tools
  • Log in
• • Main Page
• documentation
  • RPG-XML Suite
  • Krengel Ship for UPS
  • DB2 Web Service Enabler
  • All Products
• Toolbox
  • What links here
  • Related changes
  • Special pages

DB2WSE Installation

From Wiki

User Guide

Before Installing

Before installing DB2WSE, read the license agreement titled 'License Agreement.pdf'. By installing this software, you declare that you agree to abide by the license agreement.

Installation

To install DB2WSE, follow these steps:

1. Unzip the downloaded DB2WSE.zip file to a folder on your PC, such as C:\TEMP and extract the DB2WSE.SAVF file (Note: the file may be called DB2WSEnnn.zip, where nnn denotes a version number)
2. FTP the DB2WSE.SAVF file from your PC to the IBM i (AS/400, iSeries, System i) using the following steps:
3. Open a DOS prompt (Start -> Run -> type 'cmd' and hit Enter)
4. Type the following FTP commands into the DOS prompt and press Enter after each one (replace {ip-address}, {user-profile} and {password} with the IP address of your IBM i and a valid IBM i user profile/password which has authority to FTP).

FTP {ip-address}
{user-profile}
{password}
BINARY
LCD C:/TEMP
CD QGPL
QUOTE SITE NAMEFMT 0
PUT DB2WSE.SAVF
QUIT

Restore the DB2WSE library from the DB2WSE save file

RSTLIB SAVLIB(DB2WSE) DEV(*SAVF) SAVF(QGPL/DB2WSE)

Add the DB2WSE library to the top of your library list

ADDLIBLE LIB(DB2WSE) POSITION(*FIRST)

Run the INSTDB2WSE (Install DB2WSE) command to configure DB2WSE and create an HTTP server instance. By default, the HTTP server instance will have the same name as the DB2WSE library. The default port used for DB2WSE is 8282, but you can change this to suit your needs.

INSTDB2WSE DB2WSELIB(DB2WSE) PORT(8282) HTTPSVR(*DB2WSELIB)

Product Registration

Temporary Product Registration

When you originally downloaded DB2WSE, a temporary license key should have been created for you. This license key is a 32-character string, which should be applied using the APYKTILIC (Apply KTI License) command as follows:

APYKTILIC LICKEY(license-key)

Permanent Product Registration

You can request a permanent license key from Krengel Tech. This license key will cover this release of DB2WSE (including any fixes that become available) only. To obtain a license key, you will need to provide the serial number and model number of your IBM i and the logical partition number (LPAR) on which DB2WSE will be installed. You can obtain this information by executing the following commands from an IBM i command line:

DSPSYSVAL SYSVAL(QSRLNBR)
DSPSYSVAL SYSVAL(QMODEL)
DSPSRVAGT TYPE(*SRVREGINF)

DB2WSE is licensed to the LPAR and pricing is dependent on the processor group of the machine. For a custom quote, contact sales@krengeltech.com or 800-KRENGEL. License details can be found in the 'License Agreement.pdf' document.

Start the DB2WSE Apache HTTP Server instance by typing in the STRTCPSVR command below.

STRTCPSVR SERVER(*HTTP) HTTPSVR(DB2WSE)

Before using DB2WSE, you should read the DB2WSE Configuration page and (if you choose to use the DB2WSE Authority Model (DAM)) set up user profiles and authorities, as described below.

If you wish to create the example PETSTORE library, you should run the commands below. This will create both the PETSTORE library and the tables in it and also populate those tables with data. These tables are used in many of the examples in this user guide.

CRTLIB LIB(PETSTORE) TYPE(*TEST) TEXT('PETSTORE library for DB2WSE testing')
RUNSQLSTM SRCFILE(DB2WSE/QSQLSRC) SRCMBR(PETSTRDDL) COMMIT(*NONE) NAMING(*SYS) ERRLVL(20)
RUNSQLSTM SRCFILE(DB2WSE/QSQLSRC) SRCMBR(PETSTRPOP) COMMIT(*NONE) NAMING(*SYS) ERRLVL(20)

The following will setup a new user named DEMO using the DB2WSE Authority Model (DAM) and give DEMO authority to display data from the PETSTORE tables.

CRTDWEPRF USRNAM(DEMO) PASSWD(DEMO) PRFSTS(*ACTIVE) AUTLVL(*DFT)
CRTDWEAUT USRNAM(DEMO) TBLLIB(PETSTORE) TBLNAM(*ALL) AUTINS(*NO) AUTDLT(*NO) AUTUPD(*NO) AUTDSP(*YES)

Now you should be set to try the browser application shipped with DB2WSE which tests the data access functionality by putting a simple interface over the XML transactions. To use the browser application, point your browser at http://<ibmi>:<port> where <ibmi> should be replaced with the IP address or domain name of your IBM i and <port> should be replaced with the port number you specified in the INSTDB2WSE (Install DB2WSE) command when installing DB2WSE.