Db2udb API stage

Ratan Babu N · Post by **Ratan Babu N** » Sat Jun 03, 2006 12:26 am

Hi,
I am using a Db2udb API stage to delete the records.
In the stage, Input- SQL - User Defined tabpage
I used Delete statement and the number of records to be deleted is 6 million.
But the job is aborted with the following message

APT_CombinedOperatorController(0),0: Operator terminated abnormally: received signal SIGSEGV

ArndW · Post by **ArndW** » Sat Jun 03, 2006 3:18 am

The SIGSEGV signal is indicative of an error, but you need to supply a lot more information before it can be diagnosed. Does the error occur when deleting only a couple of hundred rows? Does it always appear with the row? If you go to a single node configuration file do you have the same problem?

DSguru2B · Post by **DSguru2B** » Sat Jun 03, 2006 11:24 am

Is it a conditional delete? Or you are wiping away all the records and then doing a load?
If the later i would advice you to do a load replace from /dev/null to clear the table (truncate).
If the former, then as ArndW mentioned, the SIGSEVG signal is indicative of an error. The error might be pertaining to the database, as you are doing a logged activity for 6M records (delete)