IBM United States
Software Announcement 202-052
March 5, 2002
DB2 for IBM iSeries Platform Extended with Enhanced Tools
(Corrected on May 14, 2002)
Changes in the following sections:
At a Glance
For ordering, contact:
Your IBM representative, an IBM Business Partner, or IBM Americas Call Centers at 800-IBM-CALL (Reference: AE001).
In September 2001, the IBM Data Management team delivered on the first phase of its multiplatform tools strategy that included DB2® Table Editor for iSeries, V4.2 and DB2 Web Query Tool for iSeries, V1.2.
The offerings are expanded further with enhanced tools for iSeries:
DB2 Table Editor for iSeries, V4.3
DB2 Table Editor lets you easily support your business processes, and empower novice end users, with customized task-specific table editing forms. Database experts get a robust set of tools to perform ad hoc table editing tasks across multiple databases and platforms. Since end users only need a browser, the solutions you choose to create with DB2 Table editor have maximum reach.
DB2 Table Editor makes it possible to provide direct DB2 database access to anyone, for creating, reviewing, or updating data. Task-specific forms restricted to specific data and actions can be quickly built and rolled out to novice end users An expert interface can be used for browsing existing databases and ad hoc actions.
A Java-enabled browser is all you need on the client machine for using DB2 Table Editor solutions.
Wizards and a drag-and-drop Windows® environment let you quickly develop table editing forms, which, like mini-applications, are suitable for a wide variety of common business tasks.
Data filtering, business and data access rules, database connections, command buttons, and dialogs are embedded directly in the forms (which can be optionally placed in existing Web pages) so end users can focus on their work instead of database technicalities.
DB2 Table Editor supports multiple DB2 database platforms, mission-critical DB2 features such as existing DB2 security and referential integrity, and advanced DB2 features like large object support. Customers who need to safely provide data editing and data entry capabilities to end users at the front lines of a business or to database administrators will find DB2 Table Editor a valuable offering.
New with V4.3
DB2 Web Query Tool for iSeries, V1.3
When any part of your business operations require faster, more creative, or more complex data operations, DB2 Web Query Tool is the authoring environment to turn to. Web Query Tool's advanced SQL functionality extracts the full performance out of DB2 databases while making it easy for users at all levels to access enterprise-wide data. Wherever data access and data integration can bring value, DB2 Web Query Tool can deliver that value.
DB2 Web Query Tools are capable of accessing DB2 data on z/OS, iSeries, AIX®, Linux, Windows, HP-UX, and Sun platforms. The products run on Web servers, which need not be on the same platforms as the database servers. For example, to access DB2 database data on iSeries, you need the DB2 Web Query Tool for iSeries. To access DB2 database data on z/OS, you need DB2 Web Query Tool for z/OS. The code for all listed Web server platforms is included as part of each DB2 Web Query Tool.
With Web Query Tool customers can:
New with V1.3
These programs are not impacted by euro currency.
Visit Web site:
Call IBM Education and Training at 800-IBM-TEACH (426-8322) for catalogs, schedules, and enrollments.
Product information is available through Offering Information (OITOOL) at:
Displayable Softcopy Documentation
For DB2® Table Editor for iSeries, V4.3: README.TXT file with information on how to install the product and the DB2 Table Editor Control Center Plug-in. On line HELP is included.
The following publications are not available in hardcopy form. They are available for download in both PDF and BookManager® formats on the Web site:
Identification Title Number Concepts and Components SC27-1644 Installation and Customizing SC27-1646 DB2 Table Editor User's Guide SC27-1616 DB2 Web Query User's Guide SC27-0971
Direct Customer Support: Direct customer support is provided by IBM Operational Support Services Support Line. This fee service enhances customers' productivity by providing voice and electronic access into the IBM support organization. IBM Support Line can help answer questions pertaining to usage and suspected software defects for eligible products.
Installation and technical support is provided by Global Services. For more information call 800-IBM-4YOU (426-4968).
Security, Auditability, and Control
The security and auditability features of User Identification and Password Management for these products are developed in concert with DB2 security.
The customer is responsible for evaluation, selection, and implementation of security features, administrative procedures, and appropriate controls in application systems and communication facilities.
Each product has a single charge unit of "Processor Group."
Basic License: To order a basic license, specify the program number and feature number 9001 for asset registration, the appropriate charge feature numbers and quantities, and the feature number of the desired distribution medium.
Processor- Based OTC(1) Feature Group Description Number Number Medium CD-ROM Medium Feature Number 5809 DB2 Table Editor for 0001 P05 iSeries V4.3 0002 P10 Program Package 0003 P20 (5697-G84) 0004 P30 0005 P40 0006 P50 Processor Group Migration P5 to P10 0007 P5 to P20 0008 P5 to P30 0009 P5 to P40 0010 P5 to P50 0011 P10 to P20 0012 P10 to P30 0013 P10 to P40 0014 P10 to P50 0015 P20 to P30 0016 P20 to P40 0017 P20 to P50 0018 P30 to P40 0019 P30 to P50 0020 P40 to P50 0021 DB2 Web Query Tool 0001 P05 for iSeries V1.3 0002 P10 Program Package 0003 P20 (5697-G85) 0004 P30 0005 P40 0006 P50 Processor Group Migration P5 to P10 0007 P5 to P20 0008 P5 to P30 0009 P5 to P40 0010 P5 to P50 0011 P10 to P20 0012 P10 to P30 0013 P10 to P40 0014 P10 to P50 0015 P20 to P30 0016 P20 to P40 0017 P20 to P50 0018 P30 to P40 0019 P30 to P50 0020 P40 to P50 0021
Feature Distribution Product Number Medium DB2 Table Editor for 5809 CD-ROM iSeries, V4.3 (5697-G84) DB2 Web Query Tool for 5809 CD-ROM iSeries, V1.3 (5697-G85)
Customization Options: Select the appropriate feature numbers to customize your order with delivery options desired. These features can be specified on the initial or MES orders.
Example: If publications are not desired for the initial order, specify feature number 3470 to ship media only. For future updates, specify feature number 3480 to ship media updates only. If, in the future, publication updates are required, order an MES to remove feature number 3480; then, the publications will ship with the next release of the program.
Feature Description Number Initial Shipments Ship media only (suppresses initial 3470 shipment of documentation) Ship documentation only (suppresses 3471 initial shipment of media) 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.
Terms and Conditions
The following agreements apply for maintenance and do not require customer signatures:
For additional information on the revised IBM Operational Support Services, refer to Services Announcement 601-023 , dated July 10, 2001.
The prices 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.
Processor- Based OTC Feature Group Description Number Number OTC DB2 Table Editor for 0001 P05 $ 700 iSeries, V4.3 0002 P10 1,000 Program Package 0003 P20 4,000 (5697-G84) 0004 P30 4,400 0005 P40 6,700 0006 P50 7,000 Processor Group Migration P5 to P10 0007 300 P5 to P20 0008 3,300 P5 to P30 0009 3,700 P5 to P40 0010 6,000 P5 to P50 0011 6,300 P10 to P20 0012 3,000 P10 to P30 0013 3,400 P10 to P40 0014 5,700 P10 to P50 0015 6,000 P20 to P30 0016 400 P20 to P40 0017 2,700 P20 to P50 0018 3,000 P30 to P40 0019 2,300 P30 to P50 0020 2,600 P40 to P50 0021 300 Processor- Based OTC Feature Group Description Number Number OTC DB2 Web Query Tool 0001 P05 $ 700 for iSeries, V1.3 0002 P10 1,000 Program Package 0003 P20 4,000 (5697-G85) 0004 P30 4,400 0005 P40 6,700 0006 P50 7,000 Processor Group Migration P5 to P10 0007 300 P5 to P20 0008 3,300 P5 to P30 0009 3,700 P5 to P40 0010 6,000 P5 to P50 0011 6,300 P10 to P20 0012 3,000 P10 to P30 0013 3,400 P10 to P40 0014 5,700 P10 to P50 0015 6,000 P20 to P30 0016 400 P20 to P40 0017 2,700 P20 to P50 0018 3,000 P30 to P40 0019 2,300 P30 to P50 0020 2,600 P40 to P50 0021 300
Customer Financing: IBM Global Financing offers attractive financing to credit-qualified commercial and government customers and Business Partners in more than 40 countries. IBM Global Financing is provided by the IBM Credit Corporation in the United States. Offerings, rates, terms, and availability may vary by country. Contact your local IBM Global Financing organization. Country organizations are listed on the Web at:
Use Priority/Reference Code: AE001 Phone: 800-IBM-CALL Fax: 800-2IBM-FAX Internet: firstname.lastname@example.org Mail: IBM Atlanta Sales Center Dept. AE001 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.