Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Location
    manila
    Posts
    21

    Exclamation Unanswered: underlying vsam files missing

    Hi all,

    I'm using DB2 ver. 7 for os/390. I encountered a -904 with one of my applications.

    DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE. REASON 00D70024, TYPE OF RESOURE 00000220, AND RESOURCE NAME SDSG.DSNDBC.SGSFDB51.IXSF2526.I00- 01.A001

    The underlying vsam dataset of my index is missing. I just wanna ask if anyone have anyidea how I can do away with it. One solution I see is to restore the missing files. But would it hurt if I performed a drop/create of the index. Would there be any issue if I performed the drop/create?

  2. #2
    Join Date
    Feb 2002
    Location
    Germany
    Posts
    141
    With drop/create you'll get some access paths invalidated. Maybe REBUILD INDEX is a better option.
    Rodney Krick

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •