Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2008
    Posts
    16

    Unanswered: Issue with DSN1COPY - Data getting spilled over to another file

    While copying from PROD to TEST thru DSN1COPY, I have this issue.

    Input: XXX.DSNDBC.DATABAS1.TABLESP1.I0001.A001
    The above file should get copied to below file only.
    Output: XXX.DSNDBC.DATABAS2.TABLESP1.I0001.A001

    However, in spool I see the below message.

    INPUT DSNAME = XXXX.DSNDBC.DATABAS1.TABLESP1.I0001.A001 , VSAM
    OUTPUT DSNAME = XXXX.DSNDBC.DATABAS2.TABLESP1.I0001.A001 , VSAM
    OUTPUT DSNAME = XXXX.DSNDBC.DATABAS2.TABLESP1.I0001.A002 , VSAM

    What I understand is, there is a lot of data in input file which is
    perhaps why it is getting spilled over to another file.

    These are the parms I pass

    PARM='FULLCOPY,OBIDXLAT,RESET,PAGESIZE(4K)',
    REGION=4096K

    Question: How do I avoid this?

    DB2V8
    z/OS

    Please let me know if you need any more information.

    Ricky Ponting

  2. #2
    Join Date
    Dec 2005
    Posts
    273
    You specify FULLCOPY within the parms.
    With this you tell DB2, that SYSUT1 is a full image copy.

    Just omit this parm to tell DB2 that SYSUT1 is a tablespace

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •