PH08599: DB2 ADMINISTRATION TOOL - SUBMIT OF MIG WSL GETS SQLCODE = -104, ERROR: ILLEGAL SYMBOL "UNIT"

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• MIG generated the a WSL with the erroneously added to the WSL:
  UNIT VTS;;
  
  which causes the WLS to fail:
     SQL statement:
     SQL error:
      DSNT408I SQLCODE = -104, ERROR:  ILLEGAL SYMBOL "UNIT". SOME
               SYMBOLS THAT MIGHT BE LEGAL ARE:
                       <ERR_STMT> <WNG_STMT>
               TRANSFER GET SQL SAVEPOINT HOLD FREE
  
  SQLCODE -104 / SQLCODEN104
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS.   *
  ****************************************************************
  * PROBLEM DESCRIPTION: Submit of generated MIG WSL gets        *
  *                      SQLCODE = -104 / SQLCODEN104.           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Submit of generated MIG WSL gets
  the following error:
  
  DSNT408I SQLCODE = -104,
  ERROR: ILLEGAL SYMBOL "UNIT".
  SOME SYMBOLS THAT MIGHT
  BE LEGAL ARE: <ERR_STMT>
  <WNG_STMT> TRANSFER GET
  SQL SAVEPOINT HOLD
  FREE
  

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:

  UI63335

Modules/Macros

•    ADB28RL1
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI63335

     UP19/06/04 P F906

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.