(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?
This topic has been locked.
5 replies Latest Post - 2012-09-21T13:36:43Z by PMartir
Pinned topic DSWC Job Manager History issue
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-09-21T13:36:43Z at 2012-09-21T13:36:43Z by PMartir
Sriram_Europa 120000KBXK68 PostsACCEPTED ANSWER
Re: DSWC Job Manager History issue2012-09-12T15:47:03Z in response to PMartirHi
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
Could you verify if you can run some simple queries against any of the tables here ? For example - SELECT * FROM DSJOBMGR.JOBS;
SystemAdmin 110000D4XK1632 PostsACCEPTED ANSWER
Re: DSWC Job Manager History issue2012-09-12T15:55:32Z in response to PMartirHi,
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.
SystemAdmin 110000D4XK1632 Posts