Software Announcement 299-056
March 2, 1999

Rapidly Create e-business Applications with DB2 Forms for OS/390

 ENUS299-056.PDF (33KB)


At a Glance

DB2 Forms 1.0 — global connections using multiple platforms and technologies that:

  • Create applications that set new standards for performance
  • Build GUIs to:
    • Any DB2 data warehouse
    • DB2 operational data
  • Satisfy universal requirements:
    • Transactions
    • Table editing
    • QBE
    • Data entry
  • Slash development time
  • Store, update, and serve applications to all users from a single database location, even over the Internet

For ordering, contact:

Your IBM representative, an IBM Business Partner, or IBM Americas Call Centers at 800-IBM-CALL (Reference: YE001).

EXTRA! EXTRA! . . .

Subscribe to IBM iSource, your electronic source for customized IBM information! Go to our Web site at http://www.ibm.com/isource or send an e-mail to info@isource.ibm.com with the word SUBSCRIBE in the body.

Overview

DB2® Forms Version 1.0 is a first-generation application development tool that enables friction-free distribution of high-performance solutions on the open architecture of DB2.

Using any DB2 host or workstation server, DB2 Forms 1.0 applications can be created by developers, governed by administrators, and run by end users on any Windows™ platform, including:

  • Windows 95
  • Windows 98
  • Windows NT® 3.51, or later

DB2 Forms 1.0 is easy to set up and requires no database gateways, middleware, or ODBC drivers. Users can also build advanced database techniques and commands with little or no programming or SQL knowledge.

Open Group's Distributed Relational Database Architecture™ (DRDA®) Compliance

Connect, using your network topology, between:

  • DB2 Forms applications
  • Multiple DB2 database platforms

Networks include:

  • Publicly accessible Internet connections
  • Dedicated dial-up lines
  • TCP/IP intranets
  • Closed SNA environments

Centralized management and "Web-ready" server-based licensing yield advantages in:

  • Ease of use
  • Unlimited distribution
  • Maximum centralized control

Distribute finished applications freely like a browser to in-house or remote users. DRDA support also allows inclusion of multivendor databases (including IMS™, VSAM, Oracle, and Microsoft™ SQL Server) via the multidatabase gateway DB2 DataJoiner®.

DB2 Forms binds users and their applications to OS/390® DB2 databases (DB2 databases on OS/390).

Building upon the success of IBM's DBEdit enterprise application development tool, DB2 Forms dramatically extends DBEdit's capabilities beyond legacy user environments to Windows desktops and remote users.

Download a 60-day trial version at:

Key Prerequisites

  • Minimum 10 MB of free disk space on each Windows workstation
  • The host hardware must be able to run DB2 for OS/390

Planned Availability Date

March 5, 1999

Description

DB2 Forms Advantages

  • Global Internet or intranet connectivity to mainframe or workstation databases
  • Full range of DB2 SQL command executions
  • Scale to any size user base
  • Native support for DRDA (the open architecture of DB2)
  • TCP/IP brings:
    • Outstanding application performance and reliability
    • Independence from database gateways, middleware, or ODBC
  • Friction-free distribution of high-performance solutions on the open architecture of DB2

Application Possibilities

Business-to-Business Customer Relationship Solutions

  • Product catalog applications
  • Online ordering
  • Order status and transport tracking
  • Customer support databases
  • Supply chain management

Sales Support Solutions

  • Customer and contact management
  • Account status tracking
  • Sales campaign targeting
  • Direct online pricing, availability and inventory reservation
  • Order entry automation
  • Mobile office support

General Data Warehouse and Operational Data Solutions

  • Corporate-wide QBE applications (for example, corporate phone book)
  • Table editing
  • Data entry
  • Data validation
  • Test data creation

Delivered in Three Modules

DB2 Forms Developer: Is a rapid development environment for creating custom forms for distribution to end users. 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 available to specific groups or to all users.

DB2 Forms User: Provides users with access to finished DB2 Forms applications, which are stored centrally at the database server. End users select and launch applications from the catalog. 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. Access is available to local or remote locations, including users connecting from any location via the Internet to TCP/IP-supported DB2 databases.

DB2 Forms Console: Sets up DB2 servers to serve DB2 Forms applications to users. This includes defining servers and installing DB2 Forms packages at the servers. DB2 Forms Console supports and relies upon your existing DB2 security.

Advanced Database Protection and Performance Features: DB2 Forms provides advanced database application capabilities traditionally found only in closed host-based systems. Execution of DB2-specific SQL, direct attachment to the DB2 catalog of tables and columns, and centralized administration all combine to maximize availability and control simultaneously.

Drag-and-Drop for Rapid Application Development: Developers can quickly construct new applications, often in just minutes. Applications can be centrally stored for user access at the database server, and periodically updated and improved at will. DB2 Forms enables the DB2 database server to become the DB2 Forms application server with minimal overhead.

DB2 Forms users can run unlimited numbers of new applications:

  • Without installing additional software on their PCs
  • Immediately after they are created
  • To update the applications

The enterprise can get up and running at maximum velocity and to 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 that are instantaneously distributed 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.

Without any programming knowledge, developers can drag-and-drop to create forms containing a variety of controls able to perform commonly required tasks, such as:

Command Buttons: Multiple actions including clear, close, delete and exit

Data Controls

  • Validation rule and formatting choices, including valid integers, range constrains, and input format (for example, currency, phone number)
  • Action choices including insert, update, and replace

Form Layout: Including labels, text boxes, images, and colors

Year 2000

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.

Product Positioning

DB2 Forms 1.0 allows DB2 customers to quickly produce end-user "front ends" to DB2. The front ends may be for local remote, in-house, or business-to-business uses. Native support for any DRDA application server makes DB2 Forms 1.0 ideal for virtually any DB2 database environment, including S/390® and DB2 UDB workstation databases, and those supporting either SNA or TCP/IP connectivity.

DB2 Forms' key advantages over and above other approaches to DB2 database application development include:

  • A native capacity to connect to multiple DB2 database platforms at will even over the internet (for example, OS/390, VM, VSE, AIX®, and Windows NT) without configuration of database gateways, middleware, or ODBC drivers
  • Direct support for enterprise database features (such as DB2 security, and workload balancing in DB2 Version 6) demanded by administrators of large environments
  • Convenient centralized administration
  • Native support for DataJoiner's DRDA application server, enabling robust support for heterogeneous environments that include non-DB2 databases, such as IMS, VSAM, Oracle, Sybase, Microsoft SQL Server, and more

Current DBEdit customers will want DB2 Forms 1.0 for:

  • Year 2000 compliance
  • Ease of use
  • Ability to quickly replicate existing DBEdit applications

DB2 Forms is designed to support DBEdit customers in their migration plans for the twenty-first century, including to multiple DB2 database platforms.

Hardware and Software Support Services

SmoothStart™/Installation 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:


    Rocket Software, Inc.
    One Innovation Drive
    Natick, MA 01760
    508-655-7677

Trademarks

 
Distributed Relational Database Architecture, IMS, and SmoothStart are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
DB2, DRDA, DataJoiner, OS/390, S/390, and AIX are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Windows and Microsoft are trademarks of Microsoft Corporation.
 
Windows NT is a registered trademark of Microsoft Corporation.
 
Other company, product, and service names may be trademarks or service marks of others.

Open Enterprise

DB2® Forms implements the follow key industry standards

  • Open Group's Distributed Relational Database Architecture™ (DRDA®) is used to communicate with the DB2 family of relational databases.
  • The TCP/IP and SNA Network communication protocols are supported by DB2 Forms. The DRDA Application Requester (AR) and DRDA Application Server (AS) functionality can now be implemented using these standard protocols.
  • SQL 92 Entry Level: DB2 Forms is compliant with this level of SQL.

Technical Information

Specified Operating Environment

Hardware Requirements: Host hardware must be able to run DB2 for OS/390®.

Workstation hardware must be able to run the Windows™ software, as described in the Software Requirements section.

Software Requirements: Host software requirements are those required to run DB2 for OS/390.

DB2 Forms for OS/390 is 32-bit and runs on:

  • Windows 95
  • Windows 98
  • Windows NT®

Access to DB2 Universal Database® (UDB) Personal Edition is not supported.

DB2 Forms may connect to DB2 for OS/390 Version 5 (or later) via native TCP/IP, or to the SNA environments of that or other DB2 versions.

For TCP/IP connectivity, 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, 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 has been tested with and supports. The columns under Windows 9x and Windows NT indicate whether or not DB2 Forms works with the listed SNA product on that platform.

                                            Windows     Windows
SNA Product                                    9x          NT
 
IBM Personal Communications                  32-bit
  AS/400(R) 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(TM) 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

Planning Information

Packaging: DB2 Forms is shipped on one CD-ROM.

Security, Auditability, and Control

The announced program 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.

Ordering Information

New Licensees

Orders for new licenses can be placed now.

Shipment will begin on the planned availability date.

When ordering, specify DB2 Forms for OS/390:

                    Type           Model
 
                    5697           F09

Basic License: Specify the feature number of the desired distribution medium shown below.

Entry Support License (ESL): To order an ESL license, specify DB2 Forms for OS/390 (5697-F09), feature number 9001 for asset registration, and ESL OTC feature number 1012. Also specify the feature number of the desired distribution medium.

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 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                   1000           PSLC Base, 1 MSU
2                   1001           PSLC Base, 2 MSUs
 
3                   1002           PSLC Base, 3 MSUs
 
4 to 45             1003           PSLC Level A, 1 MSU
                    1004           PSLC Level A, 42 MSUs
 
46 to 175           1005           PSLC Level B, 1 MSU
                    1006           PSLC Level B, 10 MSUs
                    1007           PSLC Level B, 50 MSUs
 
176 or more         1008           PSLC Level C, 1 MSU
                    1009           PSLC Level C, 10 MSUs
                    1010           PSLC Level C, 50 MSUs
 
NA                  1011           PSLC NC Identifier
*
Monthly License Charge

Example 1: For a single machine with 11 MSUs, the PSLC features would be:

  • 1002 — quantity 1
  • 1003 — quantity 8

Example 2: For two machines in a Parallel Sysplex, which have an aggregation of 60 MSUs, the PSLC features would be:

  • PSLC chargeable license #1:
    • 1002 — quantity 1
    • 1004 — quantity 1
    • 1005 — quantity 5
    • 1006 — quantity 1
  • PSLC no-charge license #2: 1011 — quantity 1

Version-to-Version Upgrade Credit: To upgrade from a prior program acquired for a one-time charge (OTC) to a replacement program using a version-to-version upgrade credit, the customer must notify and identify to IBM the applicable prior program and replacement program participating in the upgrade credit.

Basic Machine-Readable Material: To order, select the feature number of the desired distribution medium:

                                        Feature        Distribution
Environment                             Number         Medium
 
DB2 Forms for OS/390                    5809           CD-ROM

Customization Options: The customization options apply only to expedited shipments. Select the appropriate feature number if expedited shipment is desired.

If expedited shipment is desired specify feature number 3446.

Initial Shipments: There are no customization features for Initial Shipments.

Update Shipments: There are no customization features for Update Shipments.

Expedite Shipments

                                                          Feature
Description                                               Number
 
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 Solutions (SDS) receives the order. SDS will then ship the order via overnight air transportation.

Unlicensed Documentation: No publications are shipped with the announced product. All documentation supporting the product is included as help text on the product's CD-ROM.

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

Licensing: IBM Customer Agreement

Variable Charges Apply: No

Indexed Monthly License Charge (IMLC) Applies: No

Installation License or Location License Applies: No

Usage Restriction Applies: No

Educational Allowance: Yes, to qualified education customers.

Volume Discount: Not applicable

Version-to-Version Upgrade Credits Apply: Yes

Replaced Programs: DB2 Forms for OS/390 (5697-F09)

Replacement Programs: To a follow-on, if any

Single Version Charging Applies: Not applicable

Warranted: Yes

Licensed Program Materials Availability

  • Restricted Materials of IBM: None
  • Non-Restricted Source Materials: None
  • Object Code Only (OCO): All

Testing Period: Two months (basic license only)

Program Services

  • Support Center applies: yes; access available through the IBM Support Center
  • Available until discontinued: 12-months written notice
  • APAR Mailing Address:

      IBM Corporation
      555 Bailey Ave.
      San Jose, CA 95141

Support Line: S/390®

Charges

The charges provided in this announcement are suggested retail prices for the U.S. only and are provided for your information only. Dealer prices may vary, and prices may also vary by country. Prices are subject to change without notice. For additional information and current prices, contact your local IBM representative.

Description                                                 OTC*
 
DB2 Forms for OS/390                                        $540
*
One-time charge

                                           MSU              Basic
Description                              Capacity           MLC
 
PSLC Base, 1 MSU                            1               $  300
PSLC Base, 2 MSUs                           2                  575
 
PSLC Base, 3 MSUs                           3                  905
 
PSLC Level A, 1 MSU                      4 to 45                41
PSLC Level A, 42 MSUs                                        1,722
 
PSLC Level B, 1 MSU                     46 to 175               17
PSLC Level B, 10 MSUs                                          170
PSLC Level B, 50 MSUs                                          850
 
PSLC Level C, 1 MSU                    176 or more              13
PSLC Level C, 10 MSUs                                          130
PSLC Level C, 50 MSUs                                          650

ESL OTC: An OTC authorizes use only on IBM Entry End User/390 Machines.

Call Now to Order

To order, contact the IBM Americas Call Centers, your local IBM representative, or your IBM Business Partner.

IBM Americas Call Centers, our national direct marketing organization, can add your name to the mailing list for catalogs of IBM products.

 Phone:     800-IBM-CALL
 Fax:       800-2IBM-FAX
 Internet:  ibm_direct@vnet.ibm.com
 Mail:      IBM Americas Call Centers
            Dept. YE001
            P.O. Box 2690
            Atlanta, GA  30301-2690
 Reference: YE001

To identify your local IBM Business Partner or IBM representative, call 800-IBM-4YOU.

Note: Shipments will begin after the planned availability date.

Trademarks

 
Distributed Relational Database Architecture and eNetwork are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
DB2, DRDA, OS/390, DB2 Universal Database, AS/400, Parallel Sysplex, and S/390 are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Windows and Microsoft are trademarks of Microsoft Corporation.
 
Windows NT is a registered trademark of Microsoft Corporation.
 
Other company, product, and service names may be trademarks or service marks of others.