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
Search found 194 matches
- 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
- 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
- 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 ...
- 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
- 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 ...
- 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 ...
- Thu Apr 03, 2008 1:34 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Performance for multiple Lookups
- Replies: 4
- Views: 1439
- 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 ...
- 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 ...
- 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...
- 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...
- 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...
- 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...
- 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...