Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


what needs to be done if a table is in copy pending / check
pending status?

Answers were Sorted based on User's Feedback



what needs to be done if a table is in copy pending / check pending status?..

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

what needs to be done if a table is in copy pending / check pending status?..

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

what needs to be done if a table is in copy pending / check pending status?..

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

what needs to be done if a table is in copy pending / check pending status?..

Answer / sudipta

sorry the last answer is

db2= >> set integrity for <table_name> all immediate unchecked

Is This Answer Correct ?    2 Yes 4 No

what needs to be done if a table is in copy pending / check pending status?..

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

Post New Answer



More DB2 Interview Questions

1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).

1 Answers  


What is index cardinality?

3 Answers  


Hi All, In a Cobol-DB2 program, I am fetching rows from 4 tables using cursor and then based on the a field present in that table, It processes the information accordingly..for example stat-c is one digit field..if stat-c is 'D' then the a row is deleted from table and written those details in to a file. If the stat-c is 'U' then a row is updated (hardcoded what to update)in a table and written those details in to a file. If the stat-c is 'I' then a row is inserted in a table and written those details in to two files. The issue is i have to include the intermediate commits. When an abend occurs, due to commit statement db2 tables will be saved, But there will be lose of file contents. When we resubmitting the job associated with this program there will be insert ,update and delete anomolies to avoid that what measures could be taken?. The intermediate commit is nothing but issuing commit after massive inserts, updates and deletes(sum of 500actions)

1 Answers  


how to u check the query is executing or not ?where will u check for sqlcode ?

6 Answers   Infosys,


what is the use of commit ? and what is the syntax?

2 Answers   Deloitte,






What is load utility in db2?

0 Answers  


DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

0 Answers  


Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?

2 Answers   L&T, UST,


How can tablespace be moved to another dasd volume that is allocated for that tablespace?

0 Answers  


What are the rules for db2 programming?

0 Answers  


How to retrieve rows from a db2 table in embedded sql?

0 Answers  


How does DB2 store NULL physically?

2 Answers  






Categories