Something about DataStage, DataStage Administration, Job Designing,Developing, DataStage troubleshooting, DataStage Installation & Configuration, ETL, DataWareHousing, DB2, Teradata, Oracle and Scripting.
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,
I am going to share a small bat[batch] script which can be used to stop the DataStage server in
windows environment,
Labels:
Administration
,
application
,
commands
,
DataStage
,
DSRPC
,
Linux
,
Script
,
Stop
,
Unix
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..
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..
Labels:
Administration
,
application
,
commands
,
DataStage
,
DSRPC
,
Script
,
Start
,
windows
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.
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
Usually, the datastage repository is built on DB2 database. because Db2
comes with the Information Server Software by defalt.
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...
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!
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:
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.
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.....
Subscribe to:
Posts
(
Atom
)