Topic
5 replies Latest Post - ‏2012-09-21T13:36:43Z by PMartir
PMartir
PMartir
7 Posts
ACCEPTED ANSWER

Pinned topic DSWC Job Manager History issue

‏2012-09-12T15:29:45Z |
Environment is:
(1) We have some production database servers (Windows Server 2008 64 bit DB2 9.7.5.)
(2) DSWC installed on a separate server (Windows Server 2008 64 bit). DSWC repository database - DB2 9.7.5 on the same server

Data Studio - version 3.1.1
DSWEB Core Services - version 2.4.0.v20120831_1905

When I tried to open the JobManager\History window I received following error in the DS_System.log:

"HistorySQLDataProvider -getJobNameForJobID failure: com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-805, SQLSTATE=51002, SQLERRMC=NULLID.SYSLH21E 0X5359534C564C3031, DRIVER=3.63.81"
Has anyone seen this behaviour and found a solution?
Updated on 2012-09-21T13:36:43Z at 2012-09-21T13:36:43Z by PMartir
  • Sriram_Europa
    Sriram_Europa
    68 Posts
    ACCEPTED ANSWER

    Re: DSWC Job Manager History issue

    ‏2012-09-12T15:47:03Z  in response to PMartir
    Hi

    I believe the root cause for this problem and your other one: http://www.ibm.com/developerworks/forums/thread.jspa?messageID=14886028 is the same.

    It appears that there is some issue accessing the DSWC reposiitory database. You may need to resolve that and perhaps restart the DSWC server before proceeding. Has there been any recent changes to your repository database instance that could give us some clues here ?

    This may help deal with the -805 error
    http://www-01.ibm.com/support/docview.wss?rs=71&context=SSEPGG&q1=KnowledgeCollection&uid=swg21358478&loc=en_US&cs=utf-8&lang=en

    Could you verify if you can run some simple queries against any of the tables here ? For example - SELECT * FROM DSJOBMGR.JOBS;
  • SystemAdmin
    SystemAdmin
    1632 Posts
    ACCEPTED ANSWER

    Re: DSWC Job Manager History issue

    ‏2012-09-12T15:55:32Z  in response to PMartir
    Hi,
    I'm from the Web Console team and another customer found this issue and we do have a solution for it. Pls. let us know if you would like a patch for it or if you wait for the next release coming up within the next few months.

    Dimple
    • PMartir
      PMartir
      7 Posts
      ACCEPTED ANSWER

      Re: DSWC Job Manager History issue

      ‏2012-09-13T14:10:20Z  in response to SystemAdmin
      Hi,

      Thank you for the quick response

      If you have a solution for that issue already e would like a path for it.

      Pavel
      • SystemAdmin
        SystemAdmin
        1632 Posts
        ACCEPTED ANSWER

        Re: DSWC Job Manager History issue

        ‏2012-09-17T04:52:53Z  in response to PMartir
        HI,
        I sent you the patch via email. Pls. let me know if you have further questions after applying the patch.

        Dimple
        • PMartir
          PMartir
          7 Posts
          ACCEPTED ANSWER

          Re: DSWC Job Manager History issue

          ‏2012-09-21T13:36:43Z  in response to SystemAdmin
          Hi,

          DSWC Job Manager History Log page has been working correct for 5 days after the patch has been installed

          Thank you for help