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)
/*
//

Why do we bind in db2?

1195

---

What happens in bind step in a db2 program?

956

---

What is copy pending status in db2?

1102

---

Explain package in db2 and its advantages?

1188

---

Is db2 a programming language?

1029

---

What is meant by explain?

1113

---

How can deadlocks be resolved?

924

---

What is the meaning concurrency in the db2 database?

1095

---

My sql statement select avg(salary) from emp yields inaccurate results. Why?

1076

---

What is the maximum size of varchar data type in db2?

1115

---

What is universal database?

1053

---

What does sqlcabc has?

1030

---

What is the use of reorg in db2?

1068

---

What is a db2 schema?

1210

---

What is package in cobol db2?

1104

---