Asked and Answered (Robert Catterall) part 3

Hi DB2 user,

Here is a third set of Robert Catterall's Asked and Answered about DB2 for z/OS, published in DB2mag:


- Do you use STOGROUPS in conjunction with SMS?
http://www.db2mag.com/qanda/040120.shtml

- Can you define DB2 catalog and directory data sets to be under SMS control?
http://www.db2mag.com/qanda/031117.shtml

- How do I determine whether or not stored procedures marked as STAY RESIDENT are actually reloading?
http://www.db2mag.com/qanda/031103.shtml

- Can the Distributed Data Facility handle a project that uses dynamic SQL and produces 3,000,000 logs daily with 1,000 concurrent users?
http://www.db2mag.com/qanda/030923.shtml

- What are the maximum limits for segmented and partitioned tablespaces and, how can I convert a nonpartitioned tablespace to a partitioned one without a down time window?
http://www.db2mag.com/qanda/030819a.shtml

- With DB2 Query Parallelism, I've heard that you shouldn't set MAX DEGREE greater than the number of CPs. I don't agree, but I wonder whether setting MAX DEGREE high will have an adverse effect on other users. Any advice?
http://www.db2mag.com/qanda/030819c.shtml

- How do you generate random numbers in DB2?
http://www.db2mag.com/qanda/030722a.shtml

- I have a good understanding of DB2 as an application programmer, but I'm not up on the latest with UDB. Can you suggest a good book that will bring me up to date?
http://www.db2mag.com/qanda/030620a.shtml

- Do you know of any way to detect unused indexes in DB2 (for z/OS and OS/390)? Are there tools or techniques to facilitate identification of such indexes?
http://www.db2mag.com/qanda/030620b.shtml

- Why do 4GB DB2 objects max out at 5,826 cylinders of 3390 storage?
http://www.db2mag.com/qanda/030515.shtml

- Does DASD striping work with DB2 for z/OS and OS/390?
http://www.db2mag.com/qanda/030219.shtml




Regards,

DB2usa.