Skip to Content
0

db2 ALTER TABLE "ADRVP~" APPEND ON 1EETGCLN SQL0270N Function not supported (Reason code = "45")

Nov 12, 2017 at 05:54 AM

79

avatar image
Former Member

Hi Guys. have any of you seen the error below? the DBCLONE jobs successfully finish but the DBCLONE.ELG shows the errors as seen below.

any recommended solution for this issue?

Severe error(s) occurred in phase MAIN_SHDCRE/SUBMOD_SHDDBCLONE/DBCLONE!

Last error code set:
Single errors (code <= 8) found in logfile 'DBCLONE.ELG'

ERROR:
Detected the following errors:

# /usr/sap/QKOPatches/SUM/abap/log/DBCLONE02.QKO:3 ETGCLN ALTER TABLE "ADRVP~" ADD CONSTRAINT "ADRVP^0" PRIMARY KEY ("CLIENT", "PERSNUMBER", "CONSNUMBER")3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'DB6' AND TABNAME = 'ADRVP~' AND INDEXNAME = ' '3 ETGCLN COMMIT3 ETGCLN ALTER TABLE "ADRVP~" LOCKSIZE TABLE3 ETGCLN ALTER TABLE "ADRVP~" APPEND ON1EETGCLN SQL0270N Function not supported (Reason code = "45"). SQLSTATE=429971EETGCLN ADRVP1EETGCLN Error copying table data Regards

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Frank-Martin Haas
Dec 04, 2017 at 10:34 AM
1

Hi,

this is a known bug in SUM which has been fixed with SUM 1.0 SP21 PL4.

SUM did not respect that APPEND mode is not possible on MDC and ITC tables ( as mentioned by Prithviraj ).

Regards

Frank

Share
10 |10000 characters needed characters left characters exceeded
Prithviraj Rajpurohit Nov 13, 2017 at 12:07 PM
0

Hi Miso

Return code 45: APPEND mode is not supported for multidimensional clustering (MDC) tables or insert time clustering (ITC) tables.

Action: Do not specify the APPEND clause in an ALTER TABLE statement for multi-dimensionally clustered (MDC) or insert time clustering (ITC) tables.

Regards,

Prithviraj

Share
10 |10000 characters needed characters left characters exceeded