Lohith's Blog (12)

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

 

Hi

 

please find the steps to fallow for datastage migration

 

SNO	DataStage migration from 8.0 to 8.1 or 8.5 Activity
…

Continue

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

OS-AIX

Database-DB2(DWH Database)

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

2.Application DBA

3.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

DataStage Architecture

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

http://www-01.ibm.com/support/docview.wss?uid=swg27008803

1.…

Continue

Hi

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

5. SP…

Continue

Datawarehosue implementation.

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

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

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

IBM Pseris shutdown process



I was working as DB2 DBA ,Unix admin for the DWH project in my previous company. Some of the real time experience and problems which I faced in this project and how I came up with the solution.



Let me explain



We had IBM Pseries 570 with DS3400 storage



NAME VERSION



1. DB2 Server -- ---AIX 5.3

2. ESSBase Server-- ---AIX 5.3

3. ETL Server-- ---AIX5.2

4. Analyzer (hyperion)--… Continue

Hi



I am lohith working on DB2 DBA administration from past 5 yr.



Let me explain the DB2 DBA real time experience and the problem faced by me and the solution for the problem.



General DB2 DBA responsibility.



•Creating primary database storage structures (table spaces) once developers have designed an application.

•Modifying the database structure, as necessary, from information given by application developers.

•Manage Backup, Security, and Controls… Continue

Hi



I am working on this data warehouse project from past 4.5 yr. starting from initial hardware invoice process to aix OS installation and mount point creation, DB2 installation, datastage installation, datastage configuration for Oracle, SQL and DB2 database and finally crystal report generation.

Let me explain how the DWH(Datawarehosue) process works.



General work flow.



S1(oracle)---------------------ETL(Datastage)---DWH(DB2 database)--Crystal report… Continue