Unanswered: .net to z/os via db2 connect gateway timing out from plan SYSSH200
desktop IBM Data Server Client v9.5 fp3b with .net add ins
DB2 Connect on windows V9.5 fp3b
z/os db2 v8 put 0902
The user is trying to set up a connection between .net and a z/os
database. He gets hit with:
Error 3 An error occurred while executing the command definition. See
the inner exception for details.
ERROR  [IBM][DB2] SQL0905N Unsuccessful execution due to
resource limit being exceeded. Resource name = "ASUTIME", limit =
"000000000102" CPU seconds ("000002000000" service units) derived from
C:\workspace\asp.net\DataAccess\CMS104Model.edmx 0 1 DataAccess
as you can tell, we've bumped his z/os DB2 CPU mark pretty high.
In the DB2 trace, a nasty query is getting ran via package SYSSH200. Is there some sort of configuration that I'm missing either on the Connect server or the client? I would appreciate any help on this.