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:
Added by Elder Ribeiro Lira on April 21, 2013 at 10:10pm — No Comments
Download the DB2 Technology Preview to explore in-memory and columnar technologies for a fast pass on analytics and reporting. The Technology Preview is an active approach to explore emerging technologies.
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
Added by Cindy Russell on January 21, 2013 at 5:00pm — No Comments
Sign up for this new RSS feed from developerWorks. It is designed to alert you when new content is posted for the IBM Information Management area--including articles from IBM DB2 experts. It also includes IBM Redbook content and some IBM Data Mag content too.
And if you have not done so…Continue
Added by Cindy Russell on January 3, 2013 at 4:30pm — 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
Would you like to set a minimum or maximum limit for an instance or database configuration value and still be able to use the automatic memory manager feature of DB2 LUW? If you would then you can use the script below to accomplish this.
This parameter driven script will echo display the parameters it needs to operate. You can test it manually and then when you have identified the configuration parameter you want to maintain, the minimum value you would like to maintain, the…Continue
Added by Mark Mulligan Sr on December 18, 2012 at 7:16pm — 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
Added by Sharon Grace on August 27, 2012 at 12:40pm — No Comments
On a previous post I showed how to insert parent-child data from an XML document using stored procedure. Well here I am going to show how to retrieve data from a table as an XML document. Using the table set of tables from the previous post lets retrieve all the order details for a given customer. Here is a stored procedure that will take customer_id as an input and then return an xml document that has all the orders and…Continue
Added by Raju Pillai on August 4, 2012 at 6:33am — No Comments
Couple of days back I wrote an article that showed how to quickly insert a child table with a parent table having generated column. On this one I am going to show you how to insert data using XML as a value. As my previous article show its easy to insert to child table , but you have to insert one row at a time. Well what if we have multiple child rows…Continue
Added by Raju Pillai on August 4, 2012 at 6:31am — No Comments
You may have seen the recent video here on ChannelDB2 that introduces auditing of DB2 changed data. If you're interested in giving it a quick try, it's easy set up a simple configuration and see what you get. That's what I'm going to show you how to do in this post. It should take about 5-10 minutes. We'll use DB2's SQL Replication. It's provided with all editions of DB2 and InfoSphere Warehouse…Continue
Added by david t on July 18, 2012 at 5:00pm — No Comments
Added by melanie steckham on June 22, 2012 at 12:27pm — No Comments
A couple of months ago, IBM announced enhancements to its data replication in support of DB2 v10 for UNIX and Windows. This month, IBM released an update to its Q Replication Dashboard that supports those enhancements and much more. In fact, most the Dashboard's enhancements can be used with Q Replication for DB2 z/OS, too. This post takes a quick look at…Continue