PI47677: DB2 ADMINISTRATION TOOL FOR Z/OS FOLLOW-ON APAR.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 ADMINISTRATION TOOL FOR Z/OS FOLLOW-ON APAR.
  MISCELLANEOUS FIXES.
  ADDITIONAL SYMPTOMS:
  CM Analyze fails with the following error:
  DSNT408I SQLCODE = -981, ERROR:  THE SQL STATEMENT FAILED
  BECAUSE THE RRSAF CONNECTION IS NOT IN A STATE THAT ALLOWS
  SQL OPERATIONS, REASON  00C12219
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: The following has been delivered:       *
  *                                                              *
  *                      1 - DB2 Administration Tool now has     *
  *                      the ability to overwrite attribute      *
  *                      RESTRICT ON DROP using the Generate     *
  *                      (GEN) function with masking for         *
  *                      objects tables.                         *
  *                                                              *
  *                      Example to overwrite RESTRICT           *
  *                      ON DROP attribute for tables:           *
  *                                                              *
  *                      RESONDROP:TBCRE*.MYTB*,NO               *
  *                                                              *
  *                      2 - DB2 Administration Tool now has     *
  *                      the ability to overwrite attribute      *
  *                      RESTRICT ON DROP using the Work         *
  *                      Statement List (WSL) cloning function   *
  *                      with masking for objects tables.        *
  *                                                              *
  *                      Example to overwrite RESTRICT           *
  *                      ON DROP attribute for tables:           *
  *                                                              *
  *                      RESONDROP:TBCRE*.MYTB*,NO               *
  *                                                              *
  *                      3 - DB2 Administration Tool now has     *
  *                      the ability to overwrite attribute      *
  *                      RESTRICT ON DROP using the Change       *
  *                      Management (CM) import function with    *
  *                      masking for objects tables.             *
  *                                                              *
  *                      Example to overwrite RESTRICT ON        *
  *                      DROP attribute for tables:              *
  *                                                              *
  *                      RESONDROP:TBCRE*.MYTB*,NO               *
  *                                                              *
  *                      4 - The REPLACE field is missing on     *
  *                      panel ADB2UTC 'Specify Utility          *
  *                      Options - LOAD' when primary command    *
  *                      'PANEL ADB2UTC' is issued:              *
  *                                                              *
  *                      REPLACE  . . . . . .     (Yes/No) ..    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The following has been delivered:
  
  1 - DB2 Administration Tool now has the ability to overwrite
  attribute RESTRICT ON DROP using the (GEN) function with
  masking for objects tables.
  
  2 - DB2 Administration Tool now has the ability to overwrite
  attribute RESTRICT ON DROP using the WSL cloning function with
  masking for objects tables.
  
  3 - DB2 Administration Tool now has the ability to overwrite
  attribute RESTRICT ON DROP using the CM import function
  with masking for objects tables.
  
  4 - DB2 Administration Tool will now display the REPLACE field
  on panel ADB2UTC when primary command 'PANEL ADB2UTC' is
  issued.
  

Problem conclusion

• Enhancements delivered.
  

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:

  UI31508

Modules/Macros

• ADBASP   ADBASW   ADBCCM   ADBCCMM  ADBCDTS  ADBCEST  ADBCNBVF
  ADBCRCM  ADBCRCR  ADBCSPG  ADBCVEY  ADBCVEZ  ADBC31   ADBDAT
  ADBDK    ADBEDIAG ADBE1DSN ADBGAJOB ADBHC2L  ADBHUPA  ADBH1DSN
  ADBLI    ADBMAIN  ADBMSG   ADBNSPB  ADBPA1   ADBPC41E ADBPREAD
  ADBPZAC  ADBPZAT  ADBP7F   ADBR     ADBRIP9  ADBTEPI  ADBTEPR
  ADBTEPU  ADBTEP2  ADBVERS  ADBV99   ADB1000  ADB2CID  ADB2CME
  ADB2CMF  ADB2CMM  ADB2CMO  ADB2CMP  ADB2CMR  ADB2CMS  ADB2CMT
  ADB2CMU  ADB2CM1  ADB2CM2  ADB2CM3  ADB2CUST ADB2C11  ADB2C2L
  ADB2DSN0 ADB2FMT  ADB2GEN  ADB2MASK ADB2MSK  ADB2MSQ  ADB2PA
  ADB2PA3  ADB2PA4  ADB2PA5  ADB2PA6  ADB2PA7  ADB2RE   ADB2REE
  ADB2REG  ADB2REH  ADB2REM  ADB2REZ  ADB2RIP  ADB2UPA  ADB2USC
  ADB2USE  ADB2USO  ADB2USOO ADB2USO1 ADB2USUD ADB2USU2 ADB2US2
  ADB2UTC  ADB2UTUD ADB2UTUX ADB2UTU2 ADB2UXC  ADB2UX2  ADB2WCL
  ADB2WVL  ADB2W1   ADB2ZZ   ADB2ZZAL ADB2ZZAP ADB2ZZMN ADB2ZZOT
  ADB2ZZUT ADB2ZZVA ADB2ZZVB ADB2ZZV9 ADB2000  ADB21    ADB21D
  ADB21DSN ADB21G   ADB21KR  ADB21KRN ADB21XAS ADB25    ADB26CFV
  ADB27AC  ADB278C1 ADB28DEL ADB28HPL ADB28HPU ADB28HPV ADB28LT
  ADB28M   ADB28MC  ADB28MCT ADB28RL1 ADB28UL1 ADB28UT  ADB3000
  ADB7000  ADB9000  H0IHB20J
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI31508

     UP15/09/30 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.