Interested to Buy Any Domain ? << Click Here >> for more details...
what needs to be done if a table is in copy pending / check
pending status?
- 5 Answers
- 22813 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 |
What is sqlcode -811?
7 Answers Accenture, CTS, TCS,
For Read Stability locks are not applicable for phantoms, What is Phantoms?
Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
How Plan is created while executing the query using SPUFI?
if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)
What is data manager?
what is plan? is plan executable or package?
What is the picture clause of null indicator variable?
When do you specify the isolation level?
When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored?
is it compulsory commitment control in journal?
How to execute stored procedures?
COBOL 
