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.

13 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
  3. Dear, I like all your post. Everything looks so sweet, I admire this kind of life and the best wishes for you. Hope that we can communicate with each other. By the way, anybody want to boost app ranking ? This one is useful.

    ReplyDelete
  4. Informative blog and it was up to the point describing the information very effectively. Thanks to blog author for wonderful and informative post.
    Mobile application developers in Chennai | Android application developers in Chennai | Android app developers Chennai | PHP developers chennai

    ReplyDelete
  5. Bring in a present service bill to demonstrate your habitation. In many cases a permit won't have the most current address. Since service bills are paid every month, you should give the latest one.
    Cash Advance San-diego
    Payday Loans
    Car Title Loans

    ReplyDelete