PH34878: DB2 ADMIN TOOL: GEN: -811 GENERATING DDL ON TABLE IN IMPLICIT PBG TABLE SPACE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Db2 Admin Tool: GEN: -811 generating DDL on table in implicit
  PBG table space that has extended to more than one
  dataset/partition
  
  
  Error:
  
  ADB1223E ADB2REM:  Unexpected sqlcode in : Select systablepart
                     (first)
  
  
  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
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS reverse engineering (GEN) function.     *
  *                                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION: SQLCODE -811 is returned when           *
  *                      generating DDL for a table in an        *
  *                      implicitly created PBG table space.     *
  ****************************************************************
  Generating DDL for a table that is in an implicitly created PBG
  table space might result in an SQLCODE -811.
  
  Example error:
  
  DB1223E ADB2REM:  Unexpected sqlcode in : Select systablepart
  (first)
  
  DSNT408I SQLCODE = -811, ERROR:  THE RESULT OF AN EMBEDDED
  SELECT STATEMENT
  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
  DSNT418I SQLSTATE   = 21000 SQLSTATE RETURN CODE
  DSNT415I SQLERRP    = DSNXREMS SQL PROCEDURE DETECTING ERROR
  DSNT416I SQLERRD    = -140  0  0  -1  0  0 SQL DIAGNOSTIC
  INFORMATION
  DSNT416I SQLERRD    = X'FFFFFF74'  X'00000000'  X'00000000'
  X'FFFFFFFF'
  X'00000000'  X'00000000' SQL DIAGNOSTIC INFORMATION
  DSNT417I SQLWARN0-5 = W,,,W,, SQL WARNINGS
  

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:

  UI74411

Modules/Macros

• ADB2REM
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI74411

     UP21/03/16 P F103

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.