Interested to Buy Any Domain ? << Click Here >> for more details...
What is IMAGECOPY ?
- 6 Answers
- 39701 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
What is a LIKE table and how is it created?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What are PACKAGES ?
What is package versioning? Please give an example.
What does db2 blu stand for?
Is db2 free?
we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?
What is temporal table in db2?
What are iseries servers?
Explain dclgen.
What are the contents of a dclmgen?
What is a composite index and how does it differ from a multiple index?
COBOL 
