IBM Support

PK35445: AL / RDEF USING ONLY IC UTILITY PRODUCES DSN THAT EXCEEDS 44 CHARACTERS

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 AL / RDEF and requesting only
    the IC Image Copy utility an extra ' P ' is appended to the
    IC DSN. In appending the extra character, the dataset name
    exceeds the 44 character DSN limit, resulting in a JCL error.
    .
    Specifying another utility, REORG or CHECK DATA , in addition to
    the IC utility produces correct DSN with no ' P ' appended.
    .
    Customer's adb2ucus modifications show:
    )SET ASYCPYA =
    &PREFIX..IC.&DBNAME..&NAME&SFX..D&AJDATE..T&ATIME4
    .
    Resulting in the following DSN when only IC utility is chosen:
      TEMPLATE SYSCOPY
      DSN 'IDT.D4DT10.IC.DBD4MAP1.TSD4COPY.P.D06305.T1631'
      UNIT SYSDA;
    .
    Choosing another utility, in addition to IC, produces the
    following:
      TEMPLATE SYSCOPY
      DSN 'IDT.D4DT10.IC.DBD4MAP1.TSD4CPY1.D06305.T1559'
      UNIT SYSDA;
    .
    Additional keywords: Alter Redefine
    

Local fix

  • Choose REORG or CHECK DATA utility along with IC utility for
    AL / RDEF operations until a fix is available.
    .
    Note: not all customers will be affected by this DSN problem.
    Customer's adb2ucus modifications built a DSN that was very
    close to the 44-character limit. As distributed, default DSN
    name from un-modified adb2ucus skeleton does not generate a
    name that exceeds 44-characters. However, the DSN generated is
    inconsistent, depending on utility choices noted above.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of DB2 Administration Tool, who use    *
    *                 RDEF  Image Copy  Yes  Option on ADB21SAJ    *
    *                 panel, may be affected.                      *
    ****************************************************************
    * PROBLEM DESCRIPTION: AL/RDEF using  only IC UTILITY produces *
    *                      DSN that exceeds 44 characters.         *
    *                      .*                                      *
    *                      Using AL / RDEF and requesting only the *
    *                      IC Image Copy utility an extra ' P ' is *
    *                      appended  to the  IC  DSN. In appending *
    *                      the  extra  character, the dataset name *
    *                      exceeds  the  44  character  DSN limit, *
    *                      resulting in a JCL error.               *
    *                      .* Note:                                *
    *                      Not  all  customers will be affected by *
    *                      this DSN  problem. Users whose ADB2UCUS *
    *                      modifications built a DSN that was very *
    *                      close to the 44-character limit.        *
    *                      .*                                      *
    *                      When a Image Copy is requested from the *
    *                      ADB21SAJ panel.  The  SYSCOPY generated *
    *                      DSN will have an '.P'  affixed  to  the *
    *                      end of the DSN.                         *
    *                      .*                                      *
    *                      If  Image Copy is selected and no other *
    *                      options  are selected  in the 'Optional *
    *                      jobs after redefinition'  area of Panel *
    *                      ADB21SAJ. A '.P' is appended to the DSN *
    *                      on the SYSCOPY DD Statement.  If  CHECK *
    *                      DATA  or  RUNSTATS  are also  requested *
    *                      with Image Copy, then no '.P' is append *
    *                      to the DSN on the SYSCOPY DD Statement. *
    *                      .* Note: another problem fixed          *
    *                      When  returning  from  Panel ADB2UPA to *
    *                      Panel ADB21SAJ  the Worklist name field *
    *                      is blanked out.  This happens for first *
    *                      time users  who  haven't  established a *
    *                      prior Worklist Name.                    *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    See Problem Description.
    

Problem conclusion

  • Apply the fix.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PK35445

  • 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

    2006-11-29

  • Closed date

    2007-01-24

  • Last modified date

    2007-02-02

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

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

Modules/Macros

  •    ADB21SAJ
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • R710 PSY UK21557

       UP07/01/27 P F701

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 2007