Tuesday, January 12, 2016

DB2 SQL Error: SQLCODE=-1476, SQLSTATE=40506, SQLERRMC=-964, DRIVER=4.12.55

While running preprocessing got the following error:

INFO: Error for batch element #1: DB2 SQL Error: SQLCODE=-1476, SQLSTATE=40506,
SQLERRMC=-964, DRIVER=4.12.55

C:\IBM\WCDE_ENT70\bin>di-preprocess.bat C:\IBM\WCDE_ENT70\search\pre-processConf
ig\MC_10001\DB2  -fullbuild true -localename en_US -force true

com.ibm.commerce.foundation.dataimport.preprocess.DataImportPreProcessorMain logExitCode
INFO: The program exiting with exit code: 1.
Data import pre-processing was unsuccessful. An unrecoverable error has occurred

Fix:  DB2 transaction logs are full.

Check the file size ; Goto DB2CMD
set DB2INSTANCE=MALL
db2 get db config for mall
LOGFILSIZ 2048
Ran this command:
db2 UPDATE db cfg for mall using LOGFILSIZ 4096
Windows services DB2 : restart
After this the pre-processing was successful.

8 comments:

  1. Nice..Its informative...Its very useful for me to understand..Keep on sharing..
    Java Training in Chennai

    ReplyDelete


  2. I have been following you for a couple of months now but this is my first time commenting on a blog post. Thank you for sharing your knowledge and experience with us. Keep up the good work. Already bookmarked for future reference.

    SAP training in Chennai

    ReplyDelete