PI39260: DB2 ADMIN REVOKE LINE COMMAND GETS IBM0441W ONCODE=150 THE STRINGSIZE CONDITION WAS RAISED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The ZA - System authorizations, R - Revoke line command function
  is trying to generate a severe error message and stopped with an
  exception IBM0441W. The IBM0441W message itself does not cause
  the revoke impact function to terminate but the severe error
  that has been found does. The customer should be able to see the
  (truncated) error message. The error message looks like this:
    "Can't revoke EXECUTE on (UDF) schema.name because
     (UDF) schema.name depends on it."
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who revoke EXECUTE authority for a      *
  *                 function.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2 Admin issues warning message        *
  *                      IBM0441W / msgibm0441w and an           *
  *                      ONCODE=150 / Oncode 150 occurs when     *
  *                      revoking EXECUTE authority for a        *
  *                      function:                               *
  *                                                              *
  *                      IBM0441W ONCODE=150  The STRINGSIZE     *
  *                      condition was raised..                  *
  *                      From entry point _Concnvs               *
  *                      at compile unit offset >offset< at      *
  *                      entry offset >offset< at address        *
  *                      >address<.                              *
  *                                                              *
  *                      From entry point                        *
  *                      SHOULDADDUDFNODE at                     *
  *                      statement >statement_id< at compile     *
  *                      unit offset >offset< at entry offset    *
  *                      >offset< at address >address<.          *
  *                                                              *
  *                      From entry point SHOULDADDNODE          *
  *                      at statement >statement_id< at compile  *
  *                      unit offset >offset< at entry offset    *
  *                      >offset< at address >address<.          *
  *                                                              *
  *                      From entry point ROUTINERIP at          *
  *                      statement >statement_id< at compile     *
  *                      unit offset >offset< at entry offset    *
  *                      >offset< at address >address<.          *
  *                                                              *
  *                      From entry point RIP at statement       *
  *                      >statement_id< at compile               *
  *                      unit offset >offset< at entry offset    *
  *                      >offset< at address >address<.          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When revoking EXECUTE authority for a function, DB2 Admin
  displays warning message IBM0441W and an ONCODE=150 error
  occurs.
  

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:

  UI29708 UI29709

Modules/Macros

•    ADBRIP9  ADB2RIP
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI29708

     UP15/07/28 P F507

• RB10 PSY UI29709

     UP15/07/28 P F507

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.