mardi 30 janvier 2007

Optimisation avec la version 8 DB2 de DB2 z/OS

Bonjour,

Vous trouverez ci-dessous trois présentations sur l'Optimiseur de DB2 pour z/OS, disponibles sur le site web d'IBM :

- Control your own destiny, implementing DB2 for z/OS optimization hints
par Patrick Bossman (IBM SVL)
http://www.ibm.com/support/docview.wss?uid=swg27005489


- Autonomic Optimization in DB2 Version 8 and Beyond
par Terry Purcell (IBM SVL)
http://www.ibm.com/support/docview.wss?uid=swg27004785


- Major Optimization Enhancements in DB2 Version 8
par Terry Purcell (IBM SVL)
http://www.ibm.com/support/docview.wss?uid=swg27004786



Amicalement,

DB2usa.

Libellés : ,


mardi 23 janvier 2007

Asked and Answered : la suite (Robert Catterall)

Bonjour,

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


- Alternatives to Batch Processing
http://www.db2mag.com/qanda/2000q4_db2dba.shtml

- IMS vs. DDF
http://www.db2mag.com/qanda/2001q1_db2dba.shtml

- Can you have too many DB2 package collections?
http://www.db2mag.com/qanda/2001q1_db2dba2.shtml

- How can I refer a global temporary table defined in the calling stored procedure in the called stored procedure?
http://www.db2mag.com/qanda/2001q2_db2dba.shtml

- We are already at the 2G limit for the DBM1 address space and our machine is only an R95. Do you really have the same need to separate data sets by volume as much with the new DASD technologies?
http://www.db2mag.com/qanda/2001q3_db2dba.shtml

- How do I control which schema I want to use when I am using more than one in a program?
http://www.db2mag.com/qanda/2001q1_db2dba3.shtml

- How do you leverage 160 I/O channels in relationship to partitioning?
http://www.db2mag.com/qanda/2001q3_db2dba2.shtml

- You write that there's no good reason to use the simple tablespace. Why not?
http://www.db2mag.com/qanda/2001q3_db2dba3.shtml

- Is there a rhyme, reason, formula, or theory that can be used to determine the optimal number of tablespace partitions and their optimal size?
http://www.db2mag.com/qanda/2001q3_db2dba4.shtml

- Two questions about DB2 accounting reports
http://www.db2mag.com/qanda/2001q3_db2dba5.shtml

- Non-partitioned indexes (NPIs) are making inserts to one of my large tables time consuming. How would you deal with NPIs in this situation?
http://www.db2mag.com/qanda/020218.shtml



Amicalement,

DB2usa.

Libellés : ,


mardi 16 janvier 2007

Technotes IBM DB2 z/OS

Bonjour,

Vous trouverez ci-dessous une série de Technotes sur DB2 pour z/OS disponibles sur le site web d'IBM :

- How to get more extents without a DB2 outage?
http://www.ibm.com/support/docview.wss?uid=swg21051882

- Advantages of using CREATE INDEX with DEFER YES and then REBUILD INDEX?
http://www.ibm.com/support/docview.wss?uid=swg21251608

- What kind of performance enhancement is disabled if the outer join performance enhancement is turned off?
http://www.ibm.com/support/docview.wss?uid=swg21008980

- Empty DBRMLIB member after compiling with Enterprise COBOL using the CoProcessor and DB2 V8
http://www.ibm.com/support/docview.wss?uid=swg21239703

- Access Path Performance Issues
http://www.ibm.com/support/docview.wss?uid=swg21206998

- How can I keep DB2 for z/OS stored procedures address spaces (SPAS) that are managed by Workload Manager (WLM) from taking over the system?
http://www.ibm.com/support/docview.wss?uid=swg21239743

- Using the RELEASE(DEALLOCATE) bind option and one plan
http://www.ibm.com/support/docview.wss?uid=swg21114814

- Nested Stored Procedures
http://www.ibm.com/support/docview.wss?uid=swg21114994


Amicalement,

DB2usa.


mardi 9 janvier 2007

z/Journal (numéro d'octobre-novembre 2006)

Bonjour,

Les articles du numéro octobre-novembre 2006 de z/Journal sont disponibles en ligne :
http://www.zjournal.com


- Top-10 Ways to Waste CPU Using DB2
par Susan Lawson et Daniel Luksetich
http://www.zjournal.com/index.cfm?section=article&aid=711


- To Rebind or Not to Rebind, Is That a Question?
par Craig Mullins
http://www.zjournal.com/index.cfm?section=article&aid=718


- The Laws of Database Administration
par Lockwood Lyon
http://www.zjournal.com/index.cfm?section=article&aid=719


- Managing DB2 Performance in a Multi-Platform Environment
par Jim Wankowski
http://www.zjournal.com/index.cfm?section=article&aid=709


Amicalement,

DB2usa.

Libellés : , , ,