..It will be mostly updates after the initial load has taken place.
But, I should of stated that when encountering the issue I have truncated the table between runs to force it to just inserts and the problems still exists. THanks Neal
Search found 3 matches
- Fri Feb 25, 2005 12:07 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: PX db2 insert job hangs after processing...
- Replies: 3
- Views: 1926
- Fri Feb 25, 2005 11:54 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: PX db2 insert job hangs after processing...
- Replies: 3
- Views: 1926
PX db2 insert job hangs after processing...
I have a PX Job that is to upsert records to a DB2 table. The job consists of a sequential file which goes through a transformer and then the DB2 stage which performs the upsert. The job will insert around half the records and then hang (typcially 1.5 million rows at this point). But, maybe 2 times ...
- Tue Jan 25, 2005 1:02 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: so* directories or opf* files within DataStage Project dir
- Replies: 5
- Views: 3399
so* directories or opf* files within DataStage Project dir
We are having space issues with our file system and noticed a bunch of very large files under the DataStage Project dir for our project. -rw-rw-r-- 1 sxxxmgr isxxxd 142646488 Nov 19 12:54 ./DataStage/Projects/ISC_PROD/sojTIcya/opf__0 -rwxrwxr-x 1 sxxmgr isxxxd 142646488 Nov 19 04:11 ./DataStage/Proj...