IBM File Export simplifies your highly selective data copying needsIBM United States Software Announcement 204-288
November 30, 2004
|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
Back to top
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 to top
|Planned availability date|
December 3, 2004
Back to top
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 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 to top
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.
Back to top
Product information is available via the Offering Information Web site
Back to top
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 to top
- 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.
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 to top
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.
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 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
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 On/Off CoD
Software must be signed prior to use.
Back to top
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 to top
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: firstname.lastname@example.org 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.
Back to top