IBM Support

PK06085: MSGDSNU047I A REQUIRED DD CARD OR TEMPLATE IS MISSING. NAME=SYSREC RC8 - FROM LOAD STEP OF MIGRATE WSL

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • In DB2 Administration Tool, MIG (migrate) can fail in the LOAD
    step with error messages similar to the following:
    DSNU047I    DSNURELD - A REQUIRED DD CARD OR TEMPLATE IS
                MISSING. NAME=SYSREC.
    .
    LOAD job terminates with rc8 rc08 . Problem is only seen when
    running the MIG job from a WSL ( Work Statement List ) using DB2
    UNLOAD and specifying parallel utility operation, as shown in
    the following MIG panel prompts:
       Generate work stmt list . . . . . : YES      (Yes/No)
       Unload Method . . . . . . . . . . : U        (U - Unload)
       Parallel Utilities  . . . . . . . : YES      (Yes/No)
    .
    Examination of WSL shows no SYSREC TEMPLATE included in the WSL.
    

Local fix

  • Specify PARALLEL = N
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of DB2 Administration Tool who use     *
    *                 Migrate function may be affected.            *
    ****************************************************************
    * PROBLEM DESCRIPTION: MIG (Migrate) can fail in the LOAD step *
    *                      with error messages like the following: *
    *                      DSNU047I DSNURELD - A REQUIRED DD CARD  *
    *                      OR TEMPLATE IS MISSING. NAME=SYSREC.    *
    *                      .*                                      *
    *                      LOAD job terminates with RC08. Problem  *
    *                      is only seen when running the MIG job   *
    *                      from a WSL (Work Statement List) using  *
    *                      DB2 UNLOAD and specifying parallel      *
    *                      utility operation.                      *
    *                      .*                                      *
    *                      Examination of WSL shows no SYSREC      *
    *                      TEMPLATE included in the WSL.           *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    When running parallel processing, work statement list and
    UNLOAD are used to migrate a table, the LOAD work statement
    list job failed RC=8 with a message DSNU047I DSNURELD - A
    REQUIRED DD CARD OR TEMPLATE IS MISSING NAME=SYSREC due to
    the SYSREC template not being generated in the JCL.
    

Problem conclusion

  • The changes are to generate sysrec template or DD card whenever
    it is necessary. All possible combinations of the following four
    parameters to migrate TSs and TBs have been conidered:
    .*
    UNLOAD method,
    Parallel - Y/N
    SWL -Y/N
    Template - Y/N.
    .*
    The template or DD card should now be generated properly.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PK06085

  • Reported component name

    DB2 ADMIN TOOL

  • Reported component ID

    568851500

  • Reported release

    510

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2005-05-19

  • Closed date

    2005-07-14

  • Last modified date

    2005-08-02

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Modules/Macros

  •    ADB28LT  ADB28RL1 ADB28UL1 ADB28UT
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • R510 PSY UK05387

       UP05/07/21 P F507

Fix is available

  • Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
02 August 2005