IBM Support

PK13530: MIG ERRORS HANDLING --#SET ACCEPT_RC SYNTAX. SQLCODE204 SQLCODE516 SQLCODE601

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, using migrate function, MIG ,
    various errors occur handling the --#SET ACCEPT_RC syntax
    .
    Additional symptoms: sqlcode204 sqlcode516 sqlcode601
    

Local fix

  • Remove the zero from the command:
      --#SET ACCEPT_RC 0 -601
    To leave the following syntax:
      --#SET ACCEPT_RC -601
    Use same workaround for other sqlcodes
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of DB2 Administration Tool, who        *
    *                 use MIG and ADBTEP2, may be affected.        *
    ****************************************************************
    * PROBLEM DESCRIPTION: MIG  encountered  errors  when handling *
    *                      -- #SET ACCEPT_RC SYNTAX --             *
    *                      ( SQLCODE204  SQLCODE516  SQLCODE601 ). *
    *                      .*                                      *
    *                      ADBTEP2 program was mis-handling return *
    *                      code zero on some conditions.           *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    See Problem Description.
    

Problem conclusion

  • Apply the fix.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PK13530

  • Reported component name

    DB2 ADMIN TOOL

  • Reported component ID

    568851500

  • Reported release

    710

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2005-10-14

  • Closed date

    2006-01-13

  • Last modified date

    2006-02-02

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

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

Modules/Macros

  •    ADBTEP2
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • R710 PSY UK10827

       UP06/01/19 P F601

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":"7.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
02 February 2006