PI13143: WSL APPLY JOB SHOWS MESSAGE ADB5143E DSN COMMAND ERROR FOR INVALID KEYWORD, ) FOR REBIND STATEMENT WITH CONTINUATION CHAR

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' APPLY jobs issue a message
  ADB5044I *** INPUT STATEMENT:
     REBIND
  PACKAGE(aaaaaaa.aaaaaaa.(aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa-
   aaaaaaaaaaaaaaaaaaaaaaaaaaaaa)) ;
  ADB5060I *** Implicit commit performed, number:             5
  
  INVALID KEYWORD, )
  ADB5143E DSN command error.
  when processing a REBIND which has a continuation character
  due to a long VERSION.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration and DB2      *
  *                 Object Comparison Tool for z/OS who use      *
  *                 the 'ALT Alter Table' (ALT) function.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: Execution of the ALT created APPLY      *
  *                      job issues a message:                   *
  *                                                              *
  *                      ADB5044I *** INPUT STATEMENT:           *
  *                         REBIND                               *
  *                      PACKAGE(aaaaaaa.aaaaaaa                 *
  *                      .(aaaaaaaaaaaaaa                        *
  *                      aaaaaaaaaaaaaaaaaaaaa-                  *
  *                      aaaaaaaaaaaaaaaaaaaaaaaaa)) ;           *
  *                      ADB5060I *** Implicit commit            *
  *                      performed, number:             5        *
  *                                                              *
  *                      INVALID KEYWORD,                        *
  *                      ADB5143E DSN command error.             *
  *                                                              *
  *                      when processing a REBIND which has      *
  *                      a continuation character due to a       *
  *                      long VERSION.                           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Execution of the ALT created APPLY job issues a message:
  
  ADB5044I *** INPUT STATEMENT:
     REBIND
  PACKAGE(aaaaaaa.aaaaaaa
  .(aaaaaaaaaaaaaa
  aaaaaaaaaaaaaaaaaaaaa-
  aaaaaaaaaaaaaaaaaaaaaaaaa)) ;
  ADB5060I *** Implicit commit
  performed, number:             5
  
  NVALID KEYWORD,
  ADB5143E DSN command error.
  
  when processing a REBIND which has a continuation character
  due to a long VERSION.
  

Problem conclusion

• Problem has been resolved.
  

Temporary fix

Comments

APAR Information

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

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

  UI19189 UI19190

Modules/Macros

•    ADBTEP2
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI19189

     UP14/06/28 P F406

• RB10 PSY UI19190

     UP14/06/28 P F406

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.