Enable database SQL statement trace log on Dev

1. Logon WebSphere Administrative console.
2. From left panel select Troubleshooting-->logs and trace->server1->change log details levels
3. Expand com.ibm.ejs.*
4. Expand sub element com.ibm.ejs.persistences.*
5. Enable all Messages and traces for com.ibm.ejs.persistence.EJSDBCFinder and com.ibm.ejs.persistence.EJSJDBCPersister.



6. Click OK and Save.
7. Restart App Server.

Listing enabled WebSphere Commerce features in development environment

we can list the features that have been enabled on WCS 7.

1. Run the check enablement status: WCDE_installdir\bin\checkEnablementStatus.bat
2. The status message appears in the log file. WCDE_installdir\logs\enableFeature.log

Create new Websphere Commerce Database schema using developer machine

Steps to follow

1. Create a user (schema) with DBA privileges in oracle 11g.
2. Go to command prompt where WCS Installed
Ex: D:\WCDE_ENT70\bin>
3. Prepare setdbtype.bat statement.
Ex: setdbtype oracle D:\app\testuser\product\11.2.0\client_1 UATDB wcs7 wcs7 wcs7 wcs7 192.168.140.2 1521 createdb

4. Execute the setdbtype.bat file as mentioned above.


5. setdbtype.bat command will open one more window


6. Verify the createdb.oracle.log file.
7. WCS schema created.