All Blog Posts (287)

New on the BLU Acceleration Hub

My top five picks of new content on the DB2 with BLU Acceleration microsite at

  • Partner solutions pages - find out which ISVs and consultants use BLU Acceleration in-memory computing to speed access to data and insights:
  • What is in-memory computing? - Find out how it works, what its benefits…

Added by Cindy Russell on June 18, 2014 at 11:41am — No Comments

"IBM DB2 for z/OS - at the hear of you business analytics and big data initiatives"

The heart of today's data warehouse, big data and analytics initiatives is based around databases.  Analysts show that transactional data and  log data are top two types of data used in big data initiatives despite the immediate association of social data and unstructured content.   DB2 for z/OS by example is robust, scalable, secure and provides some of the best transactional integrity.  With all of this Mike Ferguson analyst and consultant concludes in his white paper : "All of this makes…


Added by Mark Simmonds on May 20, 2014 at 11:58am — No Comments

The value of data on the balance sheet.

Hold tight - this will probably freak the accounting world out.  I was listening to an analyst call about big data earlier today.   I asked the question whether data would soon have a value on the asset sheet.   There was a resounding agreement that it would -  if a suitable metric could be devised.

To me it all depends on whether an organization can put controls around the following (non-exhaustive) criteria :

Accurate data  - bad data is like a virus to the business and could…


Added by Mark Simmonds on May 20, 2014 at 11:56am — No Comments

User Defined Functions and Stored Procedures to generate and validate hashes

I have updated my db2-hash-routines package to include bcrypt and sha-256 hashes.

The following hashes are supported:

  • bcrypt
  • sha-256
  • sha-1
  • crypt
  • md5

Documentation is available as…


Added by Helmut K. C. Tessarek on May 11, 2014 at 6:38pm — No Comments

Improving DB2 Database Performance - Part I 7 Things to remember while range partitioning

One of the techniques to improve database performance and achieve greater scalability is using table partitioning. According to live industry observations  when you see the following symptoms you should consider table partitioning

Slow queries that return small amounts or no data

Slow queries that return large amounts of data

Blocking between readers and writers (inserts or updates)

As tables grow in size, it may be easier to manage your…


Added by Ramya on May 1, 2014 at 6:00am — No Comments

Transforming Big Data Into Insights - IBM System z

It's a complimentary webcast led by guest speaker Mike Ferguson, an independent consultant and analyst. He will review the business and technical requirements for clients embarking on big data and business analytics solutions. Mike will also discuss some of the key IBM solutions for System z and their potential to help clients meet those requirements.

Register and receive Mike's new white paper on this topic

Added by Mark Simmonds on April 22, 2014 at 10:35am — No Comments

Gain Slim Shape Body With Natural Garcinia Cambogia

has I hope you're well a good I could use for you today just like any not that day but going to be a slight difference I'm going to use my newt stop so excited about mismanages it's a masticating juicer okay his brilliant for getting dead extraction the best extraction out that Green’s celery cucumber those kind of things okay a just got land use the from UK juices that place I get all my juices from great deal family run company great that the service when you know customer services…


Added by ragini taxi on April 1, 2014 at 7:52am — No Comments

DB2 Expression Based Indexes

With expression-based indexes, you can create an index that includes expressions. The performance of queries that  involves expressions is improved if the database manager chooses an index that is created on the same expressions. Expression-based indexes are best suited when you want an efficient evaluation of queries that involve a column expression. Simple index keys consist of a concatenation of one or more specified…


Added by Ramya on March 6, 2014 at 12:56pm — No Comments

How to create DB2 with BLU Acceleration database to speed your analytics applications

DB2 with BLU Acceleration speeds analytics and reporting using dynamic in-memory columnar technologies. In-memory columnar technologies provide an extremely efficient way to scan and find relevant data. Coupled with innovations such as parallel vector processing and actionable compression, it makes your analytic queries far faster and less complex. So you can connect with the information you need at breakthrough speed and…


Added by Ramya on March 6, 2014 at 12:54pm — No Comments

Check out Clabby Analytics on IBm BLU Acceleration!

This analyst finds that DB2 with BLU Acceleration for in-memory computing delivers consistently higher performance at a lesser cost.  Read for yourself.

Added by Cindy Russell on January 27, 2014 at 1:54pm — No Comments

Next DB2 Tech Talk Jan 23rd: Leveraging InfoSphere Optim Workload Replay for DB Environment Changes

IBM InfoSphere Optim Workload Replay can significantly improve your database testing experience and help you successfully manage change in your database environments, whether you are adopting BLU Acceleration, upgrading DB2 versions, or making the move to DB2.


Using InfoSphere Workload Replay, you can capture production workloads and use them to build realistic testing environments. This helps assess a wide range of database changes before production deployment and without…


Added by Cindy Russell on January 9, 2014 at 3:36pm — No Comments

Check out BLU Acceleration for Cloud Technology Preview


At the Information On Demand conference, IBM has announced BLU Acceleration for Cloud as a technology preview.  This is an opportunity to help shape the product, while also taking advantage of hot BLU Acceleration dynamic in-memory technology.  The cloud implementation provides a simple and agile way to access BI and data-intensive reporting on the cloud!


Check it out:  and join the November 21st DB2 Tech…


Added by Cindy Russell on November 7, 2013 at 5:13pm — No Comments

Next DB2 Tech Talk: Use DB2 on the Cloud

 Need to get started using DB2 quickly and at a low cost? DB2 on the cloud is an ideal way to get up and running quickly.

Several pre-installed, pre-configured editions of DB2 are available on the cloud to support needs that range from a small workgroup to advanced enterprise data applications.

Attend this Tech Talk to learn more about the features of this cloud implementation and how they can work for your business needs.

Join Rav Ahuja of IBM Labs on…


Added by Cindy Russell on October 28, 2013 at 5:30pm — No Comments

Triton Director Recognised as Top DB2 Consultant in IBM Awards

We are delighted to announce that Triton Consulting's Solutions Delivery Director, Julian Stuhler, has been named as a Top DB2 Consultant in IBM's annual awards ceremony held at the International DB2 User Group (IDUG) Conference in Barcelona this month.  The award was presented by John Campbell, IBM Distinguished Engineer.

Read the full story.... 

Added by Laura Hood on October 22, 2013 at 10:45am — No Comments

Bacup of DB2 v 9.7

Hi All ,


We have installed DB2 v9.7 on SAP Nw 7.3 , 


we would like to take the Backup of DB2 v 9.7 also we would like to enable archie log


Please share the suitable documentation for that




Added by Manish on October 6, 2013 at 5:03am — No Comments

Concealing Business logic in Database - OBFUSCATE DDLs

Hi All,

New Video Uploaded for Securing Business logic in DB by OBFUSCATING DDL.

Simple yet Powerful.

Concealing Business logic in Database - OBFUSCATE DDLs

Brief Description:

Conceal/Mask/Hide your critical business logic in Database using Obfuscation of DDLs.

Method 1: db2look with WRAP Option

Method 2: Function…


Added by Harishkumar Baburao Pathangay on October 3, 2013 at 1:01am — No Comments

Dr Vladimir Bacvanski Hadoop Crash Course Add-on Tutorial at IBM IOD Conference

Big Data applications demand a lot of skills to execute well -- from knowledge of Hadoop to skills to work extensively with your business counterparts. 


At this year's IOD conference, we have designed a set of tutorials that will let you build this range of skills.  For example, join Dr Vladimir Bacvanski for a 9AM - 4PM tutorial on Hadoop.  He will cover all of the relevant technologies to Hadoop but from the standpoint of a data base administrator or data management…


Added by Cindy Russell on September 9, 2013 at 12:27pm — No Comments

DB2 Export and Load Using Compression & Named Pipes

Just passing by to share how to use DB2 export and load with compressed files. I found it really useful for big tables, who's with me?? Check out the post on my blog:

DB2 Export and Load Using Compression & Named Pipes



Added by Elder Ribeiro Lira on April 21, 2013 at 10:10pm — 1 Comment

Creación de Tablas y poblamiento para procesos de prueba en la QTEMP u otra Librería


Las siguientes instrucciones en SQL les permiten disminuir la espera de datos para pruebas sea esto de un proceso en particular como también en una prueba unitaria de un programa que realizan en cualquier lenguaje. }

De esta manera usted puede replicar y poblar sus propias tablas en ambientes de pruebas con muy poco esfuerzo.

Para esto vamos a crear una tabla XORIGEN basados en la…


Added by SENDEROPRESS on March 13, 2013 at 8:24pm — No Comments

DB2 V10 Adaptive Compression

Last February, I wrote about DB2's compression.  If that was McLaren, with DB2 V9.7's compression, IBM upgraded to Lamborghini Aventador. Apparently IBM's thirst didn't stop there, they went one more step ahead and got the Bugatti Veyron with DB2 V10's adaptive compression.  If you didn't like the analogy, then I will put it in simple terms - DB2 V10 adaptive compression is compression on steroids.

On V9.5, I have…


Added by Raju Pillai on December 27, 2012 at 2:51pm — No Comments

Monthly Archives













Featured Downloads

Try BLU Acceleration on Cloud

© 2020   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service