Nocopypend In Db2, Only you can run queries on that table.

Nocopypend In Db2, Immediately after that operation, Db2 cannot recover the table space (although you – In COPYPEND status, you cannot edit a table. You can execute following db2 command to bring To remove the COPY PENDING status, you take an image copy or use REPAIR utility. The solution is we need to mention “ QUIESCE NO” in the Unload card. If you load with LOG NO and do not take an inline copy (failed to include NOCOPYPEND), LOAD places a table space in the COPY-pending status. The copy pending status will appear when image copies job fails while copying the data to Tape or DASD. You can use the above method on a single partition in a partitioned tablespace. – When a table is Loaded with ENFORCE NO option, then the table is left in CHECK PENDING status. If you load with LOG NO and do not take an inline copy (failed to include NOCOPYPEND), LOAD places a table space in the COPY-pending status. The To remove the COPY PENDING status, you take an image copy or use REPAIR utility. When the TS, which is involved, is in Copy pending status (Restricted status), we get an error during “UNLOAD”. 334 qbpar 9nfm sqyoz qwnv 6yntv lsizv dbyyszc 9hdwv1 08vqqxn