Hi Dave, The mxosrvr logs to a log file in the $MY_SQROOT/logs directory and each time an mxosrvr startsup a file of the form master_exec_<node name>_<mxosrvr pid>.log is created. This is where all the log info goes. So you could put out a message to say look at that file. Since you can get the current processes' pid and node number programmatically, you could put out this message I guess.
The log file location and logging Trafodion uses is pretty standard - nothing different than Hbase and other products. Thanks Sandhya -----Original Message----- From: Dave Birdsall [mailto:[email protected]] Sent: Monday, August 22, 2016 3:59 PM To: [email protected] Subject: Log files for SQL processes in Trafodion Hi, I’m interested in logging some information to log files from Trafodion SQL processes. I’m aware of the QRLogger class and the sqlmxevents directory. The situation is this: 1. In metadata upgrade, I want to drop user views on the Repository tables. 2. I’d like to be nice to the user and log the view text for him/her so he/she can recreate them afterward if he/she desires. 3. SQL log files are a pain to find. Let’s face it. On work stations, they are in incubator-trafodion/core/sqf/logs and on clusters they are somewhere else (I forget just where). And there are zillions of them, one per process. 4. So, I’d like to tell the user, as part of the metadata upgrade output, just which log file I logged his view text to. Now the question: How do I find the log file name programmatically? It looks like QRLogger and sqlmxevents don’t provide a method for this. Under the covers they use log4cxx and it’s not obvious how to get this info out of log4cxx. I’m hoping someone knows the answer before I spend time teasing it out of log4cxx. If we think Trafodion users are well-versed in the location and searching of log files, I can satisfy myself by putting some string in the log file that they can grep for, but this seems clumsy and inelegant to me. I’d rather just tell them exactly where to look. Thanks in advance for your help, Dave
