Interested to Buy Any Domain ? << Click Here >> for more details...
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 syntax for creating a table in the db2 database?
Explain in detail about buffer manager and its functionalities?
What is cursor with hold option in db2?
Outputs of explain are with matchcols = 0. What does this signify?
What are the uses of db2 optimizer?
How to create backup table in db2?
Is schema the same as database?
How do I add a column to a table in db2?
What is the difference between db2 and oracle?
Define declaration generator (dclgen).
Explain the contents that are a part of dclgen.
Differentiate between cs and rr isolation levels? Where do you specify them?
Give the name of some fields form sqlca.
Define buffer pool.
How many databases are there?
