Search found 2 matches
- Tue Aug 05, 2008 4:21 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: postgres - strange sql
- Replies: 2
- Views: 1115
Thanks for quick answer. It seems like database sends answer for this query but in the transaction. So datastage waits for all data from this table. It takes time, datastage servers takes more and more memory and processors are killed (almost 100%) Maybe it is a problem of transactions seting on dat...
- Tue Aug 05, 2008 3:29 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: postgres - strange sql
- Replies: 2
- Views: 1115
postgres - strange sql
Hi all, I defined job that reads data from informix odbc and writes to postgres odbc. Problem is that job gets data from source and don't write to destination. In postgres logs i have that - conection recived... - some sets - some select from metastage_loc_info that does not exist - select which i d...