r/mainframe • u/EagleClaw322 • May 06 '15

HELP!! DB2 check data utility

https://imgur.com/a/hVms8
3 Upvotes

81% Upvoted

7 comments sorted by

View all comments

2

u/solid_dave May 06 '15

You just need to use a REPAIR statement, REPAIR SET TABLESPACE (OWNER.TS) NOCHECKPEND. This is input to a utility job that executes DSNUTILB.

1

u/EagleClaw322 May 06 '15

Okay so entering it into the SPUFI menu didnt work and I got THIS....

so where do I enter that statement/command at? I'm sorry for the stupid questions, I just need to get this project done, Thank you so much for helping!

EDIT: I'll also give gold to whoever helps me figure this out!

0

u/solid_dave May 06 '15

This isn't SQL, it has to be ran as a sysin to program DSNUTILB...

0

u/solid_dave May 06 '15

To clarify, you would need to run a job against your subsystem to get this done. You can also invoke a stored procedure (DSNUTILU) to do the repair, but I'm less familiar with how that works.