March 28, 2000
IBM DB2 Forms for OS/390 Version 2 Rapidly Build Java and Windows Front Ends to Any DB2 Database
At a Glance
Tackles your fundamental data access and update needs across your enterprise.
For ordering, contact:
DB2® Forms Version 2 represents a breakthrough in rapid development and deployment of network and Web-based applications.
Key problems that plague e-business and Web transactions are scalability, reliability, and ease of implementation. DB2 Forms Version 2 addresses all three.
You can reap benefits as you extend databases directly to the Web, the intranet, or throughout the enterprise on a closed SNA environment.
Now you can:
DB2 Forms V2 is positioned as a companion product to every DB2 database to satisfy a broad range of fundamental data access and update needs in every area of the enterprise, and as an alternative to more complex application building packages and languages that require significant training, skill sets, or infrastructure investment.
The benefits of getting up and running quickly, adherence to open standards, choice of platforms and networks upon which to run, and tight technical coupling to DB2 (through static SQL, host variables, and more) distinguish DB2 Forms Version 2.0 from any other product.
In addition, DRDA® compliance in DB2 Forms Version 2.0 and native support for DB2 DataJoiner® make DB2 Forms a strategic choice in any heterogeneous database environment.
The product is double byte character set (DBCS) ready; for example, double byte characters can be used for filename and table name handling. No language translations are provided.
Download a 60-day trial version at:
Planned Availability Date
What's New in DB2 Forms Version 2.0?
Following are several new capabilities for DB2 Forms Version 2.
DB2 Forms Advantages
Business-to-Business Customer Relationship Solutions
Sales Support Solutions
General Data Warehouse and Operational Data Solutions
The enterprise can get DB2 Forms applications such as those above up and running at maximum velocity and fully realize the benefits of ongoing iterative development. Instead of error-prone "monolithic" application planning, coding, installation, and client configuration projects with long turnaround times, developers can focus their resources on user-driven enhancements. Enhancements can be distributed instantaneously in much smaller, more rapid cycles of development and user feedback. In this key way, DB2 Forms strategically enhances the business effectiveness of application development teams, and brings an important new dimension to the centralized sharing capabilities of relational database servers.
Delivered as Four Modules
DB2 Forms Developer
A rapid development environment for creating custom forms that end users can access from virtually any environment or location. In a drag-and-drop interface, developers quickly add command buttons, labels, text boxes, and controls for containing data and "drop down" lists. Behaviors, data sources, and data validation rules are assigned to controls from easy-to-use dialogs that require no programming. Applications can be made available only to their creators, to all users, made fully visible within a Web page, or made available as a link in a Web page. The developer can specify whether a unique DB2 logon is required to access the application.
Each application presents specific data associated with it at development time, and enforces data browsing, data entry, and data update rules embedded within it. Typical applications include table editing, inventory or product catalog access, order entry, customer invoice retrieval, or query-by-example front ends.
DB2 Forms Console
Sets up DB2 servers to centrally store Java and Windows-based DB2 Forms applications for access by end users. The Console defines servers, installs DB2 Forms packages at the servers, creates the DB2 Forms catalog objects at the servers, and sets various user group permissions. DB2 Forms Console supports and relies upon your existing DB2 security.
DB2 Forms User
The Windows client run-time that provides users with access to Windows-based DB2 Forms applications, which are stored centrally at the database server. (Installation of the DB2 Forms User Module is not required when using Java-based DB2 Forms applications.) End users select and launch any number of applications from the catalog (stored at the DB2 server) without having to install any additional code on their workstations. Access can be made available to local or remote workstations, including those connecting from any location via the Internet to TCP/IP-supported DB2 databases.
DB2 Forms Java Player
Installed by the administrator to your HTTP server for serving your Java-based DB2 Forms applications to Web browsers. Can also be installed on Java-enabled workstations for running Java-based DB2 Forms applications stand-alone without a browser.
Command Buttons for Multiple Actions
Java and XML Standards Compliance
DB2 Forms Version 2 generates online applications that can be run as Java applets embedded in Web pages for access through a browser, or as stand-alone Java applications without a browser.
DB2 Forms also generates the specifications for a Java application in XML vocabulary, laying the groundwork for future integration in Web-based data interchange and leveraging of IBM's DB2 XML Extender.
Java and XML standards compliance adds universal portability to DB2 Forms applications, allowing application developers, end users, and the enterprise to:
Open Group's DRDA Compliance
This product is in compliance with Open Group's Distributed Relational Database Architecture (DRDA).
At the same time DB2 Forms Version 2 generates your Java-based applications, it can also generate Windows-based applications which can be distributed freely on demand over networks and are architecturally coupled to DB2 via the open standards of DRDA.
DRDA compliance allows you to easily transcend network, hardware, and operating system differences when connecting Windows-based DB2 Forms client applications to DB2 database servers on multiple platforms. The result is the elimination of database gateways, middleware, and ODBC drivers, while gaining more rapid setup, easier administration, and support for advanced features of DB2.
In part, DRDA compliance makes the use of multiple network types transparent, including:
This product is Year 2000 ready. When used in accordance with its associated documentation, it is capable of correctly processing, providing, and/or receiving date data within and between the twentieth and twenty-first centuries, provided that all products (for example, hardware, software, and firmware) used with the product properly exchange accurate date data with it.
DB2 Forms Version 2 is a new technology for enabling full relational database support over intranets and the Internet, including at e-commerce sites where database updates and data retrieval play a crucial role in operations. Customers desiring to establish high levels of reliability and performance in heavily trafficked Web-based storefronts and customer service sites should look to DB2 Forms to provide the following:
Long-standing DB2 customers will also appreciate support in Windows-based DB2 Forms applications for DRDA standards, which in part allows for cross-platform operability and SNA connectivity to legacy environments where intranets are not enabled.
Customers with multivendor database environments (which include databases such as VSAM, IMS, Oracle, Sybase, Microsoft SQL Server, and others) will benefit from the DB2 Forms Version 2.0 support for IBM's DB2 DataJoiner, providing access to the broadest possible set of enterprise data sources.
Hardware and Software Support Services
SmoothStart and Installation Services are not provided.
DB2 Forms on-site developer and administrator education are provided for a fee by the following IBM Business Partner:
Two Apple Hill
Natick, MA 01760
DB2® Forms implements the follow key industry standards:
For DB2 Forms application usage, workstation hardware must be able to run the Java or Windows software.
Host Environment DB2 Product OS/390(R) DB2 for OS/390 Version 5, or later VM DB2 for VM and VSE Version 6, or later AS/400(R) DB2 Universal Database(R) for AS/400 V4.3, or later AIX(R) DB2 Universal Database for AIX HP-UX DB2 Universal Database for HP-UX SCO UnixWare DB2 Universal Database for SCO UnixWare Sun Solaris DB2 Universal Database for Sun Solaris Windows DB2 Universal Database for Windows NT(TM), Windows 95, and 98
Serving Java-based DB2 Forms applications to users who wish to run them in their browsers requires an HTTP server running IBM's JDBC driver, which is in turn configured to establish a CLI connection to the local or remote DB2 databases that you wish users to access. Refer to your DB2 documentation for further details on setting up CLI connections and the DB2 JDBC driver.
Running Java-based DB2 Forms applications in a browser requires a browser that supports JVM 1.1, or later, such as current versions of Netscape or Microsoft Internet Explorer.
Running Java-based DB2 Forms applications without a browser requires a workstation that supports JVM 1.1, or later, and has a DB2 Client Application Enabler installed on it that is configured to support the DB2 database to which you wish to connect. Refer to your DB2 documentation for further details on setting up the DB2 Client Application Enabler.
DB2 Forms Windows-based application usage, building applications with the DB2 Forms Developer Module, and set up and administration with DB2 Forms Console Module each require any of the following 32-bit Windows environments:
For TCP/IP connectivity for DB2 Forms Windows-based applications, the DB2 Forms Developer module, and the DB2 Forms Console module, DB2 Forms must be able to establish a TCP connection from the Windows workstation to the remote host and remote port (the port on which DB2 is listening). This can be established with many 32-bit WinSock products, including those provided with Windows 95, Windows 98, and Windows NT.
For SNA connectivity for DB2 Forms Windows-based applications, the DB2 Forms Developer module, and the DB2 Forms Console module, DB2 Forms requires an SNA/CPI-C product on each Windows workstation. These products are the interface between DB2 Forms and the APPC verb set used by the SNA environment to manage server/requester relationships.
The following table indicates the configurations that DB2 Forms Windows-based applications, the DB2 Forms Developer module, and the DB2 Forms Console module have been tested with and support. The columns under Windows 9x and Windows NT indicate whether or not DB2 Forms works with the listed SNA product on that platform.
SNA Product Windows Windows 9X NT IBM Personal Communications 32-bit AS/400 and 3270 4.1 for Windows 95 IBM Personal Communications 32-bit AS/400 and 3270 4.1 for Windows NT eNetwork(TM) Personal 32-bit 32-bit Communications Version 4.21 for Windows 95 and Windows NT Microsoft SNA Server 2.11 or 3.0 32-bit Windows 95 Client Microsoft SNA Server 2.11 or 3.0 32-bit Windows NT Client Novell NetWare for SAA 2.2 32-bit 32-bit Wall Data Rumba 95/NT 5.0 32-bit 32-bit
Security, Auditability, and Control
The announced product uses the security and auditability features of the OS/390 operating system and the supported database servers.
The customer is responsible for evaluation, selection, and implementation of security features, administrative procedures, and appropriate controls in application systems and communication facilities.
There are no publications for this product. All required information is on the product's single CD, help text, or at:
Orders for new licenses can be placed now.
Shipment will begin on the planned availability date.
To order DB2 Forms for OS/390 specify:
Type Model 5697 G16
Entry Support License (ESL): To order an ESL license, specify the program number, feature number 9001 for asset registration, and the applicable ESL one-time charge (OTC) feature number. Also specify the feature number of the desired distribution medium.
ESL OTC Description Feature Number DB2 Forms for OS/390 Version 2 0018 (5697-G16)
ESL machines can be determined by referring to the IBM Entry End User/390 Attachment (Z125-4379).
Parallel Sysplex® License Charge (PSLC) Basic License: To order a basic license, specify the program number and feature number 9001 for asset registration. Specify the PSLC Base feature. If applicable, specify the PSLC Level A and PSLC Level B, and PSLC Level C, PSLC Level D features and quantity.
If there is more than one program copy in a Parallel Sysplex, the charge for all copies is associated to one license by specifying the applicable PSLC feature numbers and quantity represented by the sum of the Service Units in Millions (MSUs) in your Parallel Sysplex. For all other program copies, specify the PSLC No-Charge (NC) Identifier feature on the licenses.
Also, specify the feature number of the desired distribution medium.
PSLC PSLC Basic License Machine Feature MLC Feature MSU Capacity Number Description 1 0001 PSLC Base, 1 MSU 2 0002 PSLC Base, 2 MSUs 3 0003 PSLC Base, 3 MSUs 4 to 45 0004 PSLC Level A, 1 MSU 0005 PSLC Level A, 42 MSUs 46 to 175 0006 PSLC Level B, 1 MSU 0007 PSLC Level B, 10 MSUs 0008 PSLC Level B, 50 MSUs 176 to 315 0009 PSLC Level C, 1 MSU 0010 PSLC Level C, 10 MSUs 0011 PSLC Level C, 50 MSUs 316 or more 0012 PSLC Level D, 1 MSU 0013 PSLC Level D, 50 MSUs N/A 0014 PSLC NC IDENTIFIER
0003 quantity 1
0004 quantity 8
Single Version Charging: To elect single-version charging, the customer must notify and identify to IBM the prior program and replacement program and the designated machine on which the programs are operating.
Growth Opportunity License Charge (GOLC) To order a Multiprise® 3000, specify the program number, feature number 9001 for asset registration, and the GOLC monthly charge feature number from the table below. Also, specify the feature number for the desired distribution medium.
Multiprise 3000 GOLC Model Feature Number H30 0015 H50 0016 H70 0017
Feature Distribution Environment Number Medium DB2 Forms for OS/390 5809 CD-ROM
Feature Description Number Initial Shipments Serial number only (suppresses shipment 3444 of media and documentation) Satellite Electronic Delivery 3450 Update Shipments Suppress updates (suppresses update 3482 shipment of media and documentation) Expedite Shipments Local IBM office expedite 3445 (for IBM use only) Customer expedite process charge 3446 ($30 charge for each product)
Expedite shipments will be processed to receive 72-hour delivery from the time IBM Software Delivery and Fulfillment (SDF) receives the order. SDF will then ship the order via overnight air transportation.
Subsequent updates (technical newsletters or revisions between releases) to the publications shipped with the product will be distributed to the user of record for as long as a license for this software remains in effect. A separate publication order or subscription is not needed.
Terms and Conditions
Replaced Program Replacement Program Program Program Program Program Name Number Name Number DB2 Forms for 5697-F09 DB2 Forms for 5697-G16 OS/390 OS/390 Version 1 Version 2
Use Priority/Reference Code: YE001 Phone: 800-IBM-CALL Fax: 800-2IBM-FAX Internet: email@example.com Mail: IBM Atlanta Sales Center Dept. YE001 P.O. Box 2690 Atlanta, GA 30301-2690
You can also contact your local IBM Business Partner or IBM representative. To identify them, call 800-IBM-4YOU.
Note: Shipments will begin after the planned availability date.