1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l February 2004, week 5
2 67 13_Batch program12_Warren Homer17_whomer@CSC.COM.AU30_Mon, 1 Mar 2004 08:38:26 +1000392_us-ascii Hi,<br><br>Does anyone have any suggestions for this problem: We have a batch program that has been bound 3 times in recent months and following each occasion the CPU time has increased markedly. 17th Nov CPU times following this bind are around 10 minutes 9th Jan CPU times following this bind are around 30 minutes 1st Feb CPU times following this bind are around 60 minutes! [...]
70 157 17_Re: Batch program9_Agus Kwee13_askwe@ATT.NET31_Sun, 29 Feb 2004 18:58:28 -0500440_iso-8859-1 Warren,<br><br>You must have made the assessment that the access path has not change across the 3 binds from the EXPLAIN outputs in the PLAN_TABLE. Did you also have DSN_STATEMNT_TABLE so that you can compare the DB2 estimated processor costs in milliseconds and service units across the 3 binds? The EXPLAIN outputs to this second table probably can give you additional information that is not provided in the PLAN_TABLE . [...]
228 45 34_Resource Unavailable with 00C200E210_Ravi Reddy20_ravi.reddy@PS.GE.COM31_Sun, 29 Feb 2004 20:58:24 -0500440_ISO-8859-1 Hi All,<br><br>One of our batch jobs failed with<br><br>DSNU050I DSNUGUTC - RUNSTATS TABLESPACE xxx.xxxx TABLE(ALL) INDEX(AL DSNT500I DSNUGBAC - RESOURCE UNAVAILABLE REASON 00C200E2 TYPE 00000220 NAME xxx.DSNDBC.xx.xxxx.I0001.A001 DSNU017I DSNUGBAC - UTILITY DATA BASE SERVICES MEMORY EXECUTION ABENDED,<br><br>This job does REORG on tablespaces, starts the Tablespaces with access(RW) and runs RUNSTATS on the tablespaces. [...]
274 239 30_Re: Performance issue at all ?16_Raquel Rodriguez28_raquel_rodriguezus@YAHOO.COM31_Sun, 29 Feb 2004 19:51:54 -0800327_us-ascii Thank you Richard Simpson, Joel Goldstein and Venkat Srinivasan for your very valuable inputs. I don't have much expertise (read 'none') in the DB2 accounting analysis but we have Omegamon (both for DB2 and CICS) installed here. All of you esteemed listers recommend concentrating upon Class 2 and Class 3 times. [...]
514 74 38_Re: Resource Unavailable with 00C200E213_David S Waugh16_dsw-dba@JUNO.COM28_Mon, 1 Mar 2004 05:01:52 GMT568_- Ravi: Check out this APAR - it has very similar symptoms to what you've reported...<br><br>Item OW39930<br><br>APAR Identifier ...... OW39930 Last Changed ........ 00/02/02 DATA SET NAME NOT DEQUEUED AFTER DYNAMIC UNALLOCATION DURING JOB STEP: DEQUEUED AT JOB TERMINATION. [Snip] For DB2 DSNT500I with S04E rc00C200E2 received for a tablespace. This was for the SYSSTR data set. Although any table space could be affected, these are VSAM linear datasets. rc=00C200E2 00C200E2 rc00C200E2 ABEND04E DSNBIOST OPEN . Level 2: See also PDDB item BDC000016069. [Snip] [...]