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

Thursday, January 31, 2013

InfoSphere DataStage Client logon fails with the error: User name and/or password incorrect (80011)


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.


Cause

Wednesday, January 30, 2013

Adding background colors or background images to Lotus Notes mail - Part 1


hey do u know how to add background image in Lotus Notes on which we can write some msg ???? 

I thought, I have to share this with you also coz most of you guys are using Lotus Notes ( I hope ;-) )
So here It is.....


Tuesday, January 29, 2013

Pivot stage made easy


Many people have the following misconceptions about Pivot stage.
1) It converts rows into columns
2) By using a pivot stage, we can convert 10 rows into 100 columns and 100 columns into 10 rows
3) You can add more points here!!

Wednesday, January 23, 2013

Dropping CheckPoints in Job design



ETL tools can be extremely involved, especially with complex data sets. At one time or another, many data management professionals have built tools that have done the following:

  • Taken data from multiple places.
  • Transformed into (often significantly) into formats that other systems can accept.
  • Loaded said data into new systems.
In this post, I discuss how to add some basic checkpoints into tools to prevent things from breaking bad.

Tuesday, January 22, 2013

Tips & Tricks for debugging a DataStage job



The article talks about DataStage debugging techniques. This can be applied to a job which
  • is not producing proper output data or
  • to a job that is aborting or generating warnings
  1. Use the Data Set Management utility, which is available in the Tools menu of the DataStage Designer or the DataStage Manager, to examine the schema, look at row counts, and delete a Parallel Data Set. You can also view the data itself.

Monday, January 21, 2013

Clean ReStart of the IBM InfoSphere DataStage Engine



If you suspect some Client sessions did not cleanly end or disconnect, you can perform a clean restart to make sure the DataStage Engine is starting from scratch. Please make sure all clients are logged off and no jobs are running before performing the below steps.
Here are the instructions for a clean restart of DataStage Engine:

Wednesday, January 16, 2013

Multiple Job Compile in DataStage


Multiple job compilation is used to compile multiple jobs at a time. Follow the steps:

Step 1: Log into DS Designer and go to
‘Tools -> Multiple Job Compile’

Step 2: Then select job kind, routines or etc which you want to compile and choose Show Manual section page from the following diagram.

Thursday, January 10, 2013

How to delete DataStage jobs at the command line



1.    Login to the DataStage Administrator. Select the Project and click the Command button. Then execute the following command:

LIST DS_JOBS <job_name>

Wednesday, January 09, 2013

Hide Password Entry in UNIX script:



We can use 'stty' to hide the password entry in UNIX command prompt, which is like entering password when you login to the UNIX.

stty:
'stty' sets options for your terminal

Monday, January 07, 2013

An introduction to MQ - Part2




Let's look at the Remote Queue defnition for CAPA.TO.APPB.SENDQ.REMOTE, shown next. On the left-hand side are the defnitions on QMA, which comprise the Remote Queue, the Transmission Queue, and the Channel defnition. The defnitions on QMB are on the right-hand side and comprise the Local Queue and the Receiver Channel.

Friday, January 04, 2013

Know your DataStage Jobs Status without Director

Hi All
I am getting lot of comments abt a post in which I wrote a script for Monitoring the job without director, But I have removed that due to some code issue.

Here, I wrote a small script to check the job status without director...


Thursday, January 03, 2013

Killing Ghost Processes in DataStage


how to kill GHOST datastage processes that can result if you are disconnected from the network while you have a datastage object opened. This results in not being able to open a job


1) Logon to DataStage server using a telnet tool like Putty with your DataStage userid

2) Run the following  command:

Wednesday, January 02, 2013

Speed up your Lotus Notes performance by tuning the JVM

Lotus Notes uses Java Virtual Machine (JVM) for processing of Lotus Notes applications and plugins. 

IBMs Lotues Notes client configuration has a standard value that defines how many megabytes of RAM Lotus Notes can maximally use for JVM. This value is for PCs with above 1 GB RAM initially set too low, as it should be approx. 1/3 of the RAM of the PC (default value = 256 MB, but should be 768 MB).

Tuesday, January 01, 2013

An introduction to MQ - Part1


In a nutshell, WebSphere MQ is an assured delivery mechanism, which consists of queues managed by Queue Managers. We can put messages onto, and retrieve messages from queues, and the movement of messages between queues is facilitated by components called Channels and Transmission Queues.
There are a number of fundamental points that we need to know about WebSphere MQ:
  • All objects in WebSphere MQ are case sensitive
  • We cannot read messages from a Remote Queue (only from a Local Queue)
  • We can only put a message onto a Local Queue (not a Remote Queue)