Numéro d'automne 2010 de DB2mag

Bonjour,

Le numéro d'automne 2010 de DB2mag est disponible en ligne :

- DB2mag automne 2010

- Archives de DB2mag (depuis printemps 2009)
- Archives de DB2mag (hiver 1996-printemps 2009)


DB2mag a changé de nom : IBMDatabasemag, puis IBM Data Management magazine.



- Is There Anything zEnterprise Can't Do?
IBM zEnterprise runs your business—any system, any application.
par Dave Beulke

- What's New: DB2 10 for z/OS
Dramatic CPU savings and data availability enhancements, check. But have you seen the new temporal data support?
par Terrie Jacopi

- DB2 Indexes and Query Performance: Part 1
Weigh costs and benefits when considering additional indexes.
par Robert Catterall

- Does the Order of SQL Predicates Matter?
Rearranging WHERE clause predicates may be an exercise in futility.
par Bonnie Baker



Amicalement,

DB2usa.

Numéros de printemps et d'été 2010 de DB2mag

Bonjour,

Les numéro de printemps et d'été 2010 de DB2mag sont disponibles en ligne :

- DB2mag été 2010
- DB2mag printemps 2010

- Archives de DB2mag (depuis printemps 2009)
- Archives de DB2mag (hiver 1996-printemps 2009)


DB2mag a changé de nom : IBMDatabasemag, puis IBM Data Management magazine.

- DB2 10 for z/OS
More details emerge about new features that can slash CPU costs.
par Dave Beulke

- When Data Wears Out Its Welcome
Are cold data records gumming up the performance of your servers?
par Robert Catterall

- Reducing Conversations with DB2 for z/OS: Part 2
More tried-and-true basics and a few new bells and whistles.
par Bonnie Baker


- Maintenance Makes Money
Five ways to cut database costs - just by paying attention.
par Sheryl Larsen

- Real-Life DB2 Superheroes
IBM puts DB2 powers on display at the IDUG conference.
par David Beulke

- You Want to Govern What?
A database guy discovers data governance.
par Robert Catterall

- Reducing Conversations with DB2 for z/OS: Part 3
Different ways of thinking about ordinary things.
par Bonnie Baker


Amicalement,

DB2usa.

Numéro d'hiver 2009 de DB2mag

Bonjour,

Le numéro d'hiver 2009 de DB2mag est disponible en ligne :

- DB2mag hiver 2009 (version digitale : format PDF interactif)
- DB2mag automne 2009 (version digitale : format PDF interactif)
- DB2mag été 2009 (version digitale : format PDF interactif)

- Archives de DB2mag (hiver 1996-printemps 2009)


DB2mag a changé de nom : IBMDatabasemag, puis IBM Data Management magazine.


- Making Humongous Doable
Need to manage a gigantic database? Let DB2 do the heavy lifting.
par Robert Catterall

- The next DB2 for z/OS
First glimpse into the future.
par David Beulke


Amicalement,

DB2usa.

Numéro d'automne 2009 de DB2mag

Bonjour,

Le numéro d'automne 2009 de DB2mag est disponible en ligne :

- DB2mag automne 2009 (version digitale : format PDF interactif)
- DB2mag été 2009 (version digitale : format PDF interactif)

- Archives de DB2mag (hiver 1996-printemps 2009)


DB2mag a changé de nom : IBMDatabasemag, puis IBM Data Management magazine.


- System z Rocks (Again)
Indexing, compression make your applications work faster.
par Robert Catterall

- Top Performance Features in DB2 9 for z/OS
The mainframe isn't dead-in fact, it's turning heads as a data warehouse platform.
par David Beulke

- Reducing Conversations with DB2 for z/OS: Part 1
As Prem Mehra said, "There is no better-performing SQL than the SQL that is not executed.
par Bonnie Baker

- Customizing XML storage in DB2Tailor XML storage to the needs of your application
With DB2 pureXML, DBAs can apply existing skills to manage XML growth and pursue opportunities to learn new XML skills if they choose.
par Matthias Nicola


En savoir plus

- DB2 Data Warehouse Performance, Part 2
Find problem SQL queries and tune them for quicker response.
par Robert Catterall

- DB2 Data Warehouse Performance, Part 1
Translate OLTP-tuning skills into effective performance management for DB2-based business intelligence systems.
par Robert Catterall


Amicalement,

DB2usa.

Numéro d'hiver 2008 de DB2mag

Bonjour,

Le numéro d'hiver 2008 de DB2mag est disponible en ligne : http://ibmdatabasemag.com/db_area/archives/2009/1

Note: DB2mag est devenu IBMDatabasemag.

- DB2 Data Warehouse Performance, Part 1 par Robert Catterall
Translate OLTP-tuning skills into effective performance management for DB2-based business intelligence systems.
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=216300344

- Three Tips for DB2 Java Apps par David Beulke
Keep DB2 performance high by avoiding these common Java oversights.
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=216300333

- DB2 Answers par Bonnie Baker
Compression questions and a sticky DB2 for z/OS SORT mystery are put to rest.
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=216300355

- Now with .NET applications accessing DB2 for z/OS
par Rajesh Sambandhan, Simon Harris et Todd Munk
Compression questions and a sticky DB2 for z/OS SORT mystery are put to rest.
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=216401198


- XML and the Database: A Perspective for the DBA
par Bryan Patterson et Dexiong Terry Zhang
With DB2 pureXML, DBAs can apply existing skills to manage XML growth and pursue opportunities to learn new XML skills if they choose.
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=216402743

- XML Storage Options in DB2 par Conor O'Mahony
How to decide which XML storage option best suits a particular application.
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=216403288


Amicalement,

DB2usa.

Numéro d'automne 2008 de DB2mag

Bonjour,

Le numéro d'automne 2008 de DB2mag est disponible en ligne : http://ibmdatabasemag.com/db_area/archives/2008/4

Note: DB2mag est devenu IBMDatabasemag.

- DB2 Programmers Do Exist par Robert Catterall
And the things they do with DB2 SQL might surprise you.
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=211300260

- DB2 XML and LOB Design par David Beulke
Guidelines for DB2 for z/OS applications.
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=211300322

- The Mystery of DB2 Sorts par Bonnie Baker
Can adding SORT syntax really improve DB2 for z/OS performance?
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=211300275


Amicalement,

DB2usa.

Numéro d'été 2008 de DB2mag

Bonjour,

Le numéro d'été 2008 de DB2mag est disponible en ligne : http://ibmdatabasemag.com/db_area/archives/2008/3

Note: DB2mag est devenu IBMDatabasemag.

- IBM Data Studio pureQuery Runtime for z/OS Performance par Rajesh Sambandhan et Simon Harris
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=208802229

- Get On the Enterprise Service Bus par Robert Catterall
It's no magic bullet, but enterprise service bus technology hits the mark for certain transactions.
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=209900050

- DB2 Leads with Innovation par David Beulke
DB2 for z/OS financial incentive programs open new horizons for data warehousing and other applications.
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=209900069

- The Mystery of DB2 for z/OS Index-only Updates and Deletes par Bonnie Baker
Can a DB2 for z/OS index-only UPDATE or DELETE really be index only?
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=209900061

Amicalement,

DB2usa.

Numéro de printemps 2008 de DB2mag

Bonjour,

Le numéro de printemps 2008 de DB2mag est disponible en ligne : http://ibmdatabasemag.com/db_area/archives/2008/2

Note: DB2mag est devenu IBMDatabasemag.

- Exploring pureXML in DB2 9 for z/OS par Kirsten Larsen et Michael Schwartzbach
http://ibmdatabasemag.com/story/showArticle.jhtml?articleID=207801115

- Can SOA Perform? par Robert Catterall
The answer is yes, but only if you leave old-school application ideas behind.
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=207801123

- Common DB2 Performance Pitfalls par David Beulke
Build your applications right from the start by avoiding these typical missteps.
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=207801294

- The Mystery of the DB2 SIX Lock par Bonnie Baker
The truth behind this enigmatic lock and other DB2 for z/OS stumpers.
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=207801138

Amicalement,

DB2usa.

Numéro d'hiver 2007 de DB2mag

Bonjour,

Le numéro d'hiver 2007 de DB2mag est disponible en ligne :
http://ibmdatabasemag.com/db_area/archives/2008/1

DB2mag devient IBMDatabasemag comme expliqué dans l'article ci-dessous :

- DB2 Magazine is now IBM Database Magazine par Kim Moutsos
http://ibmdatabasemag.com/story/showArticle.jhtml?articleID=206800435


- pureQuery and DB2 9 Shine par David Beulke
pureQuery and DB2 for z/OS provide better performance and developer coding flexibility.
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=206800608


- DB2 DBA: Elevating the DBA Role par Robert Catterall
Is it time to retire the DBA title for one that represents the real work DB2 DBAs do?
http://www.db2mag.com/story/showArticle.jhtml?articleID=202400154


En savoir plus

- Asked and Answered: DB2 for z/OS Buffer Pools and CPU Time
par Robert Catterall


Amicalement,

DB2usa.

Numéro d'automne de DB2Mag

Bonjour,

Le numéro d'automne 2007 de DB2mag est disponible en ligne :
http://www.db2mag.com/db_area/archives/2007/3

- DB2 Makes Being Green Easy par David Beulke
Reusing DB2 resources makes good business--and performance--sense.
http://www.db2mag.com/story/showArticle.jhtml?articleID=202400498

- DB2 DBA: Ultra Availability par Robert Catterall
If you think "never down, don't lose anything" is an impossible goal for DB2, you should think again.
http://www.db2mag.com/story/showArticle.jhtml?articleID=202400154

- DB2 for z/OS Buffer Pools and CPU Time par Robert Catterall
What affect will tuning DB2 for z/OS buffer pools have on CPU time?
http://www.db2mag.com/story/showArticle.jhtml?articleID=202400447

- Optimistic Locking, Part 2 par Bonnie Baker
When it comes to DB2 for z/OS locks, a pessimistic approach rarely pays.
http://www.db2mag.com/story/showArticle.jhtml?articleID=202400443


Amicalement,

DB2usa.

Numéro d'été 2007 de DB2mag

Bonjour,

Le numéro d'été 2007 de DB2mag est disponible en ligne : http://www.db2mag.com/db_area/archives/2007/2

- Locking Up DB2 Performance par David Beulke
A new locking feature in DB2 9 for z/OS improves the performance outlook.
http://www.db2mag.com/story/showArticle.jhtml?articleID=201200471

- News from the Client Side par Robert Catterall
Application developers love Python, Perl, PHP, and Ruby. DB2 is ready to support them -- are you?
http://www.db2mag.com/story/showArticle.jhtml?articleID=201200804

- Optimistic Locking, Part 1 par Bonnie Baker
An improvement to this age-old DB2 for z/OS concept helps programmers who look on the bright side.
http://www.db2mag.com/story/showArticle.jhtml?articleID=201201095


En savoir plus :
- What's New in DB2 UDB for z/OS Locking and Concurrency par Jim Teng

- Redbook Locking in DB2 for MVS/ESA Environment


Amicalement,

DB2usa.

Numéro de printemps 2007 de DB2mag

Bonjour,

Le numéro de printemps 2007 de DB2mag est disponible en ligne : http://www.db2mag.com/db_area/archives/2007/1

- Boosting DB2 9 for z/OS Performance par David Beulke
New features produce dramatic application results.
http://www.db2mag.com/story/showArticle.jhtml?articleID=199201845

- What DB2 Means to Business Value par Robert Catterall
Talk DB2 in business terms the suits can understand.
http://www.db2mag.com/story/showArticle.jhtml?articleID=199201819

- Extreme SQL Performance Techniques for DB2 par Sheryl Larsen
Use the right tuning technique for your workload to avoid hardware upgrades and optimize DB2 performance.
http://www.db2mag.com/story/showArticle.jhtml?articleID=199903243


Amicalement,

DB2usa.

Asked and Answered : encore (Robert Catterall)

Bonjour,

Vous trouverez ci-dessous une troisième série de "Questions/Réponses" de Robert Catterall sur DB2 pour z/OS parues dans 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



Amicalement,

DB2usa.

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.

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.

Numéro d'hiver de DB2mag

Bonjour,

Le numéro d'hiver 2006 de DB2mag est disponible en ligne : http://www.db2mag.com/db_area/archives/2006/q4


- DB2 9 for z/OS Roars to Life par Craig Mullins :
The mainframe DB2 data server revs up its new hybrid XML/relational engine. Security enhancements, SQL upgrades, and performance improvements complete the package.
http://www.db2mag.com/story/showArticle.jhtml?articleID=193105300

- REBIND Magic with V8 par Bonnie Baker :
It takes some time and some nerve, but it’s worth it.
http://www.db2mag.com/story/showArticle.jhtml?articleID=193105270

- Understanding XML par Robert Catterall :
Your company is probably already using it. It’s time to figure out how to manage it.
http://www.db2mag.com/story/showArticle.jhtml?articleID=193105313

- Asked & Answered par Uri Lifshitz :
In a DB2 for z/OS system that comprises tens of thousands of tables (and even more indexes), how can I find out which database tables require maintenance without running a lot of reports?
http://www.db2mag.com/story/showArticle.jhtml?articleID=193105316


Amicalement,

DB2usa.

Numéro d'automne de DB2Mag

Bonjour,

Le numéro d'automne 2006 de DB2mag est disponible en ligne : http://www.db2mag.com/db_area/archives/2006/q3


- Table Spaces and Locking Levels, Part 3 par Bonnie Baker :
Successful sharing ... with a little help from DSNZPARMs
http://www.db2mag.com/story/showArticle.jhtml;?articleID=191502647

- Parlez-vous SOA? par Robert Catterall :
Master some SOA fundamentals, connect with your architecture colleagues, and then get building
http://www.db2mag.com/story/showArticle.jhtml;?articleID=191502499

- Asked & Answered par Robert Catterall :
When a program contains a static SQL statement that references an unqualified table name, how can you know which table will be accessed when your database includes several different tables (same structure, different data) that have the same unqualified name but different high-level qualifiers (such as different table owner IDs)?
http://www.db2mag.com/story/showArticle.jhtml?articleID=191502413


Amicalement,

DB2usa.

Numéro d'été de DB2mag

Bonjour,

Le numéro d'été 2006 de DB2mag est disponible en ligne : http://www.db2mag.com/db_area/archives/2006/q2


- Table Spaces and Locking Levels, Part 2 par Bonnie Baker :
How locks help friendly readers and not-so-friendly writers get along
http://www.db2mag.com/story/showArticle.jhtml?articleID=186700012

- By Any Other Name par Robert Catterall :
Call it a legacy system or a data server, the mainframe still generates heat. And we're not talking about degrees
http://www.db2mag.com/story/showArticle.jhtml?articleID=186500757

- Asked & Answered par Robert Catterall :
We're implementing a Web services-based application that uses the Distributed Data Facility (DDF). Initial monitoring analysis shows very high CPU enclave consumption, which limits the number of users we can support without degrading the performance of other critical online applications. IBM recommended caching dynamic SQL statements, but that approach didn't provide enough relief to support the number of users required. What else can we try to reduce the impact of DDF enclave CPU activity?
http://www.db2mag.com/story/showArticle.jhtml?articleID=186500716


Amicalement,

DB2usa.

Numéro de printemps de DB2mag

Bonjour,

Le numéro de printemps 2006 de DB2mag est disponible en ligne : http://www.db2mag.com/db_area/archives/2006/q1

- Fetching New Features par Willie Favero
(New multirow processing capabilities let FETCH and INSERT use arrays) :
http://www.db2mag.com/story/showArticle.jhtml;?articleID=180206476


- Staying Power part 2 par Robert Catterall
(New disaster recovery options get you back online fast, with little or no data loss) :
http://www.db2mag.com/story/showArticle.jhtml;?articleID=180206432


Amicalement,

DB2usa.

Numéro d'hiver 2005 de DB2mag

Bonjour,

Le numéro d'hiver 2005 de DB2mag est disponible en ligne :
http://www.db2mag.com/db_area/archives/2005/q4


- The Mainframe DBA Exam par Howard Fosdick
(How to become a certified DBA for DB2 UDB for z/OS) :
http://www.db2mag.com/story/showArticle.jhtml?articleID=173403228

- Manage, Don't Tune par Sanjeev, Saurabhi and Siddharth Singh
(Managing application performance is more efficient and effective than most tuning efforts) :
http://www.db2mag.com/story/showArticle.jhtml?articleID=173500378

- Staying Power par Robert Catterall
(Preparing for the worst is the best way to ensure availability ) :
http://www.db2mag.com/story/showArticle.jhtml?articleID=173403264

- Asked & Answered par Robert Catterall
(What's your recommendation for performing DB2 V7 traces) :
http://www.db2mag.com/story/showArticle.jhtml?articleID=173403206


Amicalement,

DB2usa.