Answer Posted / mr. cooooool

Hi...............

Use the Following jcl to retrived the Db2 table data.

//SYSREC00 DD DSN=COOL.UNLOAD.SYSREC02,
// UNIT=SYSDA,SPACE=(32760,(1000,500)),DISP=(MOD,CATLG)
//SYSPUNCH DD DSN=COOL.UNLOAD.SYSPUNC1,
// UNIT=SYSDA,SPACE=(800,(15,15)),DISP=(MOD,CATLG)
//SYSIN DD *
SELECT * FROM SYSIBM.SYSTABLES WHERE OWNER = 'COOL123';
/*
//


THANKS

What is runstats utility in db2?

1072

---

What is reorg?

1245

---

How to resolve deadlock issue

20329

---

On which levels locks can be applied?

1207

---

How do you stop a db2 database in linux?

1061

---

What is a bind in db2?

1108

---

What is difference between alias and synonym in db2?

1200

---

What is the physical storage length of time data type?

1181

---

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3637

---

How to find the maximum value in a column in the db2 database?

1132

---

Can you use max on a char column?

1146

---

What is clone table?

1114

---

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

1238

---

What is db2 optimizer?

1316

---

What is with ur in db2?

1385

---