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 does db2 plan contain?

1019

---

What is the maximum size of a char data type in db2?

1010

---

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

1183

---

Which isolation level provides maximum concurrency?

1150

---

What is the use of runstats in db2?

1102

---

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1233

---

What is the maximum number of columns in a db2 table?

1279

---

What are the full forms of spufi and dclgen and why are they used?

1085

---

What are the two types of logging in the db2 database? Explain them.

1071

---

Mention some fields that are a part of sqlca.

1015

---

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1273

---

Outputs of explain are with matchcols = 0. What does this signify?

1051

---

Name the lockable units in DB2?

1126

---

What is db2? Explain.

1039

---

Can there be more than one cursor open for any program?

1165

---