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
