DB2 - L

Expand all | Collapse all

DB2 Performance Tuning

  • 1.  DB2 Performance Tuning

    Posted Mar 17, 2014 02:48 AM

    Hi Folks,

    One quick question,

     

    Interm of performance tuning, is there any difference between DB2 Z/OS and DB2 LUW environment ?

    Regards,

    Nanthakumar Yoganathan

    +91-9942512341



  • 2.  DB2 Performance Tuning

    Posted Mar 17, 2014 06:08 AM
    Seriously? You mean *apart* from everything?

    Roy Boxwell

    SOFTWARE ENGINEERING GMBH and SEGUS Inc.
    -Product Development-

    Robert-Stolz-Straße 5
    40470 Düsseldorf/Germany
    Tel. +49 (0)211 96149-675
    Fax +49 (0)211 96149-32
    Email: R.Boxwell@seg.de<mailto:R.Boxwell@seg.de>
    http://www.seg.de

    Software Engineering GmbH
    Amtsgericht Düsseldorf, HRB 37894
    Geschäftsführung: Gerhard Schubert

    From: Nanthakumar Yoganathan [mailto:fornanthu@gmail.com]
    Sent: Monday, March 17, 2014 7:48 AM
    To: DB2-L@lists.idug.org
    Subject: [DB2-L] - DB2 Performance Tuning


    Hi Folks,

    One quick question,



    Interm of performance tuning, is there any difference between DB2 Z/OS and DB2 LUW environment ?

    Regards,

    Nanthakumar Yoganathan

    +91-9942512341

    -----End Original Message-----


  • 3.  DB2 Performance Tuning

    Posted Mar 17, 2014 06:09 AM
    Roy, don't be awkward.

    Yes, they're completely different. z/OS is a black box. Who knows what goes on inside it? UDB however is blessed with decades' worth of diagnostic and performance tuning tooling from a variety of vendors.

    Or is that the other way around? ;o)

    Cheers,


    Raymond

    From: Boxwell, Roy [mailto:r.boxwell@seg.de]
    Sent: 17 March 2014 10:08
    To: db2-l@lists.idug.org
    Subject: [DB2-L] - RE: DB2 Performance Tuning

    Seriously? You mean *apart* from everything?

    Roy Boxwell

    SOFTWARE ENGINEERING GMBH and SEGUS Inc.
    -Product Development-

    Robert-Stolz-Straße 5
    40470 Düsseldorf/Germany
    Tel. +49 (0)211 96149-675
    Fax +49 (0)211 96149-32
    Email: R.Boxwell@seg.de<mailto:R.Boxwell@seg.de>
    http://www.seg.de

    Software Engineering GmbH
    Amtsgericht Düsseldorf, HRB 37894
    Geschäftsführung: Gerhard Schubert

    From: Nanthakumar Yoganathan [mailto:fornanthu@gmail.com]
    Sent: Monday, March 17, 2014 7:48 AM
    To: DB2-L@lists.idug.org<mailto:DB2-L@lists.idug.org>
    Subject: [DB2-L] - DB2 Performance Tuning


    Hi Folks,

    One quick question,



    Interm of performance tuning, is there any difference between DB2 Z/OS and DB2 LUW environment ?

    Regards,

    Nanthakumar Yoganathan

    +91-9942512341

    -----End Original Message-----

    -----End Original Message-----


    Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC95000. Telephone: 0131 225 4555. Lloyds Bank plc. Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England and Wales no. 2065. Telephone 0207626 1500. Bank of Scotland plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC327000. Telephone: 08457 21 31 41. Cheltenham & Gloucester plc. Registered Office: Barnett Way, Gloucester GL4 3RL. Registered in England and Wales 2299428. Telephone: 0845 603 1637

    Lloyds Bank plc, Bank of Scotland plc are authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and Prudential Regulation Authority.

    Cheltenham & Gloucester plc is authorised and regulated by the Financial Conduct Authority.

    Halifax is a division of Bank of Scotland plc. Cheltenham & Gloucester Savings is a division of Lloyds Bank plc.

    HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC218813.

    This e-mail (including any attachments) is private and confidential and may contain privileged material. If you have received this e-mail in error, please notify the sender and delete it (including any attachments) immediately. You must not copy, distribute, disclose or use any of the information in it or any attachments. Telephone calls may be monitored or recorded.


  • 4.  DB2 Performance Tuning

    Posted Mar 17, 2014 06:34 AM
    Last time I spoke to a LUW guy about tuning he just looked at me with big, round eyes and said "Install more memory, upgrade the CPU - Done"
    sad really...but I see it coming on the z side as well...

    Roy Boxwell

    SOFTWARE ENGINEERING GMBH and SEGUS Inc.
    -Product Development-

    Robert-Stolz-Straße 5
    40470 Düsseldorf/Germany
    Tel. +49 (0)211 96149-675
    Fax +49 (0)211 96149-32
    Email: R.Boxwell@seg.de<mailto:R.Boxwell@seg.de>
    http://www.seg.de

    Software Engineering GmbH
    Amtsgericht Düsseldorf, HRB 37894
    Geschäftsführung: Gerhard Schubert

    From: Bell, Raymond (Contractor - ITSD (581355) Lond Emerald HSE, Group IT) [mailto:raymond.bell@lloydsbanking.com]
    Sent: Monday, March 17, 2014 11:09 AM
    To: db2-l@lists.idug.org
    Subject: [DB2-L] - RE: DB2 Performance Tuning

    Roy, don't be awkward.

    Yes, they're completely different. z/OS is a black box. Who knows what goes on inside it? UDB however is blessed with decades' worth of diagnostic and performance tuning tooling from a variety of vendors.

    Or is that the other way around? ;o)

    Cheers,


    Raymond

    From: Boxwell, Roy [mailto:r.boxwell@seg.de]
    Sent: 17 March 2014 10:08
    To: db2-l@lists.idug.org<mailto:db2-l@lists.idug.org>
    Subject: [DB2-L] - RE: DB2 Performance Tuning

    Seriously? You mean *apart* from everything?

    Roy Boxwell

    SOFTWARE ENGINEERING GMBH and SEGUS Inc.
    -Product Development-

    Robert-Stolz-Straße 5
    40470 Düsseldorf/Germany
    Tel. +49 (0)211 96149-675
    Fax +49 (0)211 96149-32
    Email: R.Boxwell@seg.de<mailto:R.Boxwell@seg.de>
    http://www.seg.de

    Software Engineering GmbH
    Amtsgericht Düsseldorf, HRB 37894
    Geschäftsführung: Gerhard Schubert

    From: Nanthakumar Yoganathan [mailto:fornanthu@gmail.com]
    Sent: Monday, March 17, 2014 7:48 AM
    To: DB2-L@lists.idug.org<mailto:DB2-L@lists.idug.org>
    Subject: [DB2-L] - DB2 Performance Tuning


    Hi Folks,

    One quick question,



    Interm of performance tuning, is there any difference between DB2 Z/OS and DB2 LUW environment ?

    Regards,

    Nanthakumar Yoganathan

    +91-9942512341

    -----End Original Message-----

    -----End Original Message-----


    Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC95000. Telephone: 0131 225 4555. Lloyds Bank plc. Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England and Wales no. 2065. Telephone 0207626 1500. Bank of Scotland plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC327000. Telephone: 08457 21 31 41. Cheltenham & Gloucester plc. Registered Office: Barnett Way, Gloucester GL4 3RL. Registered in England and Wales 2299428. Telephone: 0845 603 1637

    Lloyds Bank plc, Bank of Scotland plc are authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and Prudential Regulation Authority.

    Cheltenham & Gloucester plc is authorised and regulated by the Financial Conduct Authority.

    Halifax is a division of Bank of Scotland plc. Cheltenham & Gloucester Savings is a division of Lloyds Bank plc.

    HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC218813.

    This e-mail (including any attachments) is private and confidential and may contain privileged material. If you have received this e-mail in error, please notify the sender and delete it (including any attachments) immediately. You must not copy, distribute, disclose or use any of the information in it or any attachments. Telephone calls may be monitored or recorded.

    -----End Original Message-----


  • 5.  DB2 Performance Tuning

    Posted Mar 17, 2014 07:00 AM
    "You have always been here."

    - Babylon 5

    Sad but true. I see it already. Especially with ERP tools. "Extra Resource Please."

    Regards,
    Marcus Davage
    IBM Certified DB2 Database Administrator
    Senior DB2 Database Administrator, Lloyds Banking Group

    From: Boxwell, Roy [mailto:r.boxwell@seg.de]
    Sent: 17 March 2014 10:34
    To: db2-l@lists.idug.org
    Subject: [DB2-L] - RE: DB2 Performance Tuning

    Last time I spoke to a LUW guy about tuning he just looked at me with big, round eyes and said "Install more memory, upgrade the CPU - Done"
    sad really...but I see it coming on the z side as well...

    Roy Boxwell

    SOFTWARE ENGINEERING GMBH and SEGUS Inc.
    -Product Development-

    Robert-Stolz-Straße 5
    40470 Düsseldorf/Germany
    Tel. +49 (0)211 96149-675
    Fax +49 (0)211 96149-32
    Email: R.Boxwell@seg.de<mailto:R.Boxwell@seg.de>
    http://www.seg.de

    Software Engineering GmbH
    Amtsgericht Düsseldorf, HRB 37894
    Geschäftsführung: Gerhard Schubert

    From: Bell, Raymond (Contractor - ITSD (581355) Lond Emerald HSE, Group IT) [mailto:raymond.bell@lloydsbanking.com]
    Sent: Monday, March 17, 2014 11:09 AM
    To: db2-l@lists.idug.org<mailto:db2-l@lists.idug.org>
    Subject: [DB2-L] - RE: DB2 Performance Tuning

    Roy, don't be awkward.

    Yes, they're completely different. z/OS is a black box. Who knows what goes on inside it? UDB however is blessed with decades' worth of diagnostic and performance tuning tooling from a variety of vendors.

    Or is that the other way around? ;o)

    Cheers,


    Raymond

    From: Boxwell, Roy [mailto:r.boxwell@seg.de]
    Sent: 17 March 2014 10:08
    To: db2-l@lists.idug.org<mailto:db2-l@lists.idug.org>
    Subject: [DB2-L] - RE: DB2 Performance Tuning

    Seriously? You mean *apart* from everything?

    Roy Boxwell

    SOFTWARE ENGINEERING GMBH and SEGUS Inc.
    -Product Development-

    Robert-Stolz-Straße 5
    40470 Düsseldorf/Germany
    Tel. +49 (0)211 96149-675
    Fax +49 (0)211 96149-32
    Email: R.Boxwell@seg.de<mailto:R.Boxwell@seg.de>
    http://www.seg.de

    Software Engineering GmbH
    Amtsgericht Düsseldorf, HRB 37894
    Geschäftsführung: Gerhard Schubert

    From: Nanthakumar Yoganathan [mailto:fornanthu@gmail.com]
    Sent: Monday, March 17, 2014 7:48 AM
    To: DB2-L@lists.idug.org<mailto:DB2-L@lists.idug.org>
    Subject: [DB2-L] - DB2 Performance Tuning


    Hi Folks,

    One quick question,



    Interm of performance tuning, is there any difference between DB2 Z/OS and DB2 LUW environment ?

    Regards,

    Nanthakumar Yoganathan

    +91-9942512341

    -----End Original Message-----

    -----End Original Message-----


    Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC95000. Telephone: 0131 225 4555. Lloyds Bank plc. Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England and Wales no. 2065. Telephone 0207626 1500. Bank of Scotland plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC327000. Telephone: 08457 21 31 41. Cheltenham & Gloucester plc. Registered Office: Barnett Way, Gloucester GL4 3RL. Registered in England and Wales 2299428. Telephone: 0845 603 1637

    Lloyds Bank plc, Bank of Scotland plc are authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and Prudential Regulation Authority.

    Cheltenham & Gloucester plc is authorised and regulated by the Financial Conduct Authority.

    Halifax is a division of Bank of Scotland plc. Cheltenham & Gloucester Savings is a division of Lloyds Bank plc.

    HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC218813.

    This e-mail (including any attachments) is private and confidential and may contain privileged material. If you have received this e-mail in error, please notify the sender and delete it (including any attachments) immediately. You must not copy, distribute, disclose or use any of the information in it or any attachments. Telephone calls may be monitored or recorded.

    -----End Original Message-----

    -----End Original Message-----


    Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC95000. Telephone: 0131 225 4555. Lloyds Bank plc. Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England and Wales no. 2065. Telephone 0207626 1500. Bank of Scotland plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC327000. Telephone: 08457 21 31 41. Cheltenham & Gloucester plc. Registered Office: Barnett Way, Gloucester GL4 3RL. Registered in England and Wales 2299428. Telephone: 0845 603 1637

    Lloyds Bank plc, Bank of Scotland plc are authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and Prudential Regulation Authority.

    Cheltenham & Gloucester plc is authorised and regulated by the Financial Conduct Authority.

    Halifax is a division of Bank of Scotland plc. Cheltenham & Gloucester Savings is a division of Lloyds Bank plc.

    HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC218813.

    This e-mail (including any attachments) is private and confidential and may contain privileged material. If you have received this e-mail in error, please notify the sender and delete it (including any attachments) immediately. You must not copy, distribute, disclose or use any of the information in it or any attachments. Telephone calls may be monitored or recorded.


  • 6.  RE: DB2 Performance Tuning

    Posted Mar 17, 2014 07:21 AM

    Rather than ask "Interm of performance tuning, is there any difference between DB2 Z/OS and DB2 LUW environment ?" it would probably be better to ask "is there any similarity?". Although there are some performance tuning fundamentals that can be universally applied, when comparing and contrasting Z and LUW the gulf is enormous.

    What is the reason for your question? Are you being asked to carry out a tuning exercise on an unfamiliar platform?

    Adam



  • 7.  DB2 Performance Tuning

    Posted Mar 17, 2014 08:56 AM
    The operating system interfaces, capabilities re: task dispatching, how
    filesystems operate, I/O capabilities within the hardware, just to name four
    things, are all completely different on each different platform - Z is
    different from L which is different from W and L and W tuning can be
    different because of different CPUs or different I/O hardware as well.
    Performance tuning of _any_ database system necessarily involves operating
    system and hardware awareness, so of course there are big differences.





    Tim Hare

    Hare Systems Support

    HareSystemsSupport@comcast.net







    From: Nanthakumar Yoganathan [mailto:fornanthu@gmail.com]
    Sent: Monday, March 17, 2014 2:48 AM
    To: DB2-L@lists.idug.org
    Subject: [DB2-L] - DB2 Performance Tuning



    Hi Folks,

    One quick question,



    Interm of performance tuning, is there any difference between DB2 Z/OS and
    DB2 LUW environment ?

    Regards,

    Nanthakumar Yoganathan

    +91-9942512341



    -----End Original Message-----



  • 8.  DB2 Performance Tuning

    Posted Mar 17, 2014 08:56 AM
    Nanthakumar,

    It depends what you mean by performance tuning.

    Here is a breakdown of performance tuning categories (by a well-known author):

    1. Application tuning -- focuses attention on suites of programs that access particular tables, batch windows, units of work, and online service levels. This strategy concentrates on meeting Service-Level Agreements (SLAs) through analysis of transaction units of work, locking effects, commit frequency and transaction design, and data access paths.

    2. Object tuning -- concentrates on the general definitions and configurations of tables, indexes, stored procedures, and other database objects.

    3. SQL tuning -- involves SQL review and knowledge of potential access paths, table and index data distribution, and statistics. Here, the emphasis is on managing the SQL creation process, creating an inventory of existing (and planned) SQL and access paths, and proactively addressing potential issues.

    4. Resource constraint tuning -- is an analysis of possible trade-offs among CPU, elapsed time, I/O, memory, network traffic, and other resources.

    5. System tuning - deals with the IBM DB2 DBMS infrastructure that supports the previously mentioned strategies.


    To answer your question by category:

    1. DB2/z and DB2 LUW are very similar; however, often DB2/z instances support multiple application systems (sometimes hundreds), so there is much more application performance balancing and tradeoffs.
    2. DB2/z and DB2 LUW are very different, since the physical configuration of objects differs.
    3. DB2/z and DB2 LUW are very similar.
    4. DB2/z and DB2 LUW are very similar in concept; however, operating systems and hardware are quite different, so tuning tools and methods are different.
    5. DB2/z and DB2 LUW are somewhat different, since (generally speaking) system resources such as CPU and memory are managed by similar services; for example, object blocks are read from disk into virtual pools in both environments.


    Hope this helps.

    - Lock Lyon
    Fifth Third Bancorp




    From: Nanthakumar Yoganathan [mailto:fornanthu@gmail.com]
    Sent: Monday, March 17, 2014 2:48 AM
    To: DB2-L@lists.idug.org
    Subject: [DB2-L] - DB2 Performance Tuning

    Hi Folks,
    One quick question,
     
    Interm of performance tuning, is there any difference between DB2 Z/OS and DB2 LUW environment ?
    Regards,
    Nanthakumar Yoganathan
    +91-9942512341

    This e-mail transmission contains information that is confidential and may be privileged. It is intended only for the addressee(s) named above. If you receive this e-mail in error, please do not read, copy or disseminate it in any manner. If you are not the intended recipient, any disclosure, copying, distribution or use of the contents of this information is prohibited. Please reply to the message immediately by informing the sender that the message was misdirected. After replying, please erase it from your computer system. Your assistance in correcting this error is appreciated.


  • 9.  RE: DB2 Performance Tuning

    Posted Mar 17, 2014 09:33 AM

    I think so far, Lock's answer is the most thorough.  I'd approach it from a slightly different point of view - the process of tuning is very similar (even for most of these categories); the details may be very different.

    How different you find it depends on which category you are looking at. Here are some of the similarities:

    1) Database design - table design, index design, choosing the clustering index.

    2) SQL tuning - very similar process - check the actual performance metrics (how you do that is very different), see what the access path is (i.e. do an Explain), understand what the access path means (if you don't know,then you need training and you need to read the manuals, and you need to get experiience), determine if it is a good access path, determine if there could or should be  a better access path, figure out how to get a better access path.

    3) Bufferpool tuning - sizing the bufferpools and placing tablespaces and indexes into bufferpools.  Bufferpool parameters are very different

    4) Sizing memory pools appropriately - the same in concept, but very different in details.

    Operating system and database configuration turning can be very different.

    Basically, if you are good at tuning in one environment, you can learn to do it on the other environment.  If you don't know how to tune one of them, then there is no point asking what the differences are.

    Joe

    In Reply to Lockwood Lyon:

    Nanthakumar,

    It depends what you mean by performance tuning.

    Here is a breakdown of performance tuning categories (by a well-known author):

    1. Application tuning -- focuses attention on suites of programs that access particular tables, batch windows, units of work, and online service levels. This strategy concentrates on meeting Service-Level Agreements (SLAs) through analysis of transaction units of work, locking effects, commit frequency and transaction design, and data access paths.

    2. Object tuning -- concentrates on the general definitions and configurations of tables, indexes, stored procedures, and other database objects.

    3. SQL tuning -- involves SQL review and knowledge of potential access paths, table and index data distribution, and statistics. Here, the emphasis is on managing the SQL creation process, creating an inventory of existing (and planned) SQL and access paths, and proactively addressing potential issues.

    4. Resource constraint tuning -- is an analysis of possible trade-offs among CPU, elapsed time, I/O, memory, network traffic, and other resources.

    5. System tuning - deals with the IBM DB2 DBMS infrastructure that supports the previously mentioned strategies.


    To answer your question by category:

    1. DB2/z and DB2 LUW are very similar; however, often DB2/z instances support multiple application systems (sometimes hundreds), so there is much more application performance balancing and tradeoffs.
    2. DB2/z and DB2 LUW are very different, since the physical configuration of objects differs.
    3. DB2/z and DB2 LUW are very similar.
    4. DB2/z and DB2 LUW are very similar in concept; however, operating systems and hardware are quite different, so tuning tools and methods are different.
    5. DB2/z and DB2 LUW are somewhat different, since (generally speaking) system resources such as CPU and memory are managed by similar services; for example, object blocks are read from disk into virtual pools in both environments.


    Hope this helps.

    - Lock Lyon
    Fifth Third Bancorp




    From: Nanthakumar Yoganathan [mailto:fornanthu@gmail.com]
    Sent: Monday, March 17, 2014 2:48 AM
    To: DB2-L@lists.idug.org
    Subject: [DB2-L] - DB2 Performance Tuning

    Hi Folks,
    One quick question,
     
    Interm of performance tuning, is there any difference between DB2 Z/OS and DB2 LUW environment ?
    Regards,
    Nanthakumar Yoganathan
    +91-9942512341

    This e-mail transmission contains information that is confidential and may be privileged. It is intended only for the addressee(s) named above. If you receive this e-mail in error, please do not read, copy or disseminate it in any manner. If you are not the intended recipient, any disclosure, copying, distribution or use of the contents of this information is prohibited. Please reply to the message immediately by informing the sender that the message was misdirected. After replying, please erase it from your computer system. Your assistance in correcting this error is appreciated.


  • 10.  DB2 Performance Tuning

    Posted Mar 17, 2014 09:53 AM




    One more thought on this subject. For BI and analytical workloads LUW has
    in-memory, column organised tables. This is called BLU Acceleration. One of
    the key value propositions for BLU is " no need to tune".

    We have made BLU Acceleration available on the cloud. You can check it out
    for free at http://bluforcloud.com

    Sent from IBM Notes Traveler


    Joe Geller --- [DB2-L] - RE: DB2 Performance Tuning ---
    |--+----------------------------------------------------------------------|
    |Fr|"Joe Geller"


  • 11.  DB2 Performance Tuning

    Posted Mar 17, 2014 10:00 AM
    That might be the death knell for a lot of people, but it is cute saying "No need to tune" I can imagine a nice matching song along the lines of:

    Who needs coders - we have Autonomics?
    Who cares about response times on our CICS?
    We have BLU - True BLU!
    Let the magic be done by DB2
    Yay Yay Yay
    Grep Grep
    Yay Yay LUW
    Its Hammer time!



    You get the idea.....
    Oh my word! It simply *must* be Friday on some planet somewhere!!! :)

    Now where did I leave my Cricket Bat....



    Roy Boxwell

    SOFTWARE ENGINEERING GMBH and SEGUS Inc.
    -Product Development-

    Robert-Stolz-Straße 5
    40470 Düsseldorf/Germany
    Tel. +49 (0)211 96149-675
    Fax +49 (0)211 96149-32
    Email: R.Boxwell@seg.de<mailto:R.Boxwell@seg.de>
    http://www.seg.de

    Software Engineering GmbH
    Amtsgericht Düsseldorf, HRB 37894
    Geschäftsführung: Gerhard Schubert

    From: Leon Katsnelson [mailto:leon@ca.ibm.com]
    Sent: Monday, March 17, 2014 2:53 PM
    To: db2-l@lists.idug.org
    Cc: DB2-L@lists.idug.org
    Subject: [DB2-L] - RE: DB2 Performance Tuning


    One more thought on this subject. For BI and analytical workloads LUW has in-memory, column organised tables. This is called BLU Acceleration. One of the key value propositions for BLU is " no need to tune".

    We have made BLU Acceleration available on the cloud. You can check it out for free at http://bluforcloud.com

    Sent from IBM Notes Traveler


    Joe Geller --- [DB2-L] - RE: DB2 Performance Tuning ---

    From:

    "Joe Geller"


  • 12.  RE: DB2 Performance Tuning

    Posted Mar 17, 2014 10:30 AM

    That's what Terradata said,  one admin and no tuning....it's not how it worked out,



  • 13.  DB2 Performance Tuning

    Posted Mar 17, 2014 02:46 PM
    At some point in time, not too long ago the only way to get a well fitting suit was to go to a tailor. Tailor would measure you up and after a few fittings you would get a suit that was, well, tailor made for you. Nobody, and especially not me, would argue that this is the best way to get a great fitting suit. However, most of us could not afford a tailor made suit. But most of us can go to a mall and pick up a great Boss suit for, say $600, off the rack. What fashion industry has done is deliver high fashion to everyone. Some designers argued that it could not be done as did many custom tailors. Now, high end designers have not disappeared and I get calls and emails from custom tailors who still make the best fitting suits ... for a price.

    BLU Acceleration for Cloud is high end data warehousing for everyone the same way a $600 Boss suit is a high end suit for everyone. Many hove told us it can't be done. Well, we did it. The cloud allowed us to take the cost of the hardware off the table. It also allowed us to create configurations which just like suit sizes fit most people. BLU Acceleration technology removed indexes, reorgs etc. and does not even give one a choice to disable compression and other features. it removed the need and in some cases even ability to decide on some aspects of the system. Fewer decisions make it much easier to run. For many, BLU Acceleration is as close to the load-and-go system as you can get. BLU Acceleration for Cloud went even further by integrating BI tools (Cognos BI), pre-engineered schemas and reports (3 Warehouse Packs) and we are working hard on making sure that getting data in to the warehouse is brain dead simple. Can you create a better performing data warehouse by hand tuning DB2? Yes you can. But can you make one available to your end-user to run themselves in less than an hour and for less than $1/hr? That is what BLU Acceleration for Cloud does. We are betting that there are lots of people who could use data warehouse capability if it was easy and affordable. We intend to help these people, regardless of their skill or budget, get value from the IT technologies that for too long have been out of reach. For these people, cloud is the only path and technologies like BLU is the only future.  


    Regards,

    Leon Katsnelson
    Director, Information Management Cloud & Mobile Phone:1-905-413-2119 | Mobile:1-647-201-6275
    E-mail: leon@ca.ibm.com
    Blog: BigDataOnCloud.com
    Chat:leon.katsnelson
    Find me on: r

    8200 Warden Ave
    Markham, ON L6G 1C7
    Canada





    From:        Jorg Lueke

    Attachment(s)

    txt
    blankfilename.txt   1 KB 1 version
    txt
    blankfilename.txt   6 KB 1 version


  • 14.  RE: DB2 Performance Tuning

    Posted Mar 17, 2014 03:08 PM

    Leon,

    I hope you are right and it is true.  Analytics suffers from some of the highest costs, and as you say a well designed warehouse is great but we rarely get a well designed warehouse.  I imagine BI should be easier to commoditize than OLTP for many reasons, mainly because BI is mostly SQL/Data and not the sum of hundreds of parts. 

    Of course there are other issues like intrasigent business users, disbelieving architects, and over worrying security personelle. 



  • 15.  DB2 Performance Tuning

    Posted Mar 17, 2014 05:30 PM




    >Of course there are other issues like >intrasigent business users,
    disbelieving >architects, and over worrying security >personelle.

    Jorg, these are no doubt serious issues. However, I like to think of them
    as the speed bumps that slow the progress rather than walls and immovable
    barriers.

    By the way, if anyone is going to I DUG in Phoenix we will have a workshop
    on BLU Acceleration for Cloud. Registrations are pretty good so if you plan
    to attend I would suggest registering soon. Also hope to have it in Europe
    and Australia later in the year.

    As I said before, anyone can try it for free at
    http://bluforcloud.com/plans

    Sent from IBM Notes Traveler


    Jorg Lueke --- [DB2-L] - RE: DB2 Performance Tuning ---
    |--+----------------------------------------------------------------------|
    |Fr|"Jorg Lueke"


  • 16.  RE: DB2 Performance Tuning

    Posted Mar 17, 2014 03:58 PM

    Leon, before I start quoting that "BLU Acceleration for Cloud" is comparable to "a $600 Boss suit" can you confirm that this is Big Blue's official line? Or do you have a side line sponsership deal with Boss??

    Out of interest, if BLU Acceleration for Cloud is the $600 Boss....what can we compare the accelration available on Z / Netezza to?

    Adam



  • 17.  DB2 Performance Tuning

    Posted Mar 17, 2014 05:05 PM
    Marks & Spencers....

    Roy Boxwell
    SOFTWARE ENGINEERING GmbH and SEGUS Inc.
    -Product Development-
    Robert-Stolz-Stra?e 5
    40470 D?sseldorf/Germany
    Tel. +49 (0)211 96149-675
    Fax +49 (0)211 96149-32
    Email: R.Boxwell@seg.de<mailto:R.Boxwell@seg.de>
    http://www.seg.de

    Software Engineering GmbH
    Amtsgericht D?sseldorf, HRB 37894
    Gesch?ftsf?hrung: Gerhard Schubert

    On 17 Mar 2014, at 20:58, "Adam Baldwin"


  • 18.  AW: DB2 Performance Tuning

    Posted Mar 18, 2014 03:02 AM
    Cheap & Awful???

    Von: Boxwell, Roy [mailto:r.boxwell@seg.de]
    Gesendet: Montag, 17. März 2014 22:05
    An:


  • 19.  DB2 Performance Tuning

    Posted Mar 18, 2014 05:09 AM
    George from Asda...

    From: Boxwell, Roy [mailto:r.boxwell@seg.de]
    Sent: 17 March 2014 21:05
    To:


  • 20.  RE: DB2 Performance Tuning

    Posted Mar 17, 2014 09:39 AM

    In both cases a telephone and a hammer are useful tools.

    Heavy metal  ....  sledge hammer
    Server                 Claw hammer
    PC                     Rubber Mallet

    There is a frequent poster who has a one size fits all user performance tool.   He calls it a baseball bat, although he is a Brit, so it may not be the true baseball but some varyant. 



    In Reply to Nanthakumar Yoganathan:

    Hi Folks,

    One quick question,

     

    Interm of performance tuning, is there any difference between DB2 Z/OS and DB2 LUW environment ?

    Regards,

    Nanthakumar Yoganathan

    +91-9942512341




    Avram Friedman

    IBM-sys-Prog.com



  • 21.  DB2 Performance Tuning

    Posted Mar 17, 2014 10:02 AM
    Actually, there is no difference, what is important on one is important on
    another. How you go about doing it is a lot different..but you will need a
    scalpel on both..



    www.thedb2brainsurgeon.com







    From: Nanthakumar Yoganathan [mailto:fornanthu@gmail.com]
    Sent: Monday, March 17, 2014 2:48 AM
    To: DB2-L@lists.idug.org
    Subject: [DB2-L] - DB2 Performance Tuning



    Hi Folks,

    One quick question,



    Interm of performance tuning, is there any difference between DB2 Z/OS and
    DB2 LUW environment ?

    Regards,

    Nanthakumar Yoganathan

    +91-9942512341



    -----End Original Message-----