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
Db2udb API stage
Moderators: chulett, rschirm, roy
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)
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)
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.