We are using BO 4.1.3 with DB2/MVS on mainframe.Our gateway is Sybase Direct connect.
The DB2 governer is reduced to 3 minutes of CPU time from 5 minutes recently and the time limit set in BO universe is 25 minutes. Whenever the query either crosses any of the limits we used to get a ‘Partial result’ message in BO.
I have a query which is bringing different number of rows evry time we run and not giving me ‘Partial Result’ message.We monitored this query both in BO and DB2 and found out that at DB2 the query is ending in SQL ERROR CODE -905(Resource limit has been exceeded).
I would like to trap this message and show it in BO so that the user is aware that query hasn’e brought back all the rows.
We are using BO 4.1.3 with DB2/MVS on mainframe.Our gateway is Sybase Direct connect.
BO and DB2 and found out that at DB2 the query is ending in SQL ERROR CODE -905(Resource limit has been exceeded).
I would like to trap this message and show it in BO so that the user is aware that query hasn’e brought back all the rows.
We had a similar issue in the initial stages when we rolled out BO v4.1.3. Then we upgraded our Sybase Direct connect version and also made changes to the CPU limit and I have’nt seen that since.