Interview Questions   Tutorials   Discussions   Programs   

DB2 - What is CHECK PENDING ?




375
views
asked mar August 21, 2014 11:57 AM  

What is CHECK PENDING ?


           

1 Answers



 
answered By Mswami   0  
Table space is in check pending state after adding or editing a foreign key on z/OS only.

Symptom:

When querying or retrieving items or importing new items, the library server returns [LS RC = 7015, SQL RC = -904].

DGL5050A: SQL error executing query. XQPE query: /ITA[@SEMANTICTYPE
BETWEEN 1 AND 2].
Return code: 7015. Reason code: 0. Extended return code: -904. 
Extended reason code: 0.
(STATE) : [LS RC = 7015, SQL RC = -904] 


There is also a warning in the library server log:

< DSNT404I SQLCODE = 162, SQLSTATE = >
ICMPLSCP handleForeignKeys 06174 03/09 06:25:24.457 GMT
;09045111471478 16:10285a68c22:X7ea2 IFVTE WARNING--
Please perform CHECK DATA command on z/OS.

Possible cause:

When adding a foreign key to an existing component type table (ICMUTnnnnnsss), SQLCode 162 is returned. DB2 places a table space into CHECK PENDING state if:

  •     Any table in that table space has ever been populated at any time.
  •     A foreign key is added or modified for any table in the table space.

The library server performs and commits the foreign key creation. However, a warning message is written to the library server log to remind you to run the CHECK DATA DB2 utility so that tables and views in this table space can be accessed.

Action:

Perform the CHECK DATA command: CHECK DATA TABLESPACE DATABASE NAME TABLESPACE. NAME.
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert