DSNT408I SQLCODE = -646, ERROR: TABLE xxxxx CANNOT BE CREATED IN OR MOVED TO SPECIFIED TABLE SPACE xxxxxx BECAUSE IT ALREADY CONTAINS A TABLE
Article ID: 245524
Updated On:
Products
Issue/Introduction
DSNT408I SQLCODE = -646, ERROR: TABLE xxxxx CANNOT BE CREATED IN OR MOVED TO SPECIFIED TABLE SPACE xxxxxx BECAUSE IT ALREADY CONTAINS A TABLE
Db2 13 only supports one table per tablespace.
The symptom may occur at IBM Db2 V12R1M504 or above
Environment
Compress 5.2 and above
IBM Db2 13+
IBM Db2 V12R1M504 or above
Cause
This is a known decision by IBM and they have documented how to handle the issue in both the Db2 12 and Db2 13
Administration manuals in the section titled Creating non-UTS table spaces (deprecated) discusses how to handle these.
Db2 13 only supports one table per tablespace.
The symptom may occur at IBM Db2 V12R1M504 or above
Resolution
Conversion information can be found in the same manuals in the section Moving tables from multi-table table spaces to partition-by-growth table spaces.
Please see IBM APAR PH18411 for more details related to this concern.
This issue only appears if the DB2 maintenance level is V12R1M504 or above.
Symptoms:
While installing on Db2 13, the install fails with:
DSNT408I SQLCODE = -646, ERROR: TABLE xxxxx CANNOT BE CREATED IN OR MOVED TO SPECIFIED TABLE SPACE xxxxxx BECAUSE IT ALREADY CONTAINS A TABLE
Impact:
The product cannot be installed
Circumvention:
APPLCOMPAT(V12R1M503) parameter added to a BIND PACKAGE resolves the problem.
Original BIND control cards:
DSN SYSTEM(ssid)
* SSA0310 = ISPF & BATCH COMPRESSION ANALYSIS
BIND PLAN(SSA0310) MEMBER( +
SSA0SQL SSA0212 SSA0214 SSA0216 SSA0218 +
SSA0310 SSA0312 SSA0314 SSA0330 SSA0340 +
SSA0350 SSA0355 SSA0356 SSA0370 +
SSA0380 SSA0700 SSA0710 SSA1000 SSA2000 +
SSA2300 SSA2310 SSA2315 SSA2317 SSA2320 +
SSA2330 SSA2340 SSA2360 SSA2370 SSA2375 +
SSA2410 SSA2430 SSA2440 SSA5070 ) +
ACTION(REP) RETAIN VALIDATE(BIND) +
ISOLATION(CS) ACQUIRE(USE) +
RELEASE(COMMIT) EXPLAIN(NO)
* SSA3000 = BATCH PRINT UTILITY
BIND PLAN(SSA3000) MEMBER(SSA3200) +
ACTION(REP) RETAIN VALIDATE(BIND) +
ISOLATION(CS) ACQUIRE(USE) +
RELEASE(COMMIT) EXPLAIN(NO)
* SSA5000 = BATCH DYNAMIC EDITPROC / ADDCOL IMPLEMENTATION UTILITY
BIND PLAN(SSA5000) MEMBER( +
SSA5000 SSA5070 ) +
ACTION(REP) RETAIN VALIDATE(BIND) +
ISOLATION(CS) ACQUIRE(USE) +
RELEASE(COMMIT) EXPLAIN(NO)
END
New BIND statements:
DSN SYSTEM(ssid)
* SSA0310 = ISPF & BATCH COMPRESSION ANALYSIS
BIND PACKAGE(SSA0310) MEMBER(SSA0SQL) +
ACTION(REP) VALIDATE(BIND) +
APPLCOMPAT(V12R1M503) +
ISOLATION(CS) +
LIBRARY ('yourHLQ.CMPDB2.DBRMLIB') +
ENCODING(EBCDIC) +
RELEASE(COMMIT) EXPLAIN(NO)
BIND PACKAGE(SSA0310) MEMBER(SSA0212) +
ACTION(REP) VALIDATE(BIND) +
APPLCOMPAT(V12R1M503) +
ISOLATION(CS) +
LIBRARY ('yourHLQ.CMPDB2.DBRMLIB') +
ENCODING(EBCDIC) +
RELEASE(COMMIT) EXPLAIN(NO)
BIND PACKAGE(SSA0310) MEMBER(SSA0214) +
ACTION(REP) VALIDATE(BIND) +
APPLCOMPAT(V12R1M503) +
ISOLATION(CS) +
LIBRARY ('yourHLQ.CMPDB2.DBRMLIB') +
ENCODING(EBCDIC) +
RELEASE(COMMIT) EXPLAIN(NO)
BIND PACKAGE(SSA0310) MEMBER(SSA0216) +
ACTION(REP) VALIDATE(BIND) +
APPLCOMPAT(V12R1M503) +
ISOLATION(CS) +
LIBRARY ('yourHLQ.CMPDB2.DBRMLIB') +
ENCODING(EBCDIC) +
RELEASE(COMMIT) EXPLAIN(NO)
BIND PACKAGE(SSA0310) MEMBER(SSA0218) +
ACTION(REP) VALIDATE(BIND) +
APPLCOMPAT(V12R1M503) +
ISOLATION(CS) +
LIBRARY ('yourHLQ.CMPDB2.DBRMLIB') +
ENCODING(EBCDIC) +
RELEASE(COMMIT) EXPLAIN(NO)
BIND PACKAGE(SSA0310) MEMBER(SSA0310) +
ACTION(REP) VALIDATE(BIND) +
APPLCOMPAT(V12R1M503) +
ISOLATION(CS) +
LIBRARY ('yourHLQ.CMPDB2.DBRMLIB') +
ENCODING(EBCDIC) +
RELEASE(COMMIT) EXPLAIN(NO)
BIND PACKAGE(SSA0310) MEMBER(SSA0312) +
ACTION(REP) VALIDATE(BIND) +
APPLCOMPAT(V12R1M503) +
ISOLATION(CS) +
LIBRARY ('yourHLQ.CMPDB2.DBRMLIB') +
ENCODING(EBCDIC) +
RELEASE(COMMIT) EXPLAIN(NO)
BIND PACKAGE(SSA0310) MEMBER(SSA0314) +
ACTION(REP) VALIDATE(BIND) +
APPLCOMPAT(V12R1M503) +
ISOLATION(CS) +
LIBRARY ('yourHLQ.CMPDB2.DBRMLIB') +
ENCODING(EBCDIC) +
RELEASE(COMMIT) EXPLAIN(NO)
BIND PACKAGE(SSA0310) MEMBER(SSA0330) +
ACTION(REP) VALIDATE(BIND) +
APPLCOMPAT(V12R1M503) +
ISOLATION(CS) +
LIBRARY ('yourHLQ.CMPDB2.DBRMLIB') +
ENCODING(EBCDIC) +
RELEASE(COMMIT) EXPLAIN(NO)
BIND PACKAGE(SSA0310) MEMBER(SSA0340) +
ACTION(REP) VALIDATE(BIND) +
APPLCOMPAT(V12R1M503) +
ISOLATION(CS) +
LIBRARY ('yourHLQ.CMPDB2.DBRMLIB') +
ENCODING(EBCDIC) +
RELEASE(COMMIT) EXPLAIN(NO)
BIND PACKAGE(SSA0310) MEMBER(SSA0350) +
ACTION(REP) VALIDATE(BIND) +
APPLCOMPAT(V12R1M503) +
ISOLATION(CS) +
LIBRARY ('yourHLQ.CMPDB2.DBRMLIB') +
ENCODING(EBCDIC) +
RELEASE(COMMIT) EXPLAIN(NO)
BIND PACKAGE(SSA0310) MEMBER(SSA0355) +
ACTION(REP) VALIDATE(BIND) +
APPLCOMPAT(V12R1M503) +
ISOLATION(CS) +
LIBRARY ('yourHLQ.CMPDB2.DBRMLIB') +
ENCODING(EBCDIC) +
RELEASE(COMMIT) EXPLAIN(NO)
BIND PACKAGE(SSA0310) MEMBER(SSA0356) +
ACTION(REP) VALIDATE(BIND) +
APPLCOMPAT(V12R1M503) +
ISOLATION(CS) +
LIBRARY ('yourHLQ.CMPDB2.DBRMLIB') +
ENCODING(EBCDIC) +
RELEASE(COMMIT) EXPLAIN(NO)
BIND PACKAGE(SSA0310) MEMBER(SSA0370) +
ACTION(REP) VALIDATE(BIND) +
APPLCOMPAT(V12R1M503) +
ISOLATION(CS) +
LIBRARY ('yourHLQ.CMPDB2.DBRMLIB') +
ENCODING(EBCDIC) +
RELEASE(COMMIT) EXPLAIN(NO)
BIND PACKAGE(SSA0310) MEMBER(SSA0380) +
ACTION(REP) VALIDATE(BIND) +
APPLCOMPAT(V12R1M503) +
ISOLATION(CS) +
LIBRARY ('yourHLQ.CMPDB2.DBRMLIB') +
ENCODING(EBCDIC) +
RELEASE(COMMIT) EXPLAIN(NO)
BIND PACKAGE(SSA0310) MEMBER(SSA0700) +
ACTION(REP) VALIDATE(BIND) +
APPLCOMPAT(V12R1M503) +
ISOLATION(CS) +
LIBRARY ('yourHLQ.CMPDB2.DBRMLIB') +
ENCODING(EBCDIC) +
RELEASE(COMMIT) EXPLAIN(NO)
BIND PACKAGE(SSA0310) MEMBER(SSA0710) +
ACTION(REP) VALIDATE(BIND) +
APPLCOMPAT(V12R1M503) +
ISOLATION(CS) +
LIBRARY ('yourHLQ.CMPDB2.DBRMLIB') +
ENCODING(EBCDIC) +
RELEASE(COMMIT) EXPLAIN(NO)
BIND PACKAGE(SSA0310) MEMBER(SSA1000) +
ACTION(REP) VALIDATE(BIND) +
APPLCOMPAT(V12R1M503) +
ISOLATION(CS) +
LIBRARY ('yourHLQ.CMPDB2.DBRMLIB') +
ENCODING(EBCDIC) +
RELEASE(COMMIT) EXPLAIN(NO)
BIND PACKAGE(SSA0310) MEMBER(SSA2000) +
ACTION(REP) VALIDATE(BIND) +
APPLCOMPAT(V12R1M503) +
ISOLATION(CS) +
LIBRARY ('yourHLQ.CMPDB2.DBRMLIB') +
ENCODING(EBCDIC) +
RELEASE(COMMIT) EXPLAIN(NO)
BIND PACKAGE(SSA0310) MEMBER(SSA2300) +
ACTION(REP) VALIDATE(BIND) +
APPLCOMPAT(V12R1M503) +
ISOLATION(CS) +
LIBRARY ('yourHLQ.CMPDB2.DBRMLIB') +
ENCODING(EBCDIC) +
RELEASE(COMMIT) EXPLAIN(NO)
BIND PACKAGE(SSA0310) MEMBER(SSA2310) +
ACTION(REP) VALIDATE(BIND) +
APPLCOMPAT(V12R1M503) +
ISOLATION(CS) +
LIBRARY ('yourHLQ.CMPDB2.DBRMLIB') +
ENCODING(EBCDIC) +
RELEASE(COMMIT) EXPLAIN(NO)
BIND PACKAGE(SSA0310) MEMBER(SSA2315) +
ACTION(REP) VALIDATE(BIND) +
APPLCOMPAT(V12R1M503) +
ISOLATION(CS) +
LIBRARY ('yourHLQ.CMPDB2.DBRMLIB') +
ENCODING(EBCDIC) +
RELEASE(COMMIT) EXPLAIN(NO)
BIND PACKAGE(SSA0310) MEMBER(SSA2317) +
ACTION(REP) VALIDATE(BIND) +
APPLCOMPAT(V12R1M503) +
ISOLATION(CS) +
LIBRARY ('yourHLQ.CMPDB2.DBRMLIB') +
ENCODING(EBCDIC) +
RELEASE(COMMIT) EXPLAIN(NO)
BIND PACKAGE(SSA0310) MEMBER(SSA2320) +
ACTION(REP) VALIDATE(BIND) +
APPLCOMPAT(V12R1M503) +
ISOLATION(CS) +
LIBRARY ('yourHLQ.CMPDB2.DBRMLIB') +
ENCODING(EBCDIC) +
RELEASE(COMMIT) EXPLAIN(NO)
BIND PACKAGE(SSA0310) MEMBER(SSA2330) +
ACTION(REP) VALIDATE(BIND) +
APPLCOMPAT(V12R1M503) +
ISOLATION(CS) +
LIBRARY ('yourHLQ.CMPDB2.DBRMLIB') +
ENCODING(EBCDIC) +
RELEASE(COMMIT) EXPLAIN(NO)
BIND PACKAGE(SSA0310) MEMBER(SSA2340) +
ACTION(REP) VALIDATE(BIND) +
APPLCOMPAT(V12R1M503) +
ISOLATION(CS) +
LIBRARY ('yourHLQ.CMPDB2.DBRMLIB') +
ENCODING(EBCDIC) +
RELEASE(COMMIT) EXPLAIN(NO)
BIND PACKAGE(SSA0310) MEMBER(SSA2360) +
ACTION(REP) VALIDATE(BIND) +
APPLCOMPAT(V12R1M503) +
ISOLATION(CS) +
LIBRARY ('yourHLQ.CMPDB2.DBRMLIB') +
ENCODING(EBCDIC) +
RELEASE(COMMIT) EXPLAIN(NO)
BIND PACKAGE(SSA0310) MEMBER(SSA2370) +
ACTION(REP) VALIDATE(BIND) +
APPLCOMPAT(V12R1M503) +
ISOLATION(CS) +
LIBRARY ('yourHLQ.CMPDB2.DBRMLIB') +
ENCODING(EBCDIC) +
RELEASE(COMMIT) EXPLAIN(NO)
BIND PACKAGE(SSA0310) MEMBER(SSA2375) +
ACTION(REP) VALIDATE(BIND) +
APPLCOMPAT(V12R1M503) +
ISOLATION(CS) +
LIBRARY ('yourHLQ.CMPDB2.DBRMLIB') +
ENCODING(EBCDIC) +
RELEASE(COMMIT) EXPLAIN(NO)
BIND PACKAGE(SSA0310) MEMBER(SSA2410) +
ACTION(REP) VALIDATE(BIND) +
APPLCOMPAT(V12R1M503) +
ISOLATION(CS) +
LIBRARY ('yourHLQ.CMPDB2.DBRMLIB') +
ENCODING(EBCDIC) +
RELEASE(COMMIT) EXPLAIN(NO)
BIND PACKAGE(SSA0310) MEMBER(SSA2430) +
ACTION(REP) VALIDATE(BIND) +
APPLCOMPAT(V12R1M503) +
ISOLATION(CS) +
LIBRARY ('yourHLQ.CMPDB2.DBRMLIB') +
ENCODING(EBCDIC) +
RELEASE(COMMIT) EXPLAIN(NO)
BIND PACKAGE(SSA0310) MEMBER(SSA2440) +
ACTION(REP) VALIDATE(BIND) +
APPLCOMPAT(V12R1M503) +
ISOLATION(CS) +
LIBRARY ('yourHLQ.CMPDB2.DBRMLIB') +
ENCODING(EBCDIC) +
RELEASE(COMMIT) EXPLAIN(NO)
BIND PACKAGE(SSA0310) MEMBER(SSA5070) +
ACTION(REP) VALIDATE(BIND) +
APPLCOMPAT(V12R1M503) +
ISOLATION(CS) +
LIBRARY ('yourHLQ.CMPDB2.DBRMLIB') +
ENCODING(EBCDIC) +
RELEASE(COMMIT) EXPLAIN(NO)
BIND PLAN(SSA0310) PKLIST(*.SSA0310.*) +
ACTION(REP) RETAIN VALIDATE(BIND) +
ISOLATION(CS) ACQUIRE(USE) +
ENCODING(EBCDIC) +
RELEASE(COMMIT) EXPLAIN(NO) +
CURRENTSERVER(AD15PTIB)
*SSA3000 = BATCH PRINT UTILITY
BIND PACKAGE(SSA3000) MEMBER(SSA3200) +
ACTION(REP) VALIDATE(BIND) +
APPLCOMPAT(V12R1M503) +
ISOLATION(CS) +
LIBRARY ('yourHLQ.CMPDB2.DBRMLIB') +
ENCODING(EBCDIC) +
RELEASE(COMMIT) EXPLAIN(NO)
BIND PLAN(SSA3000) PKLIST(*.SSA3000.*) +
ACTION(REP) RETAIN VALIDATE(BIND) +
ISOLATION(CS) ACQUIRE(USE) +
ENCODING(EBCDIC) +
RELEASE(COMMIT) EXPLAIN(NO) +
CURRENTSERVER(AD15PTIB)
*SSA5000 = BATCH DYNAMIC EDITPROC / ADDCOL IMPLEMENTATION UTILITY
BIND PACKAGE(SSA5000) MEMBER(SSA5000) +
ACTION(REP) VALIDATE(BIND) +
APPLCOMPAT(V12R1M503) +
ISOLATION(CS) +
LIBRARY ('yourHLQ.CMPDB2.DBRMLIB') +
ENCODING(EBCDIC) +
RELEASE(COMMIT) EXPLAIN(NO)
BIND PACKAGE(SSA5000) MEMBER(SSA5070) +
ACTION(REP) VALIDATE(BIND) +
APPLCOMPAT(V12R1M503) +
ISOLATION(CS) +
LIBRARY ('yourHLQ.CMPDB2.DBRMLIB') +
ENCODING(EBCDIC) +
RELEASE(COMMIT) EXPLAIN(NO)
BIND PLAN(SSA5000) PKLIST(*.SSA5000.*) +
ACTION(REP) RETAIN VALIDATE(BIND) +
ISOLATION(CS) ACQUIRE(USE) +
ENCODING(EBCDIC) +
RELEASE(COMMIT) EXPLAIN(NO) +
CURRENTSERVER(AD15PTIB)
END
Feedback
