PK44995: ADMIN DSNT404I SQLCODE 562 SQLCODE562 INCORRECT GRANT ON ALTER OF SIMPLE TABLE TO SEGSIZE = 64

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When using Admin to Alter a Table using AL and RDEF to change a
  simple table to segsize=64 ( segmented ) the wsl job fails with
  Rc=8
  DSNT404I SQLCODE = 562, WARNING:  A GRANT OF A PRIVILEGE WAS
      IGNORED BECAUSE THE GRANTEE ALREADY HAS THE PRIVILEGE FROM
      THE GRANTOR
  DSNT418I SQLSTATE   = 01560 SQLSTATE RETURN CODE
  DSNT415I SQLERRP    = DSNXA07 SQL PROCEDURE DETECTING ERROR
  DSNT416I SQLERRD    = -250  0  0  -1  0  0 SQL DIAGNOSTIC
  DSNT416I SQLERRD    = X'FFFFFF06'  X'00000000'  X'00000000'
                        X'FFFFFFFF' X'00000000'  X'00000000'
                        SQL DIAGNOSTIC INFORMATION
  .
  sqlcode562 sqlcode=562 sqlcode 562
  

Local fix

• Please apply ptf when available
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 ADMIN TOOL who use the Redefine *
  *                 Table Space function.                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: An SQL 562 warning message was received *
  *                      when running the output produced by the *
  *                      Redefine Table Space function.          *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  An unnecessary GRANT STOGROUP was generated which caused the
  SQL 562 warning message.
  

Problem conclusion

• The unnecessary GRANT STOGROUP statement has been removed.
  The 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

•    ADB21SAJ
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK30223

     UP07/10/25 P F710

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.