DataStage migration part2
I have given the environment details for the migration. Now will move to the technical part of the migration.
1. The achievement is moving the DataStage project from oracle to DB2 environment.
In the old DataStage 7.5 environment, we don’t have information server concept where the DataStage repository data will be sorted in the oracle/db2 database as a separate database.
So the data will be storage in the same DataStage server. So we…Continue
Added by Lohith on May 31, 2012 at 3:29am — No Comments
please find the steps to fallow for datastage migration
DataStage migration from 8.0 to 8.1 or 8.5 Activity
Added by Lohith on December 2, 2011 at 2:44am — No Comments
DataStage migration from DB2 to Oracle or Oracle to DB2-Part1
As time passed most the projects will move to the new environment or will upgrade from the OLD environment based on the project requirement. One the usual thing which happens is Database exchange in the project. I am explaining this from my experience where we had already working DWH with the below structure
ETL Tool –DataStage.
Due to new project…Continue
How to start work as DB2 DBA in DWH team without KT-part1
This is as per my knowledge only.
Different kinds of DBA are
1.Unix admin DBA
4. Developer DBA
UNIX admin DBA: Unix administrators basically do the SO (Linux/hp/aix) installation and later if the project/company is small they will do the rest of the installation for Database DB2 and also for the applications like…Continue
Added by Lohith on November 24, 2011 at 4:00am — No Comments
This is the info as per my knowladge.
What is the architecture of data stage?
Architecture of DS is client/server architecture.
We have different types of client /server architecture for DataStage starting from the different versions.The latest version is DataStage 8.7
Added by Lohith on November 23, 2011 at 4:05am — No Comments
I am telling about the total end to process for DWH project implementation.
The Data warehouse project for infrastructure team will be
1. The project planning-which will conclude with software and hardware selection and total budget.
2. The Budget/funding approve from PMO/Mangers
3. Capacity planning for the DWH project and creating the capacity document
4. Analysing the capacity document and creating the SP-unix and DBA-DB document
There are many ETL tools which will support for the data warehouse .The most efficient Tools which I am using from past many years is Datastage. This was Assential company product later it was occupied by IBM.As time pass the new requirements and the problem faced in the tool has to be modified to sustain in the market .so even datastage has under gone many changes and come up with new versions to handle the data effectively.
I am starting from…Continue
Added by Lohith on April 15, 2011 at 2:48am — No Comments
Data warehouse management
Data warehouse is a Process of collection data from different sources and loading the data in one place to get the once…Continue
Added by Lohith on July 26, 2010 at 10:00am — No Comments
This is an article regarding the 2 problems mixed DB2 DAS problem and also the Memory problem
Initially I got the problem in db2diag.log file that…Continue
Added by Lohith on April 11, 2010 at 6:30am — No Comments
Added by Lohith on February 3, 2010 at 5:52am — No Comments