Results 1 to 3 of 3

Thread: Sql6555n

  1. #1
    Join Date
    Sep 2015
    Posts
    1

    Unanswered: Sql6555n

    Hi Folks,
    We have SAS and ETL processes running on the same DB/server. We see the SAS process could not update a table that supposed to be. And our ETL job writes data into FF which is loaded to DB through the Load Utility. We see this script is failing as well.
    The error message we get is the SQL 6555N Load Utility Communication Error.

    We have some ETL jobs that does INSERT to table. We see they run successfully.

    My questions are:
    1) What are the possible reasons for this issue?
    2) Google says it is because of concurrent job load. We had multiple processes running at the same time. But thats how we usually do. Can we confirm by any way that the issue is because of concurrent loads? If Yes, How?
    3)What is the way to recover? Now we could not do any load activity say Delete/ Load to the DB
    4)Any suggestions/ workarounds/ best practices? Pls do share!

    Thanks!!

  2. #2
    Join Date
    Apr 2012
    Posts
    1,035
    Provided Answers: 18
    Few facts in your post , learn how to get help by giving all relevant facts with your questions. The answers can depend on these facts.

    DB2-server version? DB2-fixpack?
    Operating-system version details for the DB2 server?
    Messages in the DB2 dbdiag file(s) relating to the loads?
    Specifically what is the nature (exact error details) of the communications issue.


    Have you understood the communications between the program performing the LOAD action and the DB2-server? Have you checked the operating system and network log/error files?

  3. #3
    Join Date
    May 2012
    Location
    Canberra, Australia
    Posts
    176
    Provided Answers: 6
    As Mor said, more info needed.
    Is this a partitioned database? What error did the SAS task get when updating the table? etc etc
    Andy

    "All parts should go together without forcing. You must remember that the parts you are reassembling were disassembled by you. Therefore, if you can’t get them together again, there must be a reason. By all means, do not use hammer.” — IBM maintenance manual, 1975 "

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •