IT21931: SPATIAL EXTENDERS DATA TYPES NOT CLEARED AFTER DB2SE DISABLE_DB <DATABASE> AND CANNOT BE DROPPED

Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 5 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 7 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• When performing the command "db2se disable_db <database>".
  DB2 shows that the operation was successful --> GSE0000I  The
  operation was completed successfully.
  However when performing a db2look or investigating the
  SYSCAT.DATATYPES
  or SYSIBM.SYSDATATYPES catalog tables, db2 shows that there are
  still 7 datatypes related to the db2se functionality remaining.
  >> db2 "select typename from syscat.datatypes where typeschema =
  'DB2GSE'"
  
  ST_GEOMCOLLECTION
  ST_LINESTRING
  ST_MULTILINESTRING
  ST_MULTIPOINT
  ST_MULTIPOLYGON
  ST_POINT
  ST_POLYGON
  
  Then tried to drop these datatypes manually but this instructs
  that the corresponding datatype does not exist.
  
  >> db2 drop type DB2GSE.ST_POINT
  DB21034E  The command was processed as an SQL statement because
  it was not a valid Command Line Processor command.  During SQL
  processing it returned: SQL0204N  "DB2GSE.ST_POINT" is an
  undefined name.  SQLSTATE=42704
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * ALL                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Db2 11.1 Mod 3 Fix Pack 3 or higher               *
  ****************************************************************
  

Problem conclusion

• First fixed in Db2 11.1 Mod 3 Fix Pack 3
  

Temporary fix

Comments

APAR Information

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

  IT20316

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

Fix information

• Fixed component name

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels

• RB10 PSN

     UP