log4j logging levels

The amount and type of information shown in the system and event logs is controlled by the log4j settings in the encrypted properties file managed through WBE Properties. Each message on the log is prefixed by the level of the message.

There are 5 levels of logging:

• FATAL: shows messages at a FATAL level only
• ERROR: Shows messages classified as ERROR and FATAL
• WARNING: Shows messages classified as WARNING, ERROR, and FATAL
• INFO: Shows messages classified as INFO, WARNING, ERROR, and FATAL
• DEBUG: Shows messages classified as DEBUG, INFO, WARNING, ERROR, and FATAL

http://publib.boulder.ibm.com/infocenter/wbevents/v6r2m0/index.jsp?topic=%2Fcom.ibm.wbe.uihelp.doc%2Fdoc%2Flog4jlogginglevels.html

SQL to concatenate column values from multiple rows

There are a few ways depending on what version you have

http://www.oracle-base.com/articles/misc/StringAggregationTechniques.php

SELECT pid, LISTAGG(Desc, ' ') WITHIN GROUP (ORDER BY seq) AS desc
FROM   B
GROUP BY pid;

Then join to A to pick out the pids you want.

http://stackoverflow.com/questions/4686543/sql-to-concatenate-column-values-from-multiple-rows