Hi all:

Pedro Miguel, I hope your problem is resolved with Mick's comments. So, I recommend you be care full with
stand alone utilities and commands like REPAIR or ACCESS FORCE, all can damage DB2 VSAM's
when not end correctly.

Salutations
Ramiro López G.
México

-----Mensaje original-----
De: mick.[Email Address Removed] [mailto:mick.[Email Address Removed] el: Lunes 12 de Abril de 2004 11:02 AM
Para:
Asunto: RE: WHAT DBXX.DSNDBC.FRNXXX1.AVTUTSIX.I0001.A001 ???


The parameter INDEX implies you want to run RUNSTATS on the indexes, so
I guess you have an index named AVTUTSIX and an associated indexspace. The
problem is that the associated VSAM dataset doesnt exist, hence the failure.
Try REBUILD INDEX and then rerun the RUNSTATS.

Mick

>-- Original Message --
>Subject: WHAT DBXX.DSNDBC.FRNXXX1.AVTUTSIX.I0001.A001 ???
>Date: Mon, 12 Apr 2004 15:53:05 +0100
>From: Pedro Miguel Gonçalves <[Email Address Removed] <[Email Address Removed]
>Hi guys,
>
>Here's what... I'm running DB2 for OS/390 v.7
>
>I'm trying to run some stats on this tablespace with these parameters:
>
>RUNSTATS TABLESPACE FRNXXX1.AVTUTSTS TABLE INDEX
>
>the message i keep getting is:
>
>DSNUGBAC - RESOURCE UNAVAILABLE
> REASON 00D70024
> TYPE 00000220
> NAME DBXX.DSNDBC.FRNXXX1.AVTUTSIX.I0001.A001
>
>1. I don't have any tablespace or table AVTUTSIX defined, so why is DB2
trying
>to get this VSAM?
>
>
>I can´t see why is this happening, any suggestions?
>
>Thanks in advance.
>
>Pedro Gonçalves.
>

Mick Norman

0032 495 927 652





__________________________________________________
Broadband from an unbeatable £15.99!

http://www.tiscali.co.uk/products/broadband/home.html?code=SM-NL-11AM




---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: db2udbdba-[Email Address Removed] additional commands, e-mail: db2udbdba-[Email Address Removed]DB2 & UDB email list listserv db2-l LazyDBA home page