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.shtmlRegards,
DB2usa.
Labels: DB2mag, Robert Catterall
