ChannelDB2

Raju Pillai
  • Male
  • San Antonio, TX
  • United States
Share on Facebook Share on Facebook Share

Raju Pillai's Groups

Gifts Received

Gift

Raju Pillai has not received any gifts yet

Give a Gift

 

Raju Pillai's Page

Profile Information

Full Name:
Raju Pillai
Job Title:
Database Technologist
Company:
Techsatwork
Homepage/Blog:
http://www.techsatwork.com
Platforms of Interest:
Linux/UNIX/Windows

Raju Pillai's Blog

DB2 V10 Adaptive Compression

Posted on December 27, 2012 at 2:51pm 0 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

Retrieving data as XML using stored procedure

Posted on August 4, 2012 at 6:33am 0 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

Stored Procedure to insert data to parent and child using XML

Posted on August 4, 2012 at 6:31am 0 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

Sending emails from DB2

Posted on November 15, 2011 at 8:07am 0 Comments

I am sure you all know that you can configure db2 admin server and health monitor to send emails, but how do you send email from within

db2 luw itself. Much like SQLMAIL feature in our friend SQL Server , DB2 now have a mail feature. Starting from DB2 V9.7, there is an additional database configuration called SMTP_SERVER and built in stored procedure …

Continue

Comment Wall

You need to be a member of ChannelDB2 to add comments!

Join ChannelDB2

  • No comments yet!
 
 
 

Featured Downloads

Try BLU Acceleration on Cloud

© 2019   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service