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 meant by union and union all?
Why db2 is called db2?
Before you give the explain statement, what are the prerogatives?
On which levels locks can be applied?
What is check constraint. Explain with example.
How do I delete a column in db2?
What is data manager?
How do I import a csv file into db2?
Can we update view in db2?
How can the duplicate values be eliminated from db2 select?
What is the syntax for seeing the columns and data types of a table in the db2 database?
What are bind parameters in db2?
What is the difference between db2 and oracle?
What os does db2 run on?
Who uses db2?
