Follow the steps to enable SQL logging in WCS
- Log in to WAS Administrative console
- Select Troubleshooting->logs and trace->server1->change log details levels
- Expand element com.ibm.ejs.persistences.* & enable all Messages and traces for com.ibm.ejs.persistence.EJSDBCFinder and com.ibm.ejs.persistence.EJSJDBCPersister
