How do I remove CHECK PENDING state from a DB2 Tablespace on z/OS?
maybe one of you can help me with this DB2 z/OS thingy.
I edited foreign key on a table that was already populated. Due to integrity reasons (I guess) the tablespace was placed in CHECK PENDING and I cannot perform operations on it any longer.
This IBM help page is about the exact problem
It says
Action
Perform the CHECK DATA command: CHECK DATA TABLESPACE DATABASE NAME TABLESPACE NAME
I have no clue, what this means (its no SQL statement thats for sure) or where I can issue the command. Maybe one of you cann tell me what to d开发者_运维知识库o. TIA
As you noted, CHECK DATA is not an SQL command, it is a DB/2 Utility. See: Check Data
精彩评论