Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange Bulk Data Movement
  3. PowerExchange Listener
  4. Adabas Bulk Data Movement
  5. Datacom Bulk Data Movement
  6. DB2 for i5/OS Bulk Data Movement
  7. DB2 for Linux, UNIX, and Windows Bulk Data Movement
  8. DB2 for z/OS Bulk Data Movement
  9. IDMS Bulk Data Movement
  10. IMS Bulk Data Movement
  11. Microsoft SQL Server Bulk Data Movement
  12. Oracle Bulk Data Movement
  13. Sequential File Bulk Data Movement
  14. VSAM Bulk Data Movement
  15. Writing Data with Fault Tolerance
  16. Monitoring and Tuning Options

Bulk Data Movement Guide

Bulk Data Movement Guide

Rules for Reject File Naming on i5/OS

Rules for Reject File Naming on i5/OS

On i5/OS, PowerExchange uses the following reject file naming rules:
  • If you do not specify a reject file value, all reject file members that are created for a single session are located under one FILENAME. PowerExchange uses the following defaults:
    LIBRARYNAME=DATALIB
This value is from the CRTPWXENV installation step.
  • FILENAME=PWXR
    nnnnnn
    Where
    nnnnnn
    is the six-digit i5/OS job number.
    For example:
    FILENAME=PWXR713895
  • MEMBERNAME=
    strategy
    _
    i5OSjobnumber
    _
    uniquepwxref
    The following table describes the variables in MEMBERNAME:
    Variable
    Description
    strategy
    I (Insert), U (Update), D (Delete), or M (Mutated Update)
    i5OSjobnumber
    A six-digit job number (
    nnnnnn
    )
    uniquepwxref
    A unique three-digit number (
    nnn
    )
    For example:
    MEMBERNAME=I713895001
    Optionally, you can enter a LIBRARYNAME and FILENAME separated by a slash (/).
  • If you specify a LIBRARYNAME only, PowerExchange creates the FILENAME based on the default FILENAME format.
    PowerExchange writes the reject file members for each session to a separate i5/OS file.
  • If you specify a FILENAME that ends with a slash (/) or a FILENAME that is more than four characters in length but does not end with a slash (/), PowerExchange uses that value as specified.
    PowerExchange writes all of the reject file members for multiple sessions to a single i5/OS file.
    For example, assume that you enter the following reject file value:
    MYLIBNAME/MYFILENAME/
    PowerExchange creates reject file members that have names in the following format:
    MYLIBNAME/MYFILENAME/
    member_name
    For the first session, PowerExchange writes the following reject file members to an i5/OS file:
    LIBRARY/MYFILENAME/I713895001 LIBRARY/MYFILENAME/U713895002 LIBRARY/MYFILENAME/D713895003
    For a subsequent session, PowerExchange adds the following reject file members to the same file:
    LIBRARY/MYFILENAME/I713895001 LIBRARY/MYFILENAME/U713895002 LIBRARY/MYFILENAME/D713895003 LIBRARY/MYFILENAME/I839406001 LIBRARY/MYFILENAME/U839406002 LIBRARY/MYFILENAME/D839406003
  • If you enter a FILENAME value that is one to four characters in length but does not end with a slash (/), PowerExchange appends a six-digit job number to the file name.
    For example, assume that you specify the following FILENAME value:
    MYLIBNAME/PREF
    PowerExchange will create reject file members that have names in the following format:
    MYLIBNAME/PREF
    nnnnnn
    /
    member_name
    PowerExchange writes the reject file members for each session to a separate i5/OS file.
    For example, for the first session, PowerExchange writes the following members to a single i5/OS file:
    LIBRARY/PREF713895/I713895001 LIBRARY/PREF713895/U713895002 LIBRARY/PREF713895/D713895003
    For a subsequent session, PowerExchange writes the following members to a new i5/OS file:
    LIBRARY/PREF839406/I839406001 LIBRARY/PREF839406/U839406002 LIBRARY/PREF839406/D839406003

0 COMMENTS

We’d like to hear from you!