PK83355: NFDB29 CREATE/ALTER/DROP SUPPORT ALL NEW OPTIONS ON CREATE/ALTER STATEMENT. SUPPORT SCHEMA ON CREATE.

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Support all new options on CREATE/Alter statement. Support
  SCHEMA on CREATE. Support create/alter trusted context and role
  New line command to create, display and drop a clone of a table.
  

Local fix

• New Function
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool who use     *
  *                 Create/Alter options for tables,             *
  *                 storage groups, databases, triggers,         *
  *                 functions, procedures, types, sequences,     *
  *                 trusted contexts and roles.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: Additional support for Create/Alter on  *
  *                      tables, storage groups, databases,      *
  *                      triggers, functions, procedures,        *
  *                      types, and sequences.                   *
  *                                                              *
  *                      New panels for creating/altering        *
  *                      trusted context and Roles.              *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  Additional support for Create/Alter panels. New panels for
  creating/altering Trusted context and Roles.
  

Problem conclusion

Temporary fix

Comments

• New function/support for Create/Alter panels has been added.
  

APAR Information

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

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

Modules/Macros

•    ADBCCMM  ADBCDTS  ADBHCCJ  ADBH1TA  ADBH1TAB
  ADBH6CJ  ADBH6CN  ADBH6CQ  ADBH6CT  ADBH6CTF ADBH6CTS ADBH6CUU
  ADBH6CX  ADBH6TOP ADBMAIN  ADBNSPB  ADBTEPU  ADB2AN   ADB2ANAT
  ADB2ANI  ADB2ANID ADB2CC   ADB2CCI  ADB2CCJ  ADB2CCL  ADB2CCM
  ADB2CCT  ADB2CCU  ADB2CCV  ADB2PA6  ADB2W1   ADB21DA  ADB21GA
  ADB21SA  ADB21SAR ADB21TA  ADB21TAB ADB21XA  ADB21XAR ADB26
  ADB26CD  ADB26CE  ADB26CFA ADB26CFO ADB26CFS ADB26CFU ADB26CFX
  ADB26CG  ADB26CJ  ADB26CJV ADB26CN  ADB26CNA ADB26CNU ADB26COU
  ADB26CQ  ADB26CRO ADB26CRT ADB26CS  ADB26CT  ADB26CTF ADB26CTQ
  ADB26CTS ADB26CTU ADB26CUU ADB26CX  ADB26RT  ADB26TOP ADB27A
  ADB27AD  ADB27C   ADB27CF  ADB27CFU ADB47    ADB50
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK50262

     UP09/09/26 P F909

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.