Search found 194 matches

by MT
Thu Feb 05, 2009 5:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Memory requirement of a running job
Replies: 4
Views: 1733

Memory requirement of a running job

Hi,

is there a way to determine how much memory is consumed by a certain job?
I want to know how much memory on the application server is used for a currently running job.



Many thanks in advance
MT
by MT
Thu Feb 05, 2009 12:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Fatal Error
Replies: 4
Views: 2106

Hi,

this is a problem with a sequential stage in a parallel stream.
See APAR JR30587

regards
MT
by MT
Tue Feb 03, 2009 2:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DB2 logs
Replies: 2
Views: 1097

Hi, when you do a clear and insert in DataStage a SQL delete and SQL inserts (one per row) are sent to the database. The database has to do the logging for transaction purposes (to be able to rollback). This all work like desinged and is good though. What you want to do is to Use Commitcount or the ...
by MT
Tue Feb 03, 2009 12:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Client Performance
Replies: 4
Views: 1654

Hi,

the client machines have 4 GB of RAM and are only used for development.
Nobody is downloading big files etc. - monitoring the net does not show any peaks.

Michael
by MT
Mon Feb 02, 2009 9:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Client Performance
Replies: 4
Views: 1654

Client Performance

Hi, we are facing problems with a very varying client performance in DataStage 8.0.1 (AIX) and Clients running on Windows Vista. Opening or closing a transformer or just renaming a link can take up to more than a minute - while in other cases it just performs normal (within some seconds). This also ...
by MT
Fri Apr 04, 2008 12:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Commit Size in DB2 Bulk Load Stage ?
Replies: 8
Views: 5282

Hi, the Db2 Load utility writes directly to the storage (containers) and does not use the SQL insert. Therefore the data can not be commited until the load utility finishes. BUT there is an option SAVECOUNT which implements consistency points - similar to commit but not on a SQL basis. So SAVECOUNT ...
by MT
Thu Apr 03, 2008 1:34 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Performance for multiple Lookups
Replies: 4
Views: 1439

ArndW wrote:Could you post both the error message you get and your system virtual memory setting?
Hi Arnd

I do not get any ewrror - it is just too slow

The memory configs are default so far

kind reagards
Michael
by MT
Thu Apr 03, 2008 1:26 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Performance for multiple Lookups
Replies: 4
Views: 1439

Performance for multiple Lookups

Hi, my job starts with a flat file and enriches data by 20-30 lookups. For performance reasons I have selected the data into hashfiles so the lookup source is alsways a hashfile. Because I have so many lookups and hashfiles the configured memory is not big enough to hold all data in RAM. The option ...
by MT
Wed Feb 06, 2008 2:10 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Listing / Finding BEFORE SQL Statements
Replies: 1
Views: 676

Listing / Finding BEFORE SQL Statements

Hi, I want to trace a bug in a projekt (multiple Jobs) and therefore I have to find a certain drop / delete table statement in BEFORE SQL section of DB2 stage. The problem must have come in by copying a stage with a BEFORE SQL statement from one job to an other - so the BEFORE SQL is still deleting ...
by MT
Tue Feb 05, 2008 6:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error while connecting to DB2
Replies: 3
Views: 1465

Re: Error while connecting to DB2

Hi have you done other extracts from DB2 before or is this your first try? If you haven't extracted data from the server before check out the DB2 connectivity There is a good document under http://www.ibm.com/developerworks/db2/library/techarticle/dm-0609xu/ I have done lots of extracts from DB2 but...
by MT
Mon Feb 04, 2008 10:22 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Loading NVarchar Fields into SQl server 2005
Replies: 2
Views: 2610

Re: Loading NVarchar Fields into SQl server 2005

Hi I'm loading Unicode data to a SQL Server using NLS MS1252 This works fine Maybe you should try this as well regards Michael Hi, I am trying to load english data into a NVarchar field in a SQL server 2005 Database Table. I am using ODBC stage and NLS mapping is set to none. For certain records I a...
by MT
Mon Feb 04, 2008 10:19 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to configure the DB2 Plug In in UNIX for server
Replies: 4
Views: 3364

Re: How to configure the DB2 Plug In in UNIX for server

Hi I'm not sure what you mean with configure in your post but there is a quite good document from IBM on the Web about Configure DB2 remote connectivity with WebSphere DataStage Enterprise Edition http://www.ibm.com/developerworks/db2/library/techarticle/dm-0609xu/ Check out the developer site for m...
by MT
Thu Jan 31, 2008 11:03 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Codepageconversion for BINARY fields in DB2 stage - why?
Replies: 3
Views: 1171

Hi Ray thanks for the reply. I havn't read this - where can I find it? I browsed through the DB2 stage documentation and it is clearly stated that the DB2 datatype CHAR FOR BIT DATA maps to the DataStage type SQL_BINARY. So the question is still why DataStage does not exclude the binary data from co...
by MT
Thu Jan 31, 2008 2:37 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Codepageconversion for BINARY fields in DB2 stage - why?
Replies: 3
Views: 1171

Codepageconversion for BINARY fields in DB2 stage - why?

Hi, I can not understand the DataStage logic in DB2 stage when working with BINARY data, maybe one can help me or maybe it is a bug? When I select binary data (DB2 datatype: CHAR FOR BIT DATA) in my DB2 stage - having NLS UTF8 - it will result in a NLS Mapping error in the log. This means that DataS...