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?

With drop/create you'll get some access paths invalidated. Maybe REBUILD INDEX is a better option.