What is IMAGECOPY ?

Answers were Sorted based on User's Feedback



What is IMAGECOPY ?..

Answer / guest

Image copy is used to take the back up of the table after a
bulk update or insert. this can be used during recovery.
not sure if its a utility or function.

Is This Answer Correct ?    29 Yes 0 No

What is IMAGECOPY ?..

Answer / swetha dasari

it is a utility

Is This Answer Correct ?    14 Yes 1 No

What is IMAGECOPY ?..

Answer / samir kumar sahoo

It is a utility by using of which we can take the back up
of the tablespace after bulk update or insert operations.
it is generally used for recovery process.

Is This Answer Correct ?    15 Yes 3 No

What is IMAGECOPY ?..

Answer / prashanth

We Can take the imagecopy of tablespaces as well. we can do
so by using COPY Utility.

Is This Answer Correct ?    12 Yes 2 No

What is IMAGECOPY ?..

Answer / srinivasa yadav

WHEN LOADING LARGE AMOUNT OF DATA INTO DB2 TABLE AND AGAIN
TRYING TO LOAD THE DATA THEN THE TABLE SPACE WILL GO IN TO
THE COPY PENDING STATUS.
IT WILL ARISE AN ABEND -904
-904 :- RESOURCE UNAVAILABLE
TO RESOLVE:- AFTER LOADING THE DATA NEED TO TAKE IMAGE COPY
AND AGAIN TRY TO LOAD THE DATA.
IMAGE COPY:- IT IS USED TO TAKE BACK UP OF DATA.
//SYSTIN DD *
COPY AAAGENDB.AAAGENTS
INTO DSN=ALL70.POL_SIMP.BASE(+1)
/*
//

Is This Answer Correct ?    8 Yes 3 No

What is IMAGECOPY ?..

Answer / thiruvenkata varaga moorthy

After a Bulk Load of the Table or Table Space by means of a
DB2 Load Utility, we need to go for an Image Copy so as to
restore the system in case of some unexpected situations.

Generally, DB2 system itself will expect such an imagecopy
and will prompt the message in the output saying 'Image
Copy Required', 'Table Space Remains in Copy Pending State'.

It is upto the wish of the programmer either to go for an
Image Copy or to cancel the Copy Pend state by means of the
Repair set.

Is This Answer Correct ?    8 Yes 4 No

Post New Answer

More DB2 Interview Questions

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,


What are the two types of logging in the db2 database? Explain them.

0 Answers  


What is the difference between Primary key and unique index?

6 Answers  


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

5 Answers   Xansa,


What is cobol db2?

0 Answers  






What is lock escalation?

2 Answers  


How can you get the number of rows impacted by the last executed query?

1 Answers  


What is a subselect? Is it different from a nested select?

1 Answers  


What is the specific need of Plan and..where are the tables in DB2 are physically saved

3 Answers   Infosys,


File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

0 Answers   Infosys,


What is dbrm in db2 database?

0 Answers  


What is dbrm?

0 Answers  


Categories