PH15526: ADMIN TOOL DET DETAIL FUNCTION ADBPZAT SQLCODE = -923 00E30301 CATALOG COPY TABLE IDAA DB2 IFI ERROR

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When entering the DET (Detail) line command on panel ADBPZAT
  against a catalog copy table that has been loaded into an
  accelerator, the user may receive one of the following error
  messages:
  
  1)  DSNT408I SQLCODE = -923, ERROR:  CONNECTION NOT
  ESTABLISHED: DB2 ACCESS, REASON 00E30301, TYPE 00000800, NAME
  ADBnn
  DSNT418I SQLSTATE   = 57015 SQLSTATE RETURN CODE
  DSNT415I SQLERRP    = DSNAET03 SQL PROCEDURE DETECTING ERROR
  
  2) DB2 IFI error, return code= 8,reason code=00E60820
  
  
  
  
  
  Keywords: SQLCODEN923
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS and Object Comparison Tool for z/OS who *
  *                 use the Db2 Analytics Accelerator.           *
  ****************************************************************
  * PROBLEM DESCRIPTION: When the DET (Detail) line command is   *
  *                      issued against a catalog copy table     *
  *                      name on panel ADBPZAT 'Display          *
  *                      Accelerated Tables', SQLCODE -923 and   *
  *                      DB2 IFI error is encountered.           *
  ****************************************************************
  When DET (Detail) line command is issued against a catalog copy
  table name on panel ADBPZAT 'Display Accelerated Tables',
  the below SQLCODE -923 may be encountered:
  
  DSNT408I SQLCODE = -923, ERROR: CONNECTION NOT ESTABLISHED:
  DB2 ACCESS, REASON 00E30301, TYPE 00000800, NAME ADB01
  DSNT418I SQLSTATE = 57015 SQLSTATE RETURN CODE
  DSNT415I SQLERRP = DSNAET03 SQL PROCEDURE DETECTING ERROR
  
  The following error may also be encountered while issuing
  the DET command:
  
  DB2 IFI error, return code= 8,reason code=00E60820
  
  This APAR resolves this issue by not allowing users to execute
  the AT line command on panel ADB21T, 'Tables, Views, and
  Aliases', for catalog copy tables that have been added to an
  accelerator.  Without being able to execute the AT line command
  for such tables, users will not be able to display panel ADBPZAT
  and issue the DET command. The below error message will be
  displayed when any accelerator line commands (namely, AT, AR,
  RAR or ADDA) line commands are issued on a catalog copy table
  that has been added to an accelerator:
  
  ADB331E This function is not possible when running against a
  Catalog Copy.
  

Problem conclusion

• The 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:

  UI66624

Modules/Macros

• ADB21T   ADBP1AR0 ADBPZA20 ADBPZACA ADBPZAK0 ADBPZAR0 ADBPZAS0
  ADBPZAT0 ADBPZBT0 ADBPZDE0 ADBPZDT0 ADBPZED0 ADBPZIU0 ADBPZLT0
  ADBPZRE0 ADBPZTC0 ADBPZTR0 ADBPZUC0
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI66624

     UP19/11/30 P F911

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.