PX db2 insert job hangs after processing...
Posted: Fri Feb 25, 2005 11:54 am
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 out of 20 tries it successfully processed all 3 million rows into the table??
Does this sound like an issue with the nodepools being specified? or perhaps the database connections???
Any suggestions are appreciated...
The job will insert around half the records and then hang (typcially 1.5 million rows at this point). But, maybe 2 times out of 20 tries it successfully processed all 3 million rows into the table??
Does this sound like an issue with the nodepools being specified? or perhaps the database connections???
Any suggestions are appreciated...