Re: copy failure

   After further thought that's not gonna work, because most likely you are
   copying to
   a physical that has a logical( i.e. index ) that has key(s) that have to
   be "unique" and
   that's where the error seems to be occurring:

 Message . . . . : Duplicate key on access path for based-on member of CHIFMTS.

   So, either you need to change the index to "non-unique" so as to allow
   duplicates or check the data your copying in for errors if there
   should never be duplicates that will affect the index(s) on the
   physical file.  You can find the row causing the problem by using
   SQL to find the offending data that already exists.

   hth

    Off the top of my head, You could try *UPDADD instead of *ADD.....
    just press F1 for that field on the CPYF command to see details......

    donna lester wrote:

  I am doing a copy in one of the jobs, it fails for the reason below:
  Below is the joblog:
  Can some one let me know how to make sure copy successful?
  -----------------------------
  CPYF FROMFILE(dlester/CHIFMTSBK)
  TOFILE(GMSPROD/CHIFMTS) MBROPT(*ADD)
  Message . . . . : Key for record in member CHIFMTS reserved.
  Cause . . . . . : The output or update operation on member CHIFMTS, file
  CHIFMTS in library GMSPROD, record 0 format CHIFMTS member number 1 was
  not successful. Format CHIFMTS member number 1 is under commitment control
  and has the key reserved. If the record number is zero, the duplicate key
  occurred on an output operation.
  30 01/10/07 14:09:09.785632 QDBSIGEX QSYS 01D6 QCPGENIO QSYS
  Message . . . . : Duplicate key on access path for based-on member of
  CHIFMTS.
  Cause . . . . . : An output or update operation on record number 0 record
  format CHIFMTS member number 1 failed because of a duplicate key in a unique
  keyed member that is based on member CHIFMTS file CHIFMTS in library
  GMSPROD, or in a based-on member of CHIFMTS. The key is a duplicate of a
  reserved key under commitment control. Recovery . . . : See previously
  listed message CPD4068 to identify the record with the duplicate key and
  change the key value so that it is unique. Then try your request again.
  Message . . . . : Cancel reply received for message CPF5085.
  Message . . . . : Error writing to member CHIFMTS in file CHIFMTS.
  Cause . . . . . : The file was not copied because an error occurred while
  writing records to member CHIFMTS in file CHIFMTS in library GMSPROD.