PI96636: DB2 ADMIN TOOL - GEN COMMAND RETURNS ADB1223E ADB2REM: UNEXPECTED SQLCODE IN : SELECT SYSTABLES, SQLCODE -811

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Doing GEN command on a database returns error:
  Processing Database ADMDB0
  
   ADB1223E ADB2REM:  Unexpected sqlcode in : Select systables
  
  DSNT408I SQLCODE = -811, ERROR:  THE RESULT OF AN EMBEDDED
             SELECT STATEMENT OR A SUBSELECT IN THE SET CLAUSE OF
             AN UPDATE STATEMENT IS A TABLE OF MORE THAN ONE ROW,
             OR THE RESULT OF A SUBQUERY OF A BASIC PREDICATE IS
             MORE THAN ONE VALUE
  
  SQLCODEN811
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS and DB2 Object Comparison           *
  *                 Tool for z/OS.                               *
  ****************************************************************
  * PROBLEM DESCRIPTION: GEN Command against a Database          *
  *                       returns error :                        *
  *                                                              *
  *                       Processing Database >database<         *
  *                       ADB1223E ADB2REM: Unexpected           *
  *                       sqlcode in : Select systables          *
  *                                                              *
  *                       SQLCODE=-811 / SQLCODEN811             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  GEN Command against a Database returns error :
  
  Processing Database <database>
  ADB1223E ADB2REM: Unexpected sqlcode in : Select
  systables
  
  DSNT408I SQLCODE = -811, ERROR: THE RESULT OF
   AN EMBEDDED SELECT STATEMENT OR A SUBSELECT
   IN THE SET CLAUSE OF AN UPDATE STATEMENT
   IS A TABLE OF MORE THAN ONE ROW, OR THE RESULT
   OF A SUBQUERY OF A BASIC PREDICATE IS MORE THAN
   ONE VALUE
  
  The problem was caused by the tables with the same table
  name but various CREATORs in different IDAA accelerators.
  For example:
  
   CREATE TABLE TS5769.RPA0T2
      (I1 INTEGER NOT NULL)
      IN ACCELERATOR DC1QACC1
      IN DATABASE DBOCRHPA
      CCSID UNICODE;
  
  and:
  
   CREATE TABLE TS5769A.RPA0T2
      (I1 INTEGER NOT NULL)
     IN ACCELERATOR IDAAZ01
     IN DATABASE DBOCRHPA
     CCSID UNICODE;
  

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:

Modules/Macros

•    ADB2REM
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI56654

     UP18/06/22 P F806

• RC10 PSY UI56655

     UP18/06/22 P F806

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.