IBM File Export simplifies your highly selective data copying needs

IBM United States Software Announcement 204-288
November 30, 2004

 

 ENUS204-288.PDF (47KB)

Table of contents   Document options  
TOC link At a glance TOC link Publications
TOC link Overview TOC link Technical information
TOC link Key prerequisites TOC link Ordering information
TOC link Planned availability date TOC link Terms and conditions
TOC link Description TOC link Prices
TOC link Product positioning TOC link Order now
TOC link Offering Information  
 
Printable version Printable version

 
At a glance

File Export for z/OS is a powerful tool that provides flexible methods of importing and exporting related sets of DB2, IMS, VSAM, and sequential data.

File Export for z/OS:

  • Can generate test data on demand
  • Supports Interactive System Productivity Facility (ISPF) and offline (batch) interfaces

For ordering, contact:

Your IBM representative, an IBM Business Partner, or IBM Americas Call Centers at 800-IBM-CALL (Reference: LE001).
 
Back topBack to top
 

Overview

IBM File Export for z/OS® offers a flexible solution to exporting and importing related sets of enterprise data. The product includes the following features:

  • Copies all data in a related set of objects or a slice of data across a related set of objects
  • Supports DB2®, IMS™, VSAM, and sequential data in one product
  • Provides for one-to-one data creation, one-to-many, and many-to-one data creation
  • Provides support for parent-child relationships defined using IBM File Export
  • Includes highly flexible data selection and reformatting rules
  • Gives the user the option to protect sensitive data on a field-by-field basis
  • Supports altering data content while copying, including the ability to age date-related data

 
Back topBack to top
 
Key prerequisites

For details, refer to the Software requirements and Hardware requirements sections.
 
Back topBack to top
 

Planned availability date

December 3, 2004
 
Back topBack to top
 

Description

IBM File Export for z/OS exports and copies data for application development and testing. The ISPF interface extracts "referentially intact" sets of data, or individual tables or rows, for copying to other systems.

With File Export for z/OS, a user can:

  • Copy selected source data quickly to test environments for faster development and testing
  • Use DB2, IMS, VSAM, and sequential data sources and targets
  • Process relationships between tables defined using IBM File Export
  • Exploit parent/child relationships

Current enterprise applications (such as Enterprise Resource Planning, Customer Relationship Management, and e-commerce) rely upon highly structured database environments with complex data relationships. These offer optimal performance, but can also present significant challenges to the developer or database administrator supporting, modifying, or designing these or entirely new applications.

File Export's robust support for highly selective data copying helps cut through the complexity normally associated with surgical problem resolution, populating test environments, or migrating applications to new or additional environments.

File Export allows you to:

  • Define application relationships between dissimilar file types
  • Delete rows from target DB2 tables based on keys extracted from a DB2, IMS, VSAM, or sequential object
  • Protect sensitive data
  • Translate data
  • Age data while copying
  • Create restructured databases and files for testing
  • Alter test data format and content

This product is provided in U.S. English only.

Section 508 of the U.S. Rehabilitation Act

File Export is capable as of December 3, 2004, when used in accordance with IBM-associated documentation, of satisfying the applicable requirements of Section 508 of the Rehabilitation Act, provided that any assistive technology used with the product properly interoperates with it.

Value Unit-based pricing

Value Unit pricing for eligible IBM eServer zSeries® IPLA programs enables a lower cost of incremental growth and enterprise aggregation. Each zSeries IPLA product with Value Unit pricing has a single price per Value Unit and a conversion matrix, called Value Unit Exhibit, for converting from some designated measurement to Value Units. Most commonly, Millions of Service Units (MSUs) is the measurement designated by IBM to be converted to Value Units. Some other measurements are engines or messages. Because MSUs are the most common measurement, that measurement will be used for the remainder of this description.

Value Unit pricing offers price benefits for customers. For each zSeries IPLA program with Value Unit pricing, the quantity of that program needed to satisfy applicable IBM terms and conditions is referred to as the "required license capacity." Each of the various Value Unit Exhibits stipulate that the larger your required license capacity, the fewer Value Units per MSU you will need. Value Unit Exhibits are uniquely identified by a three-digit code and referred to using the nomenclature VUExxx, where xxx is the three-digit code.

Subsequent acquisitions of Value Unit-priced programs offers additional price benefits for customers. The quantity of each zSeries IPLA program that you have acquired is referred to as "entitled license capacity." If you wish to grow your entitled license capacity for a zSeries IPLA program, the calculation to determine additional needed Value Units is based upon the number of Value Units already acquired.

For each zSeries IPLA program with Value Unit Pricing, you should:

  • Determine the required license capacity, in MSUs
  • Aggregate the MSUs across the enterprise
  • Convert the total MSUs to Value Units, using the applicable Value Unit Exhibit
  • Multiply the price per Value Unit by the total number of Value Units to determine the total cost

To simplify conversion from the designated measurement to Value Units or vice-versa, use the Value Unit Converter Tool. For additional information or to obtain a copy of the Value Unit Converter Tool, visit the Value Unit Converter Tool Web site

Note that Value Units of a given product cannot be exchanged, interchanged, or aggregated with Value Units of another product.

To determine the required license capacity for the zSeries IPLA program you selected, refer to the Terms and conditions section.

IPLA and Subscription and Support considerations

IPLA licenses can be transferred from one machine to another within, but not limited to, an enterprise. The customer may aggregate the capacity for all the processors the product is operated on to achieve a more economic price. This will result in a single Proof of Entitlement. It is the customer's responsibility to manage the distribution of Value Units within the limits of the entitlement of the product license.

Subscription and Support must cover the same capacity as the product license entitlement. Subscription and Support will be available in the country in which the agreement is made.
 
Back topBack to top
 

Product positioning

File Export for z/OS complements other IBM application development problem determination tools, particularly File Manager for z/OS. File Manager provides both application and system programmers the capability to access, view, edit, find, modify, copy, maintain, repair, migrate, print, and manage data and files. File Export adds flexible methods of exporting and importing related sets of DB2, IMS, VSAM and sequential data.

Trademarks

 
IMS is a trademark of International Business Machines Corporation in the United States or other countries or both.
 
z/OS, DB2, the e-business logo, and zSeries are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Other company, product, and service names may be trademarks or service marks of others.

 
Back topBack to top
 
Offering Information

Product information is available via the Offering Information Web site


 
Back topBack to top
 
Publications

For details on publications shipped with this product, refer to the Packaging section.

Softcopy publications for File Export for z/OS®: The following publications can be ordered from the IBM Publications Center at

                                                  Form
Title                                             number
 
IBM File Export for z/OS -- User's Guide          SC18-9178
IBM File Export for z/OS Reference Manual         SC31-6870
IBM File Export for z/OS Messages and             SC31-6871
 Codes

 
Back topBack to top
 
Technical information

Hardware requirements

An IBM z/Series server capable of running the required software

Software requirements

  • z/OS V1.4, or later
  • XML Toolkit V1.6.0

For IMS™ support:

  • IMS Database Manager V7.1, V8.1, or V9.1

If using IMS Fast Path features, IMS Fast Path Basic Tools V1.2, or later, is needed to process DEDB databases using Unload data sets.

For DB2® support:

  • DB2 Utilities Suite for z/OS and S/390®
  • DB2 for z/OS, V6, V7, or V8 running in compatibility mode

Limitations: There is no DBCS support.

Planning information

Direct customer support: Direct customer support is provided by IBM Operational Support Services — SoftwareXcel. This fee service enhances customers' productivity by providing voice and electronic access into the IBM support organization. IBM Operational Support Services — SoftwareXcel will 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).

For technical support or assistance, contact your IBM representative or visit

Packaging: The File Export for z/OS (5697-I12) V1 package is distributed with the following contents:

  • Basic machine-readable material on the customer-selected distribution medium (tape or cartridge). This also contains the softcopy publications.
  • Memorandum to Users (GC18-7710-00)
  • Program Directory (GI10-8527-00)
  • Proof of Entitlement (PoE)
  • IBM International Program License Agreement (IPLA) (Z125-3301)
  • IBM IPLA Pointer Sheet
  • License Information (GC18-7709-00)

Security, auditability, and control

File Export uses the security and auditability features of the z/OS operating system. The customer is responsible for evaluation, selection, and implementation of security features, administrative procedures, and appropriate controls in application systems and communication facilities.
 
Back topBack to top
 

Ordering information

The product in this announcement has one charge unit. The charge unit is Value Unit.

The program in this announcement has Value Unit-based pricing.

Program                              Value Unit
number      Program name             exhibit
 
5697-I12    File Export for z/OS     VUE007

For each zSeries® IPLA program with Value Unit pricing, the quantity of that program needed to satisfy applicable IBM terms and conditions is referred to as the required license capacity and is based on:

  • zSeries IPLA program you select
  • Applicable Value Unit exhibit
  • Applicable terms
  • Whether your current mainframes are full capacity or sub-capacity

Value Unit exhibit VUE007

              MSUs      MSUs
            minimum   maximum   Value Units/MSU
 
Base           1         3           1
Tier A         4        45           0.45
Tier B        46       175           0.36
Tier C       176       315           0.27
Tier D       316         +           0.2

Value Units for mainframes without MSU ratings:

 
Hardware    Value Units/Machine
 
MP3000 H30            6
MP3000 H50            8
MP3000 H70           12
ESL models            2

Ordering example: The total number of Value Units is calculated according to the following example.

If your required license capacity is 1,500 MSUs for your selected zSeries IPLA product, the applicable Value Units would be:

         Translation from MSUs to Value Units
 
            MSUs    *  Value Units/MSU  = Value Units
 
Base          3     *      1.00         =      3.00
Tier A       42     *       .45         =     18.90
Tier B      130     *       .36         =     46.80
Tier C      140     *       .27         =     37.80
Tier D    1,185     *       .20         =    237.00
 
Total     1,500                              343.50

When calculating the total number of Value Units, the sum is to be rounded up to the next integer.

Ordering z/OS through the Internet

ShopzSeries provides an easy way to plan and order your z/OS ServerPac or CBPDO. It will analyze your current installation, determine the correct product migration, and present your new configuration based on z/OS. Additional products can also be added to your order (including determination of whether all product requisites are satisfied). ShopzSeries is available in the U.S. and several countries in Europe. In countries where ShopzSeries is not available yet, contact your IBM representative (or IBM Business Partner) to handle your order via the traditional IBM ordering process. For more details and availability, visit the ShopzSeries Web site at

Basic license: On/Off Capacity on Demand (On/Off CoD)

File Export for z/OS is eligible for On/Off CoD with a temporary use charge calculated based on MSUs-per day usage.

Entitlement                                  License option/
identifier          Description              pricing metric
 
Program name:  File Export for z/OS
Program PID 5697-I12
 
S0108ZK             File Export for z/OS     Basic OTC, Per
                                              MSU-day TUC

Translation from MSUs to Value Units

              MSUs       Value Units/MSU
 
   Base       1-3             1
   Tier A     4-45            0.45
   Tier B     46-175          0.36
   Tier C     176-315         0.27
   Tier D     316+            0.20

To order, specify the program product number and the appropriate license or charge option. Also, specify the desired distribution medium. To suppress shipment of media, select the license-only option in CFSW.

Entitlement                                  License option/
identifier          Description              pricing metric
 
Program name: File Export for z/OS
Program PID 5697-I12
 
S0108ZK             File Export for z/OS     Basic OTC,
                                              Value Units
 
Orderable                                    Distribution
supply ID:          Language                 medium
 
S0108ZL             English                  3480 Tape Cartridge

Subscription and Support PID 5697-I13

Entitlement                                  License option/
identifier          Description              pricing metric
 
S010X8D             File Export for z/OS     Basic ALC
                                              Value Units SW
                                             Basic MLC
                                              Value Units SW
                                              (EMEA only)
                                             No Charge, Decline
 
Orderable                                    Distribution
supply ID:          Language                 medium
 
S0108ZH             English                  Paper

Subscription and support: To receive voice technical support via telephone during normal business hours and future releases and versions at no additional charge, Subscription and Support must be ordered. The capacity of Subscription and Support (Value Units) must be the same as the capacity ordered for the product licenses.

To order, specify the Subscription and Support program number (PID) referenced previously and the appropriate license or charge option.

IBM is also providing Subscription and Support for these products via a separately purchased offering under the terms of the IBM International Agreement for Acquisition of Support (IAAS). This offering:

  • Includes and extends the support services provided in the base support to include technical support via telephone during normal business hours.
  • Entitles customers to future releases and versions at no additional charge. Note that the customer is not entitled to new products.

When Subscription and Support is ordered, the charges will renew automatically annually unless cancelled by the customer.

Single version charging: To elect single-version charging, the customer must notify and identify to IBM the prior program and replacement program and the machine the programs are operating on.

Customized offerings

Product media is shipped only via customized offerings (for example, CBPDO, ServerPac, and SystemPac®). Noncustomized items (CDs, diskettes, source media, and media kits) will continue to be shipped via the stand-alone product.
 
Back topBack to top
 

Terms and conditions

Licensing: IBM International Program License Agreement (IPLA). Proofs of Entitlement (PoE) are required for all authorized use.

These products are licensed under the IPLA, and the associated Agreement for Acquisition of Support, and the Addendum for Support (Z125-6312) which provides for support with ongoing access to releases and versions of the program. These programs have a one-time license charge for use of the program and an ongoing recurring charge for the enhanced support that includes telephone assistance (voice support for defects during normal business hours) as well as access to updates, releases, and versions of the program as long as support is in effect. S/390 and zSeries IBM Operational Support Services, Support Line is an option for those customers who desire added services.

Limited warranty applies: Yes

Warranty: This program has warranty for a minimum of one year from acquisition from IBM or authorized IBM Business Partner. The warranty provided to the customer, for at least one year from acquisition, is access to databases (read Web sites) for program information and FAQs, including any known fixes to defects, which the customer can download or obtain otherwise and install at leisure.

Program support: Enhanced support, called Subscription and Support, includes telephone assistance (voice support for defects during normal business hours) as well as access to updates, releases, and versions of the program as long as support is in effect. The customer will be notified of discontinuance of support with 12 months' notice.

Money-back guarantee: If for any reason you are dissatisfied with the program, return it within 30 days from the invoice date to the party (either IBM or its reseller) from whom you acquired it, for a refund. This applies only to your first acquisition of the program.

Copy and use on home/portable computer: No

Volume orders (IVO): No

Passport Advantage® applies: No

Software Maintenance applies: No

For operating system software, the revised IBM Operational Support Services — SoftwareXcel offering will provide support for those operating systems and associated products that are not available with the newly announced Software Maintenance offering. This will ensure total support coverage for your enterprise needs, including IBM and selected non-IBM products. For complete lists of products supported under both the current and revised SoftwareXcel offering, visit

For additional information on the revised IBM Operational Support Services, refer to Services Announcement 601-023 , dated July 10, 2001.

IBM Operational Support Services — SoftwareXcel: Yes

iSeries™ Software Maintenance applies: No

Variable charges apply: No

Educational allowance available:

Yes, 15% education allowance applies to qualified education institution customers.

Sub-capacity terms and condition

On/Off CoD: To be eligible for On/Off CoD pricing, customers must be enabled for temporary capacity on the corresponding hardware, and the required contract — Z125-6611, Attachment for Customer Initiated Upgrade and IBM eServer On/Off CoD — Software — must be signed prior to use.
 
Back topBack to top
 

Prices

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.

Information on charges is available at

Select "United States" and then click "IBMLink 2000."

Entitlement                                  License option/
identifier          Description              pricing metric
 
Program name:  File Export for z/OS
Program PID 5697-I12
 
S0108ZK             File Export for z/OS     Basic OTC,
                                              Value Units
 
Subscription and Support PID 5697-I13
 
S010X8D             File Export for z/OS     Basic ALC
                                              No Charge, Decline

 
Back topBack to top
 
Order now

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

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

 Phone:     800-IBM-CALL (426-2255)
 Fax:       800-2IBM-FAX (242-6329)
 Internet:  ibm_direct@vnet.ibm.com
 Mail:      IBM Americas Call Centers
            Dept:  IBM CALL, 11th Floor
            105 Moatfield Drive
            North York, Ontario
            Canada M3B 3R1
 
 Reference: LE001

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

Note: Shipments will begin after the planned availability date.

Trademarks

 
IMS, iSeries, and IBMLink are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
z/OS, DB2, S/390, the e-business logo, zSeries, SystemPac, and Passport Advantage are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Other company, product, and service names may be trademarks or service marks of others.

Back to topBack to top
 

 
Printable version Printable version