This Group is founded for IT Professionals to share their knowledge & experiences on IBM technology. You can make the best of the group by interacting with industry experts.We have regular features in the group including developerworks update on IBM tech
Enterprise Marking Management - Unica Marketing Operation upgrade best practices Check Supported Platforms Check Supported Upgrade Paths Use UMO Installer wizzard UMO database Upgrade Java upgrade Post upgrade validation Known issues/limitations To check details on above you can see presentation available at UMO best practices link .
There are multiple ways in which DB2 supports recursion in SQL and recursive SQL is explained in many classes. What seems to be missing however is a write-up how to write recursive SQL PL. That is how to allow a function or procedure to call itself? Here I explain how a routine can call itself in SQL PL.
Recently I discussed the motivation behind using anonymous blocks. The
reasoning was centered around the need to execute complex scripts on
the server without being able or willing to define a routine in the
database's catalog. Inside of an anonymous block you can then define all the logic flow you need. You can also declare local variables to hold temporary data. DB2 10 expands beyond that by allowing you to declare local types and local procedures. I discuss the feature at sqltips4db2.com .
Many years ago when DB2 re-entered the TPC-C benchmark war a new set of SQL was developed to improve the efficiency of SQL for key OLTP transactions. In this blog post I discuss SELECT FROM INSERT, UPDATE and DELETE which's impact goes well beyond TPC-C.
Truisms: SSD is fast SSD is expensive HDD are big HDD are cheap DB2 10 boasting a new and exciting feature which helps you place your data where it is most cost effective. Multi temperature data management not only allows you to place data at the most appropriate storage devices. It also helps you manage the data life cycle. I wanted to see for myself and have built a testbed on my home PC. You can read about it at www.sqltips4db2.com .
When IBM announced DB2 10 for LUW on April 3 claims were made that DB2 10 is compatible with 98% of the source code of applications written for Oracle . Claims are easy to make, but hard to back up. IBM
has a tendency to be conservative when making claims and I personally
am even more so when I have to stand up in front of a customer and
defend them. As the saying goes:
Don't trust statistics you haven't developed yourself.
So when I started updating my presentations on Oracle Application Compatibility to DB2 10 I decided to do my... [More]
If you use DB2 for LUW and you are interested in building your SQL skills SQLTips4DB2.com is the BLOG to follow. In this BLOG I post all sorts of tips, tricks and tools around DB2 with a special focus on SQL. Some of the past highlights have been an SQL PL Profiling and tracing tool How to translate locks into actual rows How to perform online application upgrades and more. The most recent post is an introduction to the usage of anonymous blocks in DB2 for LUW
I attended an Enterprise Cloud Computing Conference a couple of weeks back. The conference gave some interesting insights into the Cloud space. Contemplate before moving to cloud. Not everything is meant to be in the cloud. Identify the cloud characteristics and check whether your application/offering needs it. Some of the key things include: On demand pooled resource (hardware, network, software etc) Elasticity, fault tolerance Measured service for monitoring, billing etc What will be the cost of moving to the cloud? Will it be... [More]
With the barrage of cloud news constantly hitting the market, it can be challenging for organizations to differentiate between all of the solutions and capabilities out there. But with the latest cloud offering from IBM, the value proposition is quite simple— you get a low-cost, low-risk entry to cloud computing with compelling features. This is especially important for organizations who are still trying to leverage the cost savings of virtualization. Our customers have told us they’re looking to cloud computing to increase agility—the... [More]
Utkarsh is the Enterprise Architect with Vodafone India. He is
responsible for establishing architectural frame work and its governance for
Vodafone IT. The architecture frame work includes functional
architecture, technical architecture and data architecture of Vodafone India
An M.C.A. from Surat, he has around 18 years
of experience in IT of which 15 years were spent in BSS implementations and
transformations for various Telcos in the UK, US and Malaysia. Before Vodafone,
he worked for IBM (Malaysia)... [More]
Posam is a commerce graduate with a PGDCA degree and also PMP certified. He has
17 years of experience in IT, having started his career as a software developer.
He joined PAE in 1995, where he built the IT infrastructure from scratch,
deployed ERPs, Portal/s and many other systems in the organization. Currently
working as the Head - Information Systems & Business Process, he reports to
the Managing director of the company.
finalist in The Great Mind Challenge for Business 2011 Program from IBM,... [More]
There's still time to sign up for the IBM webcast: Managing the Cloud – Best practices for cloud service management Organizations today are looking to cloud computing to deliver cost savings and faster service delivery. However, most organizations are still struggling to have the basic IT infrastructure that is necessary to take the leap to a robust cloud. This session will explain how service management can help provide the essentials to maintain service levels in the cloud and best practices based on IBM's work with customers. This... [More]
Techsa services is a services centric company offering expertise in Network & Security Consulting, Data Center and Desktop Virtualisation and End-Point & Asset Management area, launched by Ravi Khanchandani, Sameer Chaukar & Sanjiv Sachdev. They offer IBM and VMware solutions to customers. IBM Tivoli solutions like TEM, TAM IT and TSRM form a very significant part of their offerings in the marketplace. Their strength lies in understanding the customer business – by mapping the customer’s business expectation and requirements to... [More]
Continuing its 6 year old Indian tradition, this year's Software Universe, IBM India's largest annual software conclave, is happening on 19/20 Oct in Mumbai. Day 1 is CXO day. Key Highlights are: Exclusive 1:1 meetings with 28+ IBM Distinguished Engineers & IBM WW Executives Solution EXPO walk-through that comprise showcasing next-generation technology & IBM software capabilities highlighting “best of ISL” Smarter Planet demos highlighting solutions around Airports, Transportation, Healthcare, Intelligent Buildings etc. ISV booths... [More]
Join us for the Managing the Cloud Webcast series to learn more about best practices, technical approaches and capabilities to help solve your business and technical challenges in the cloud. Sign up for these free 1 hour webcasts today. Best practices for cloud service management - Nov 8, 12-1EST Organizations today are looking to cloud computing to deliver cost savings and faster service delivery. However, most organizations are still struggling to have the basic IT infrastructure that is necessary to take the leap to a robust cloud. This... [More]