Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 04, 2017 at 10:34 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 13, 2017 at 12:07 PM

    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

    Add comment
    10|10000 characters needed characters exceeded