Error while running RUNSTATS, need help



JES, JES2, JCL utilities, IDCAMS, Compile & Run JCLs, PROCs etc...

Error while running RUNSTATS, need help

Postby hayt.main » Thu Aug 13, 2009 9:17 am

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
hayt.main
 
Posts: 17
Joined: Tue Jul 28, 2009 4:31 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Error while running RUNSTATS, need help

 

Re: Error while running RUNSTATS, need help

Postby expat » Thu Aug 13, 2009 11:54 am

What do the error messages tell you
(a) Directly in text format
(b) When you look up the message codes in the relevant manual
expat
 
Posts: 382
Joined: Sat Jun 09, 2007 3:21 pm
Has thanked: 0 time
Been thanked: 1 time

Re: Error while running RUNSTATS, need help

Postby GuyC » Thu Aug 13, 2009 12:53 pm

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 )
I can explain it to you, but i can not understand it for you.
GuyC
 
Posts: 315
Joined: Tue Aug 11, 2009 3:23 pm
Has thanked: 1 time
Been thanked: 4 times


Return to JCL

 


  • Related topics
    Replies
    Views
    Last post