PK06459: VARIOUS PROBLEMS HANDLING REBIND IN WSL ( WORK STATEMENT LIST ) IN ADMIN PANELS: ADB2W1 ADB2W1I

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In DB2 Administration Tool various problems can occur when
  processing a WSL that contains REBIND statement(s).
  .
  1. I line command ( Interpret ) in panel adb2w1 can fail with
     msgawin901e AWIN901E with messages similar to:
      Error inserting object name into symbtab.
     TOKEN_INDEX=            11;  , Token=07
     AWIN901E: Error interpreting statement or command with
               TYPE of DSN . The following text string was
               interpretted as is with TYPE of ERR :
     REBIND PACKAGE(DSNTWR81.DSNTWR.(2004-07-27-08.06.03.
       105244)) ::  QUAL(DB2ADM) ::  OWNER(DB2ADM) :: ...
  .
  2. Panel ADB2W1I displays duplicate REBIND statements.
  .
  3. Q line command ( Clone ) in panel adb2w1 can fail with
     msgadbq901e ADBQ901E with messages similar to:
      Error inserting object name into symbtab.
     TOKEN_INDEX=            11;, Token=07
     ADBQ901E: Error interpreting statement or command with
               TYPE of DSN . The following text string was
               cloned as is with TYPE of ERR :
     REBIND PACKAGE(DSNTWR81.DSNTWR.(2004-07-27-08.06.03.
       105244)) ..  QUAL(DB2ADM) ..  OWNER(DB2ADM) ..  VALID(R)
       ..  ISOL(CS) ..  EXPL(N) ..  DEGREE(1) ..  KEEPDY ...
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool, who use    *
  *                 Cloning application, may be affected.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: Cloning   (ADB2PA4)  failed  on  REBIND *
  *                      PACKAGE  statement when  version-id was *
  *                      a timestamp.                            *
  *                      .* Various  problems  could occurr when *
  *                      processing a WSL that  contained REBIND *
  *                      REBIND statement(s). For examples:      *
  *                      1. I  line command (Interpret) in panel *
  *                      ADB2W1 could fail with message AWIN901E *
  *                      2. Panel  ADB2W1I  displayed  duplicate *
  *                      REBIND statements.                      *
  *                      3. Q  line  command  (Clone)  in  panel *
  *                      ADB2W1 could fail with message ADBQ901E *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Cloning (ADB2PA4) failed on REBIND PACKAGE statement when
  version-id was a timestamp.
  

Problem conclusion

• The reported problem has been fixed.
  

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:

Modules/Macros

•    ADB2PA   ADB2PA4
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R510 PSY UK07267

     UP05/09/17 P F509

• R710 PSY UK07268

     UP05/09/17 P F509

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.