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.

50 comments:

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

    ReplyDelete
  2. 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
  3. 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
  4. That worked for me. Thanks for the fix

    ReplyDelete
  5. All are saying the same thing repeatedly, but in your blog I had a chance to get some useful and unique information, I love your writing style very much, I would like to suggest your blog in my dude circle, so keep on updates.
    Web Designing Course in Chennai with placement
    website design courses
    web designing classes in chennai
    PHP Training Chennai
    PHP Course Chennai
    PHP courses in chennai

    ReplyDelete
  6. Very useful blog thanks for sharing At Pearl’s - The best Bridal Makeup Parlour in Chennai, we take personal responsibility in making sure that you look as flawless and beautiful and the marriage that you have been dreaming of. With around 16,000 successful brides in our books, you can be confident that we know our art intimately and deep.

    ReplyDelete
  7. Ensure for making use of reliable Bitstamp support phone number For your account issues that have taken away night’s sleep and does not allow you to operate the Bitstamp account in the proper manner. Call at the Bitstamp contact phone number and look for the ways to rectify the undue complications. You will be able to join with the Bitstamp experts through the toll free facility and will be able to take best alternates in solving so a lot of Bitstamp connected matters like account settings, password issues, and unwanted error messages. In order to operate Bitstamp account with ease, get linked with the Bitstamp support team now!

    ReplyDelete
  8. There are online courses available on the internet which teaches whole data science technology through video tutorials and theory as well. There would be assignments which you have to complete. machine learning institute in hyderabad

    ReplyDelete
  9. Me gusta mucho tu página en general y este artículo en particular me ha encantado, siento que le dedicas mucho tiempo y que disfrutas lo que haces. mucha suerte!!!

    ReplyDelete
  10. No se si estoy de acuerdo con todo lo que has escrito pero sin ninguna duda lo haces desde el respeto y la educación. Tener puntos de vista distintos a los míos es una oportunidad para poder aprender cosas nuevas. Deseando que subas más contenido. Un saludo!!!

    ReplyDelete
  11. No tenía mucha idea acerca del tema y la verdad es que vuestra información ha sido muy útil e instructiva, he aprendido muchas cosas que podré poner en práctica a partir de ahora. ¡Muchas gracias!

    ReplyDelete
  12. La verdad es que la información es buena y amena, su fácil comprensión me ha atrapado desde el primer momento y ha conseguido que me informe de lo que quería saber. Se nota que estás encantado con lo que haces. =)

    ReplyDelete
  13. No es lo que estaba buscando ahora mismo, pero el post me ha llamado bastante la atención ya que te cuenta cosas interesantes que pueden ser útiles, encima se nota que le has puesto mucho esfuerzo ¡felicidades!

    ReplyDelete
  14. Me parece un artículo súper interesante, además de estar super bien redactado y quedarme todo super claro.
    Gracias

    ReplyDelete
  15. Me parece un artículo súper interesante, además de estar super bien redactado y quedarme todo super claro.
    Gracias

    ReplyDelete
  16. Me encanta el articulo, es super interesante y curioso, se lee genial con mucha fluidez. Estoy deseando leer más artículos vuestros, sois geniales.

    ReplyDelete
  17. Que buen blog tenéis, me encanta leer todos vuestros artículos es de los mejores blog. Además son super útiles y claros.

    ReplyDelete
  18. Es un blog muy interesante, me ha gustado mucho leerlo, ya que puede ser algo de gran utilidad para poner en práctica.

    ReplyDelete
  19. Enhorabuena por el artículo, muy buena redacción, se nota claramente que le pones esfuerzo y ganas.

    ReplyDelete
  20. Muy buen post, gracias por compartir esta información, sin duda seguiré esperando a que subas más contenido.

    ReplyDelete
  21. Muy chulo el artículo, contiene información muy interesante, gracias por tu interés.

    ReplyDelete
  22. Me encanta todo lo que cuentas en el post, es muy interesante y me encantaría que explicaras más sobre el tema.

    ReplyDelete
  23. No es lo que buscaba en estos momentos, pero me he parado a leerlo y me ha interesado más de lo que me esperaba , muchísimas gracias.

    ReplyDelete
  24. Hey Amazing Post!! Thank You So Much For Sharing!!!Wonderful blog.Its really helpful for me, waiting for a new post. Keep Blogging!
    DevOps Training in Chennai

    DevOps Course in Chennai

    ReplyDelete
  25. Your post is really good. It is really helpful for me to improve my knowledge in the right way..
    I got more useful information from this thanks for share this blog
    scope of automation testing
    scope of data science
    how to improve english
    common grammar mistakes
    nodejs interview questions
    pega interview questions

    ReplyDelete
  26. This comment has been removed by the author.

    ReplyDelete
  27. Thanks for the information, for one of my latest projects, Diseño Web Zaragoza, I could have used it. Well, it's up and running in real and the local testing I did in a sloppier way. Thanks anyway

    ReplyDelete
  28. Absolutely great post here. It has a lot of key elements that truly makes it work.Mobilemall Bangladesh

    ReplyDelete
  29. Lucky Club Casino Site | Online Casino | Slots & Live Casino
    Lucky Club Casino is a new luckyclub.live online casino that launched in 2018. We've taken the game to the next level and have made it the ideal fit for players who

    ReplyDelete
  30. Hello guys, “Waking up in India is like waking up to life.” Foreign nationals can come to India and see the beauty of this country.But you don't know how to apply for an India e Visa? You can get Indian tourist visa info via our Indian visas website.

    ReplyDelete