IBM Support

PK95228: PANEL ADB2USU DOES NOT VALIDATE THAT THE OPTIONS SPECIFIED ARE VALID DSNU049I DSNUGPRS INVALID OPERAND FOR KEYWORD

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The DB2 Administration Tool for z/OS panel ADB2USU "Specify
    Utility Options - UNLOAD" does not validate the input resulting
    in customers being able to specify options which will result
    in the job failing RC08 with the message:
    DSNU049I  DSNUGPRS - INVALID OPERAND 'aaaaaa' FOR KEYWORD
    'aaaaaa'
    e.g.
    DSNUGPRS - INVALID OPERAND 'HEADER' FOR KEYWORD 'UNLOAD'
    as UNLOAD TABLESPACE aaa.aaa FROM TABLE ttt NOPAD HEADER NONE
    was built.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of DB2 Administration Tool for z/OS    *
    *                 who use Unload Table options or Unload       *
    *                 Tablespace Utility options.                  *
    ****************************************************************
    * PROBLEM DESCRIPTION: Unload via table fails:-                *
    *                      1.When NOPAD and HEADER options are     *
    *                        used.                                 *
    *                      2.When DELIMITED and HEADER options     *
    *                        are used, although it is a valid      *
    *                        combination.                          *
    ****************************************************************
    * RECOMMENDATION: Apply The PTF.                               *
    ****************************************************************
    Unload via table options NOPAD and HEADER combination fails.
    DELIMITED and HEADER combination fails.
    

Problem conclusion

  • The problem has been fixed.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PK95228

  • Reported component name

    DB2 ADMIN TOOL

  • Reported component ID

    568851500

  • Reported release

    720

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-09-01

  • Closed date

    2010-01-21

  • Last modified date

    2010-02-01

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

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

Modules/Macros

  •    ADBHUSU  ADB2USU  ADB2UT   ADB2UUOP ADB25LU
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • R720 PSY UK53736

       UP10/01/28 P F001

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

Document Information

Modified date:
01 February 2010