Troubleshooting
Problem
Attempts to re-initialize a z/DB2 using IBM Sterling Control Center v5.3.04 results in the error ERROR DB_Init - An error occurred while executing SQL command. drop table EVENTS_EXT SQL Error code = -669 Error code : InstallErrorCodeList.4008 ERROR DB_Init - com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-669, SQLSTATE=42917, SQLERRMC=0001, DRIVER=3.66.46 Error occurs while re-initializing the DB in configCC
Cause
faulty drop_zos_partitioned_tables.sql
Environment
Platform z/Linux 2.6.32-358.6.2.el6.s390x
Red Hat Enterprise Linux Server release 6.4
SCC Engine 5.3.0.4_iFix01 - build October 30 2013 02:48
Database DB2 on z/OS v10
Resolving The Problem
There is a missing drop tablespace statement that's causing this issue.
Change the content of drop_zos_partitioned_tables.sql as follow:
drop view V_CD_STATS_LOG
drop view V_CE_STATS_LOG
drop tablespace %db%.TSEV
drop table EVENTS
drop table EVENTS_OLD
drop tablespace %db%.TSEX
drop table EVENTS_EXT
drop table EVENTS_EXT_OLD
drop tablespace %db%.TSCD
drop table CD_STATS_LOG
drop table CD_STATS_LOG_OLD
drop tablespace %db%.TSCE
drop table CE_STATS_LOG
drop table CE_STATS_LOG_OLD
drop table EVENT_TYPE
drop table NODE_TYPE
drop table DISCOVERY_NODE
drop table LICENSES
drop table PAIR_CONN
drop table TIME_MONITORS
drop table META_DATA_LABELS
drop table CCC_INFO
drop tablespace %db%.TSEC
drop table EVENT_COMMENTS
drop table EVENT_COMMENTS_OLD
drop table CONFIG_JOBS
drop table CONFIG_SERVER_IDS
drop table CONFIG_OBJECTS
drop table CONFIG_VERSIONS
drop tablespace %db%.TSAL
drop table AUDIT_LOG
drop table AUDIT_LOG_OLD
drop table FILE_COUNTS
Was this topic helpful?
Document Information
Modified date:
17 December 2019
UID
swg21663498