开发者

How do I remove CHECK PENDING state from a DB2 Tablespace on z/OS?

开发者 https://www.devze.com 2023-03-31 13:46 出处:网络
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

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

0

精彩评论

暂无评论...
验证码 换一张
取 消