IBM WCS ( Websphere Commerce ) - Quick Reference / Cheat Sheet

Bookmark this Page!

Important Links

Managment center (CMC)
https://localhost:8000/lobtools - wcsadmin/wcsadmin
Accelerator
https://localhost:8000/webapp/wcs/tools/servlet/ToolsLogon?XMLFile=common.mcLogon&storeId=0
Admin Console
https://localhost:8002/webapp/wcs/admin/servlet/ToolsLogon?XMLFile=adminconsole.AdminConsoleLogon&storeId=0
Org Admin Console
https://localhost:8004/webapp/wcs/orgadmin/servlet/ToolsLogon?XMLFile=buyerconsole.BuyAdminConsoleLogon&storeId=0

Dynacache
https://localhost:9043/cachemonitor/
WasAdminConsole
https://hostname:9043/ibm/console

Config Files

WC config
[Toolkit Folder]/xml/config/wc-server.xml

Promotion Engine Configuration
[Toolkit Folder]/xml/PromotionEngineConfiguration/WCSPromotionEngineConfig.xml

Folders

Log Files
[Toolkit folder]/wasprofile/logs/server1/*.log

Temp folder
[Toolkit folder]/wasprofile/temp

Changing DB

Go to WCTK\bin
Execute the following command -

setdbtype oracle C:\oracle\product\10.2.0\db_1 <ServiceName> <DBAName> <DBAPwd> <DBUserID> <DBUserPwd> <DBHost> <DBServerPort>

Enabling Traces

Tracing log into wasconsole
Right click on the server -> goto admin console
Upon logging in go to Servers -> Application Servers
Click Server 1
Click "Logging and Tracing" under Troubleshooting.
Click "Change Log Detail Level"
Enter the following and click Ok.

*=info:enable.trace.log.*=all:
com.ibm.websphere.commerce.WC_USER=all:
com.ibm.websphere.commerce.WC_SERVER=all:
com.ibm.websphere.commerce.WC_ACCESSCONTROL=all

Tracing SQL logs into wasconsole
Follow the above steps and add following
*=info: com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement=all

EJB Tracing
*=info:EJBContainer=all:PMGR=all.

Promotion Engine Tracing
Go to folder WCTK -> xml -> PromotionEngineConfiguration
Open WCSPromotionEngineConfig.xml
Set <Debug>true</Debug>

Enabling CMC ( open laszlo logs )
Right-click LOBTools and click Properties. Select OpenLaszlo Settings.
Click Enable the debug console check box. Click Apply.

Important SQLs

Reset WCS admin password

update userreg set logonpassword = '74434f61354f51593862415655304d5268424e54723865685653356151374a2b353163506c4261363730633d202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020'
where logonid='wcsadmin';
update userreg set salt = 'hsdbacehyoyn' where logonid='wcsadmin';
update userreg set status = 1 where logonid='wcsadmin';
update userreg set passwordexpired = 0 where logonid='wcsadmin'; commit;

Roles of user
select u.logonid,r.name,org.orgentityname from mbrrole mbr, userreg u,orgentity org,role r where mbr.member_id=u.users_id and org.orgentity_id=mbr.orgentity_id
and mbr.role_id=r.role_id
and u.logonid ='wcsadmin';

Last created promotions

select * from PX_PROMOTION where rownum <5 order by PX_PROMOTION_ID desc;

Active promotions
select * from PX_PROMOTION where status = 1;

Start Dev Environment
startWCToolkit.bat in [Toolkit Folder]\bin

IBM WCS tips file
[Toolkit Folder]\hintsandtips.html

This post was written by:

Vivek Vermani

WCS Developer

Get Free Email Updates to your Inbox!