Data integrator web administrator fails to pull batch job status

[Former Member]

We use DB2 v8.1.17.644 with fixpack 17 database for the repository. With fix pack 10 everything worked properly. After the upgrade to fix pack 17 on database server residing on linux operating system and the data integrator server installed on windows 2003 server, it fails. Does anyone have the similar issues or a solution for this problem.

Edited by: Madhu Allani on Oct 17, 2008 7:49 PM

[Former Member]

what is the error message you see on this page? are you running jobs using system configuration ?

is test connection successful for the repository ? are you able to view other data from repository like in Dashboard, Impact lineage etc

you can also check for the errors in webadmin.log file which will be created in %LINK_DIR%/log folder

[Former Member]

The sql going against ALVW_history fails to get the details. Looks like, there are some changes in the DB2 FP17 optimizer. Some sql's with the multiple left joins fails. These sql's were fine. Business objects should re write their view for this service pack or work with IBM to fix their product.

[Former Member]

the issue with ALVW_HISTORY failing for DB2 is fixed in DS XI 3.1

for 11.7 you need to modify the view definition, the problem happens if you are using System configuration to run the Job. the view is failing to convert string to number

search for following in your view definition of ALVW_HISTORY

L.OBJECT_KEY = CAST ( SC.VALUE as numeric)

and replace it with the following, it should work fine after that

CAST (L.OBJECT_KEY as char) = SC.VALUE

[Former Member]

Manoj,

I tried this and no success. DB2 optimizer is not able to resolve the result set prpperly. It has some cardinality issues for the kind of left joins used in the view. Only way, we can resolve is by rewriting the sql of the view using the temp tables.

Thanks for your time.

Madhu

Edited by: Madhu Allani on Oct 27, 2008 7:14 PM