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

What do you mean by storage group (stogroup)?

1041

---

Why do chiropractors use drop table?

1106

---

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1185

---

How to rename a table in DB2 ?

1088

---

How do I delete a column in db2?

1109

---

What are iseries servers?

1075

---

How to check sequence on a table in db2?

1060

---

What is the use of db2?

1055

---

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

9197

---

What is db2 stogroup?

1160

---

is it compulsory commitment control in journal?

2478

---

Define data page.

1067

---

Is db2 a database?

967

---

Which is faster delete or truncate?

1127

---

In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

1044

---