ChannelDB2

Lohith's Blog (12)

DataStage migration part2

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

DataStage migration from 8.0 to 8.1 or 8.5 Activity setps

 

Hi

 

please find the steps to fallow for datastage migration

 

SNO

DataStage migration from 8.0 to 8.1 or 8.5 Activity

 …

Continue

Added by Lohith on December 2, 2011 at 2:44am — No Comments

DataStage migration from DB2 to Oracle or Oracle to DB2-Part1

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

Added by Lohith on November 25, 2011 at 4:46am — 4 Comments

How to start work as DB2 DBA in DWH team without KT-part1

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

Added by Lohith on November 24, 2011 at 4:00am — No Comments

DataStage Architecture

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

Added by Lohith on November 23, 2011 at 4:05am — No Comments

Datawarehosue proejct with datastage 8.5 and DB2/Oracle Database

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

Added by Lohith on August 2, 2011 at 5:23am — 1 Comment

Datawarehouse implementation for DB2/oracle/Datastage version 7.5 to 8.5

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

Added by Lohith on April 15, 2011 at 2:48am — No Comments

Data warehouse management

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

DB2 DAS problem and also DB2 Memory problem solved Successfully

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

IBM P series shutdown process for DB2,Datastage,Essbase and hyperion application in IBM DS4300 storage

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

Added by Lohith on February 3, 2010 at 5:52am — No Comments

DB2 DBA Administration

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

Added by Lohith on February 2, 2010 at 8:00am — 3 Comments

Datawarehouse project working with DB2,Datastage 7.5,IBM AIX and crystal report

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

Added by Lohith on February 1, 2010 at 8:00am — 1 Comment

Featured Downloads

Try BLU Acceleration on Cloud

© 2019   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service