Hi, I've documented these debugging tips on the Trafodion wiki here:
https://cwiki.apache.org/confluence/display/TRAFODION/Debugging+Tips#DebuggingTips-EnvironmentVariablesandTrafodionProcesses https://cwiki.apache.org/confluence/display/TRAFODION/Debugging+Tips#DebuggingTips-CatchingSQLErrorsattheSource Feel free to comment and/or correct. Dave -----Original Message----- From: Dave Birdsall Sent: Wednesday, April 5, 2017 2:19 PM To: [email protected] Subject: RE: I want to get a core file on a particular SQL error. How to do it? Thank you, Wei-Shiun! Yes, that's exactly what I was trying to remember. -----Original Message----- From: Wei-Shiun Tsai [mailto:[email protected]] Sent: Wednesday, April 5, 2017 2:18 PM To: [email protected] Subject: RE: I want to get a core file on a particular SQL error. How to do it? Not sure about CQD, but adding ABORT_ON_ERROR=<error num> to ms.env would do what you want to do. Thanks, Weishiun -----Original Message----- From: Dave Birdsall [mailto:[email protected]] Sent: Wednesday, April 5, 2017 2:14 PM To: [email protected] Subject: I want to get a core file on a particular SQL error. How to do it? Hi, I dimly remember that there was a CQD or environment variable that one could use in a debug environment to cause a core when a particular SQL error occurs. Can anyone supply the missing details? Thanks, Dave
