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
How many databases can be created inside an instance in db2 ?
Can you tell me how can you find out the # of rows updated after an update statement?
What is buffer pool and list some of them?
Define data page.
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What is catalog database in db2?
What is the purpose of using commit?
What is the difference between bind and rebind in db2?
How to execute stored procedure in db2 command editor?
Give the name of some fields form sqlca.
What is the difference between drop table and delete table?
Explain about dbrm.
What is the use of value function?
What is cursor stability in db2?
Define db2 and its databases?