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…Continue
Added by Ramya on March 6, 2014 at 12:56pm — No Comments
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
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
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…Continue
Added by Cindy Russell on January 9, 2014 at 3:36pm — No Comments
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: http://bluforcloud.com/ and join the November 21st DB2 Tech…Continue
Added by Cindy Russell on November 7, 2013 at 5:13pm — No Comments
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
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....http://bit.ly/177gLOG
Added by Laura Hood on October 22, 2013 at 10:45am — No Comments
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
New Video Uploaded for Securing Business logic in DB by OBFUSCATING DDL.
Simple yet Powerful.
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
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…Continue
Added by Cindy Russell on September 9, 2013 at 12:27pm — No Comments
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:
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…Continue
Added by SENDEROPRESS on March 13, 2013 at 8:24pm — No Comments
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…Continue
Added by Raju Pillai on December 27, 2012 at 2:51pm — No Comments
If you have DB2 skills and are looking for a new job opportunity, check out db2.jobs. You will find about 3,500 job postings from across the globe on this site, direct from the employer. Robust filtering capabilties let you narrow in on a specific job title--or even a specific country, state or city.
Check out db2.jobs and let me know what you think!
Added by Cindy Russell on November 20, 2012 at 11:38am — No Comments
Federation Server is at IOD! Come see a live demo at the expo room, including:
Stop by the booth and say hello!
Also, later this week on Thursday, session 1105 addresses data virtualization and federation patterns.
Added by Jef Treece on October 23, 2012 at 1:23pm — No Comments
This web site links you to announcements and also some livestreaming video from across the brands at the conference.
And, IBM PureData Systems have been keynoted at the conference! If you cannot attend IOD, then kick start your learning on PureData Systems with the DB2 Tech Talk this Wednesday Oct 24th. We will also cover other hot news from IBM and…Continue
Added by Cindy Russell on October 22, 2012 at 1:28pm — No Comments
Register today and take advantage of the complimentary DB2 10 for z/OS New Functions and Migration Planning Workshop co-presented by Julian Stuhler, IBM Gold Consultant and Mike Bracey, IBM DB2 for z/OS Systems Engineer. The workshop will be held at the IDUG Technical Conference in Berlin on Sunday 4th November 2012 at 9.30am.
Attendees can expect to broaden their understanding of the features delivered in DB2 10 for z/OS, as well as the business…Continue
Here's a look back over the last few month about some notable papers.
Added by Farzana Anwar on October 12, 2012 at 12:48am — No Comments
And I'm back with my third quarter installment of technical articles about the DB2 for Linux, UNIX and Windows product. Here are some papers I'm keen to inform you all know about.
I wanna work at IBM (its my dream) ....I am interested in DB2 and I am going to right DB2 Fundamentals exam-730.Is it enough to enter into IBM.Please guide me " How can I get a Job @IBM".
Added by G Sai Rajesh Kumar Reddy on October 1, 2012 at 3:42am — No Comments