DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 104 matches
Author Message
 Topic: Job hanging in Running State
dsusr

Replies: 2
Views: 1207

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Oct 26, 2009 12:12 pm   Subject: Job hanging in Running State
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hello Everyone,

We have a DataStage PX job that is running correctly in dev environment but in test Environment the job is not getting finished and remains hanging in 'Running' State.

This same ...
 Topic: string to decimal conversion
dsusr

Replies: 21
Views: 7824

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sat Oct 24, 2009 1:51 am   Subject: string to decimal conversion
Where are you viewing the output. If the target is table check the precision and scale for the column in target table.
 Topic: Why it is in Sequntial stage? When u read data Fixed format
dsusr

Replies: 3
Views: 1352

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sat Oct 24, 2009 1:48 am   Subject: Why it is in Sequntial stage? When u read data Fixed format
Change the length of Record Length =Fixed to Record Length=12.
 Topic: What port DataStage uses to connect to the databases
dsusr

Replies: 8
Views: 3797

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sat Oct 24, 2009 1:36 am   Subject: What port DataStage uses to connect to the databases
As noted, that's all in the hands on the database and attending DBA.

Please correct me if there is some problem in my understanding of the concepts.

As per my understanding the Database details ...
 Topic: What port DataStage uses to connect to the databases
dsusr

Replies: 8
Views: 3797

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Oct 22, 2009 2:56 am   Subject: What port DataStage uses to connect to the databases


Hi Arndw,

Thanks for replying but I have gone through this thread before posting my question.

The thread is specifically related to the Client connections to DataStage Engine but I didn't f ...
 Topic: What port DataStage uses to connect to the databases
dsusr

Replies: 8
Views: 3797

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Oct 22, 2009 2:46 am   Subject: What port DataStage uses to connect to the databases
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hi,

We just want to know what are the ports which Datastage uses to connect to other Databases on different servers.

Is it going to be port 31538 on which DataStage listens or Are there any othe ...
 Topic: Oracle Enterprise Stage: Converting Blanks to Null
dsusr

Replies: 3
Views: 1797

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jul 01, 2009 6:09 am   Subject: Oracle Enterprise Stage: Converting Blanks to Null
Check $APT_STRING_PADCHAR as well. ...

Hi Ray,

Thanks for the reply but not sure how this variable is going to have an impact on this issue since we are only dealing with Varchar fields. Anyway ...
 Topic: Oracle Enterprise Stage: Converting Blanks to Null
dsusr

Replies: 3
Views: 1797

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Jun 30, 2009 3:26 am   Subject: Oracle Enterprise Stage: Converting Blanks to Null
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hi All,

We are facing an issue while using Load-Append in Oracle Enterprise Stage where all the Blanks are getting converted to Null.

We tried setting the environment variable $APT_ORACLE_PRESER ...
Resolved
 Topic: Limiting rows in parallel job
dsusr

Replies: 5
Views: 1606

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Apr 20, 2009 6:38 am   Subject: Re: Limiting rows in parllel job
Compile the Job in Trace Mode i.e. go to the Job Properties -- Execution Tab and enable the box Compile in Trace mode. Then you can limit the number of records per link for a partition.

Regards,
d ...
Resolved
 Topic: transformer compilation error
dsusr

Replies: 12
Views: 3497

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Apr 15, 2009 3:57 pm   Subject: transformer compilation error
Hi Aggie,

Can you please tell me what need to be added in the LIB and INCLUDE variables of Windows because I have added the C++ library path i.e. "C:\Program Files\Microsoft Visual Studio\VC\lib" i ...
Resolved
 Topic: How to auto-generate metadata?
dsusr

Replies: 8
Views: 2712

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Sep 16, 2008 9:21 am   Subject: How to auto-generate metadata?
Combining schema files and Runtime Column Propogation (RCP) could solve your issue.

You have to use some good shell scripting to resolve this issue....

First you have to read the schema from Or ...
Resolved
 Topic: Removing zeros for decimal values
dsusr

Replies: 7
Views: 2948

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Sep 16, 2008 9:10 am   Subject: Removing zeros for decimal values
If the data type is Decimal you can not remove the non-significant zeroes, because they don't actually exist. They are an artifact of how DataStage displays decimal numbers to prove that precision an ...
Resolved
 Topic: Concatenation of multiple values
dsusr

Replies: 12
Views: 3206

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Tue Sep 16, 2008 8:58 am   Subject: Concatenation of multiple values
Yes. I need your help in stage variable logic. Plz let me know.

First sort the input data to transformer on the key MT_ID, MT_REPLACEDBYID......

In the transformer define the following stage var ...
 Topic: parameter for abort after n rows
dsusr

Replies: 4
Views: 4752

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Sep 15, 2008 5:00 am   Subject: Re: parameter for abort after n rows
Use the transformer options Abort after rows by using the Following Logic.

Use a stage variable to count the number of rejected records. Create a link in the transformer with the Constraint that th ...
Resolved
 Topic: Concatenation of multiple values
dsusr

Replies: 12
Views: 3206

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Mon Sep 15, 2008 4:16 am   Subject: Concatenation of multiple values
You have o write the logic within the transformer to read the previous values.

Do a lookup and you will get the following output from Lookup:

MT_MODELNUMBER, MT_ID , MT_REPLACEDBYID
A 101 1
A ...
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours