Note: The Status RW (READ/WRITE) means that the database is ready to do database processing. You can execute the following query (This command will restart the tablespace and reset all the pending states on the tablespace and the table will be back in RW (read write mode). Run the Check data for those tablespace and the Tablespace status changes from CHKP to RW.ģ. REPAIR SET TABLESPACE dbname.tsname NOCHECKPENDĢ. START DATABASE(dbname) SPACE(tablespace-name) ACESS(FORCE) Execute following db2 command to bring the status of tablespace to RW The teaching of the effective use of monitoring and tuning tools is an integral part of all tuning topics throughout the course. Run the Dummy image copy job and the Tablespace status changes from copy pending to RWģ. ZCubeds Db2 for z/OS: Monitoring & Tuning Application Performance 3-Day class examines and explains the critical factors that affect Db2 for z/OS performance. REPAIR SET TABLESPACE dbname.tsname NOCOPYPENDĢ. you can edit or load table by giving ENFORCE NO option During the program access, when RI violation encounters the database it immediately put in CHKP status – The check pending status will appear when Referential Integrity(RI) violation between data in parent table with child table. It means that the LOAD utility did not perform constraint checking. CHECK utility needs to be run on table space.If table is loaded with LOG NO option then it gets into cpoy pending status. – When a table is Loaded with ENFORCE NO option, then the table is left in CHECK PENDING status. – In COPYPEND status, you cannot edit a table. – A state in which, an Image Copy on a table needs to be taken – The copy pending status will appear when image copies job fails while copying the data to Tape or DASD. – If you load with LOG NO and do not take an inline copy, LOAD places a table space in the COPY-pending status.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |