Page 1 of 1

Error while running RUNSTATS, need help

PostPosted: Thu Aug 13, 2009 9:17 am
by hayt.main
I got the following error while running my RUNSTATS.

DSNT500I 224 08:24:17.14 DSNUGBAC - RESOURCE UNAVAILABLE
REASON 00D70014
TYPE 00000220
NAME DBWC.DSNDBC.DSNDB06.DSNHEX01.I0001.A001
-DSNU017I 224 08:24:17.14 DSNUGBAC - UTILITY DATA BASE SERVICES MEMORY EXECUTION ABENDED, REASON=X'00E40206'
CAUSE=X'00D70014'


Someone pls help me

Re: Error while running RUNSTATS, need help

PostPosted: Thu Aug 13, 2009 11:54 am
by expat
What do the error messages tell you
(a) Directly in text format
(b) When you look up the message codes in the relevant manual

Re: Error while running RUNSTATS, need help

PostPosted: Thu Aug 13, 2009 12:53 pm
by GuyC
DSNHEX01 is a index in the catalog (DSNDB06) on SYSIBM.SYSCOLUMNS_HIST

REASON 00D70014 tell you : "An attempt to extend a data set failed"

So probably :
You run runstats with History and have too many data in SYSIBM.SYSCOLUMNS_HIST

Possible actions (Leave up to the DBA because these are manipulations on the DB2 catalog so possible dangerous)
- Enlarge space
or
- cleanup your history (& Reorg DSNDB06.SYSHIST )