Answer Posted / 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 |
Post New Answer View All Answers
What is the maximum No of rows per page?
What is the use of predicate?
Define check constraint.
What is null indicator in db2?
List out the three types of page locks that can be held.
Mention the different locking levels that are available in db2.
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
What is database reorganization?
what is the sqlcode -501
How to check last update on table in db2?
What is commit in db2?
How can you find out the # of rows updated after an update statement?
What is dbrm? When it will be created?
What is the role of schema in the db2 database?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
