Asked and Answered (Robert Catterall)

Bonjour,

Vous trouverez ci-dessous une première série de "Questions/Réponses" de Robert Catterall sur DB2 pour z/OS parues dans DB2mag :


- When a program contains a static SQL statement that references an unqualified table name, how can you know ...?
http://www.db2mag.com/story/showArticle.jhtml?articleID=191502413

- Where can I find a code snippet for accessing DB2 for z/OS stored procedures in Java using input parameters?
http://www.db2mag.com/story/showArticle.jhtml?articleID=175001334

- What's your recommendation for performing DB2 v.7 traces running under z/OS V1R4 in a production environment?
http://www.db2mag.com/story/showArticle.jhtml?articleID=173403206

- Could you provide some recommendations for conserving disk space on a mainframe?
http://www.db2mag.com/story/showArticle.jhtml?articleID=167100906

- What's the best way to implement stored procedures as the communication mechanism to a mainframe?
http://www.db2mag.com/qanda/050719.shtml

- Do you know of any products that use DRDA without a local DB2 in an MVS (OS/390, Z/OS) environment?
http://www.db2mag.com/qanda/050615.shtml

- How the DBA roles differ between Linux, Unix, and Windows (LUW) and the mainframe?
http://www.db2mag.com/qanda/050315.shtml

- Why does PROGRAM TYPE SUB minimize the number of moduel reloads in in the WLM-managed stored procedures address spaces, and are there any drawbacks to that approach?
http://www.db2mag.com/qanda/041117-2.shtml

- Would the DB2 Governor work as an interim solution that would let us assign higher priority for online requests and lower priority for batch?
http://www.db2mag.com/qanda/041117-3.shtml

- Do you have to use WLM-managed stored procedure execution environments if you want to use one DB2 for z/OS stored procedure program for multiple different schemas in a database — or are there other options?
http://www.db2mag.com/qanda/040817.shtml

- What steps can we take to achieve faster group restart for a four-member data sharing group?
http://www.db2mag.com/qanda/040622.shtml

- Do the DB2 v.7 for z/OS ZPARMS SRTPOOL and MAXRBLK refer to the global respective sort spaces or to the SORT and RID SORT pools for each individual user?
http://www.db2mag.com/qanda/040316.shtml



Amicalement,

DB2usa.