DSXchange

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

Hi,

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

regards
MT

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 ...

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

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 ...

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 ...

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

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 ...

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 ...

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...

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...

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...

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...

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...