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.
Posted by at
Labels: , , ,

16 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

  10. 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

  11. 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

  13. 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

  14. This can be clarified in a circumstance where the borrower just got a sum that is 10% of the real cost of the auto. In any case, if the borrower won't have the capacity to pay off the lent sum, the bank can even now take the auto.

    ReplyDelete

  15. myTectra Placement Portal is a Web based portal brings Potentials Employers and myTectra Candidates on a common platform for placement assistance

    ReplyDelete

  16. That worked for me. Thanks for the fix

    ReplyDelete

Subscribe to: Post Comments (Atom)