Information Management India - Bloggers Guild
RajeshPrabhu 2700028XQW Tags:  ibm rajesh prabhu purge archival optim 2 Comments 5,437 Views
On Feb 1st, 2012, I gave a seminar on my experience working with IBM Optim Tool. This session was well attended;
In the presentation, I talked about my expriences with the product and the way we customised the tool for our needs. The most intriguing thing about IBM Optim tool is that how well it binds with the backend database. We used DB2 for zOS but I'm sure Optim is as well integrated good enough with other databases.
We were able to implement a comprehensive Archial and Purge Solution in less than 3 months. This is a tremendous achievement keeping in mind that everyday data archival was in the range of about 0.3 million rows!
Do share your thoughts, experiences on IBM Optim tool in this blog.
BharathRajBK 2700013SF4 Tags:  approach ibm business cognos intelligence integration spss 17,181 Views
This article describes the integration between SPSS and Cognos solutions. The integration with Cognos comes in the form of being able to directly connect to Cognos as a data source for SPSS modeler and also being able to export the results to Cognos directly to allow Cognos to report on the results. The benefits of using Cognos as a source is that your data is all in one place and its formatted and tidied up suitable for SPSS analytics. Exporting the results to Cognos has the benefit of being able to report on the results using the familiar.
Cognos reporting formats and various different types of Cognos reports, such as dashboards and active reports. Below figure showcases one such context diagram and its integration with SPSS:
To implement this is reasonably straight forward and involves selecting the Cognos source node or the Cognos export node and dragging it into your stream as shown below:
You then have to edit the Cognos node and add the Cognos server IP address details and login credentials. As shown on Figure below –
You also need to make an ODBC connection to the Cognos Data warehouse from the SPSS server. This needs to have the same name and details as the Cognos data source. If these details do not match on the Cognos and the SPSS server the integration will not work.Below figure shows the details:
The benefits of using Cognos as a source is that your data is all in one place and its formatted and tidied up suitable for SPSS analytics. Exporting the results to Cognos has the benefit of being able to report on the results using the familiar reporting format and various different types of Cognos reports that the company uses.
Note: To either export to Cognos or use Cognos as a data source an ODBC connection to the Cognos data warehouse must be established as well as the Cognos Server connection.Summary:
In this way, we can integrate IBM Cognos BI with IBM SPSS product and get reporting data from prediction and analysis from SPSS.
DATABASEARCHITECT 120000B5P0 Tags:  architect champion dubuntu ibm appliance db2hitman dubuntux mahadev db2agent47 anil 5,451 Views
Full Screen Recommended for HD Viewing
An All in One Web Stack (Ubuntu, Apache, DB2 and PHP) that enabled Developers and DBAs to use DB2 in their Virtual Environments for FREE!!!
The appliance has one key Message!
“Enhance The UX of using DB2 for the masses”
You may download the appliance below
1) Please ensure that your Browser has atleast 1024 MB of Temp space to download this appliance or via a Download Accelerator program.
[Launching the Appliance Notes]
DB2 does not start by default. This is intentional. You may login as db2inst1 using db2rocks as the password.
Issue the following commands
1) switch from regular Shell to Bash Shell by typing bash
2) Now issue the command db2start to start DB2
All the other details are given when you extract the Appliance to a VMware Player instance.
Thanks and Enjoy the Dubuntu Experience!
Thanks and Enjoy the Dubuntu Experience!
Principal Innovator and Architect of Dubuntu Series of Appliances
DATABASEARCHITECT 120000B5P0 Tags:  mahadev champion computing anil information cloud db2 ibm india management 5,916 Views
Let's all face it, Cloud Computing was a Fad in 2010, 2011 it drove influence to key IT Decision makers to conduct Cloud POCs in the Enterprise, and in 2012, the drive to adoption will further increase if the current rate of demand continues.
Today, I delivered a webinar on DB2 and Cloud Computing with Databases in the Cloud on IBM DeveloperWorks.
It was an amazing experience talking to DB2 Users and IT Pros in general.
The focus of this article is to illustrate some of the key benefits and resources available for implementing a Cloud Solution.
I have attached the presentation that outlines the presentation.
1) Achieving Cloud 9 with DB2 in the Cloud [Anil Mahadev]
2) Cloud Computing Use Cases [ Source: CloudCases.org]
So please feel free to refer to the above resources and send me an e-mail in case you have any questions.
Look forward to my blog post, where I shall be teaching you on how to get started with Building VMs from Scratch.
President, DB2 India Users Group
DB2 and Cloud Computing Evangelist
Follow me on Twitter : @dbhitman