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 diffrence b/w file-aid tool and file-aid utility???
B37 abend during spufi?
What is ibm db2 connect?
What are the bind parameters ibm db2?
What is precompiler in db2?
Are view updateable?
Differentiate between cs and rr isolation levels? Where do you specify them?
What's The Error Code For Unique Index Voilation?
Explain the function of data manager.
Which command is used to connect to a database in DB2 ? Give the Syntax.
Explain about rct.
What is db2 command?
What is the physical storage length of time data type?
How does a cursor work?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?