We have moved to www.dataGenX.net, Keep Learning with us.

Friday, November 30, 2012

How do we know whether we running Datastage jobs on SMP or MPP System:


Look in the Configuration file if the "fastname" has the same value for all given nodes then you are running on SMP.

Tuesday, November 27, 2012

Saving Shell Script with executable permissions: tips & tricks



In our tech routine we daily usually need to write small script to do task easily. Sometimes its irritating to edit/create and save and give the executable permissions.

What if when we create a file it have the executable permissions, Yes, we can do that with the help of umask but this will applicable on all files so don’t want that. So here is the solution….

Friday, November 23, 2012

fun!! - Your Cute dog....


Here is your number one companion – cute, talented and loyal.  He can sit, lie down and roll over.  Try giving him a pet and watch how he responds.  Keep your dog entertained by playing ball or giving him a bone.  Reward him by giving him a treat.  To get him to sit, double-click your mouse on the ground close to him.  Double-click again to get him to lie down.  Then hold your mouse button down and make a circular motion to tell him to roll over.


General hardware, software, and environment information to collect for Solaris, HP-UX and Windows


Whenever we are reporting for any issue to support team they are usually ask these details

·         Operating system version
·         Operating system patches or maintenance level
·         Operating system environment variables
·         Operating system configuration & error reporting
·         Operating system kernel parameters
·         Operating system processes
·         Mounted file systems and disk resources
·         Hostname information and network information

Wednesday, November 21, 2012

DataStage Documentation Best Practices - 2

Introduction

This document contains the Data Stage Best practises and recommendations which could be used to improve the quality of data stage jobs. This document would further be enhanced to include the specific Data Stage problems and there troubleshooting.

 
Recommendations

Tuesday, November 20, 2012

Stopping DataStage from batch[bat] file in Windows

Hi there..
I am going to share a small bat[batch] script which can be used to stop the DataStage server in
 windows environment,


Monday, November 19, 2012

Starting DataStage from batch[bat] file in Windows

Hi there..
I am going to share a small bat[batch] script which can be used to start the DataStage server in
 windows environment,

put this bat file in DSHOME or u can add a line in script to cd to DSHOME..

Saturday, November 17, 2012

XMeta DB : Datastage Repository - 2

Prior to Datastage version 8, the datastage repository information was stored in files(uv). From version 8, the repository information is also stored in database. Since the information is available in database, it is easier to write queries and find the details. During the installation you will have the option to install the repository either in DB2 or in Oracle.

Usually, the datastage repository is built on DB2 database. because Db2 comes with the Information Server Software by defalt.


A word of caution: Do not try to alter the XMETA repository contents as it may have adverse effects.


Here is the Part 1 of this tutorial :   XMeta DB : Datastage Repository - 1



Wednesday, November 14, 2012

SSH Alternatives for Windows & Linux

Here, I am going to share the tools which are used for SSH connectivity.
Please have a look...

SSH Alternatives for Linux


 
Putty
Putty is a Windows SSH client/suite. Putty includes an ssh agent, and command line file transfer tools. Simple GUI interface for virtually all settings. A simple, lightweight client for connecting to a Linux shell from your Windows machine!

SSH Alternatives for Windows



 Putty – the best
Putty is a Windows SSH client/suite. Putty includes an ssh agent, and command line file transfer tools. Simple GUI interface for virtually all settings. A simple, lightweight client for connecting to a Linux shell from your Windows machine!

Tuesday, November 13, 2012

Saturday, November 10, 2012

Data transformation in DataStage

Data transformation and movement is the process by which source data is selected, converted, and mapped to the format required by targeted systems.
The process manipulates data to bring it into compliance with business, domain, and integrity rules and with other data in the target environment. Transformation can take some of the following forms:

Wednesday, November 07, 2012

DataStage job status log values

They show what values can be used when designing job sequencers when defining triggers or nested conditions. Values are also helpful when using DataStage "dsjob" utility from the operating system command line.

Tuesday, November 06, 2012

Failed to connect to DataStage Server


When trying to logon to InfoSphere DataStage Clients (Designer, Director or Administrator) logon fails with the error:
Failed to connect to DataStage server: <servername> , project: UV
(User name and/or password incorrect (80011))
The same user can successfully logon to the Web Console.

Monday, November 05, 2012

General hardware, software, and environment information for AIX and Linux

Whenever we are reporting for any issue to support team, they are usually ask these details

·         Operating system version
·         Operating system patches or maintenance level
·         Operating system environment variables
·         Operating system configuration & error reporting
·         Operating system kernel parameters
·         Operating system processes
·         Mounted file systems and disk resources
·         Hostname information and network information

Friday, November 02, 2012

uniq : a cool nix filter



Hi guys,
Yesterday, I was sitting on my desk and doing usual boaring task ;-). Then I got a seq file containing more than 3 millions records and 5 column. What I have to do is fetch the duplicates records based on first column. It's quite easy in Nix environment with out taking help of any tool.

So i thought, I should share this to you also. Here It comes.....