what needs to be done if a table is in copy pending / check
pending status?
- 5 Answers
- 21960 Views
- Xansa, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sasi
use repair utility
REPAIR SET TABLESPACE DATABASE.TABLESPACENAME NOCOPYPEND
REPAIR SET TABLESPACE DATABASE.TABLESPACENAME NORCVRPEND
REPAIR SET TABLESPACE DATABASE.TABLESPACENAME NOCHECKPEND
| Is This Answer Correct ? | 17 Yes | 2 No |
Answer / kiran bhamare
Hi,
You can do same by following tric.
STOP database and start it again using DB2 commands.
1)-DIS DATABASE (DATABASENAME) SPACE (TABLESPACENAME)
to dsisplay status of DB
2)-STOP DATABASE (DATABASENAME) SPACE (TABLESPACENAME)
to stop database.
3)-START DATABASE (DATABASENAME) SPACE (TABLESPACENAME) ACC
(FORCE)
to start database.
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / sudipta
first ckeck the ststus of the table by using the query:-
load query table <tab_name>;
load query table <tab_name> set all immidiate unchecked;
after the command execute all pending state will be removed
| Is This Answer Correct ? | 2 Yes | 4 No |
Answer / sudipta
sorry the last answer is
db2= >> set integrity for <table_name> all immediate unchecked
| Is This Answer Correct ? | 2 Yes | 4 No |
Answer / suresh
we need to clear the flags of that particular utilities and
try to load the data into the database.
| Is This Answer Correct ? | 1 Yes | 4 No |
Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2 how will we do this. We can create a single program and a single load for this program.
What does the CHECK Utility do ?
What is the purpose of the WHENEVER statement?
how to identify the pseudo conversation by seeing the program
What are the prerogatives?
How do I add a column to an existing table in db2?
What is null value in db2?
What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?
How to get Top 10 Salaries from a Table
Where is the access path logic created by the DB2 Optimizer stored?
How does a cursor work?
how to fetch first 100 rows in db2
COBOL 
