Re: -911 fetching from a declared GTT.

2005-11-09 Thread Shane Ginnane
As Peter intimates, the cycle time seems to be outside the toleration of the application. RESMIL is an obvious place to start, maybe look at ACCELSYS as another option. Good discussions in the GRS Planning manual - see the Install and tuning and Diagnosing chapters under Ring mode. Be aware that

Re: -911 fetching from a declared GTT.

2005-11-08 Thread Peter Vander Woude
Steve, You might want to take a look RESMIL value in the GRS config. If you went with the default config parm, that value would be RESMIL(10). Although we don't run DB2 here, we did see a performance improvement when we lowered this value to RESMIL(1). If you're able, take a look at GRS

-911 fetching from a declared GTT.

2005-11-07 Thread Steve Grimes
Hello, z/OS 1.4, DB2 1.7 here! We implemented a GRS (ring mode) last weekend and are seeing some interesting performance behaviours. One thing however, that I don't recall seeing before is the following abend: DC6PRAIQ - DSNT408I SQLCODE = -911, ERROR: THE CURRENT UNIT OF WORK HAS BEEN