Creating a new Facet in Websphere Commerce

Found a nice article on creating a facet in Websphere Commerce and thought of sharing this on my blog for future reference.

Click here for details

DB2 Backup and Restore commands

It is very common in projects to keep the backup of database and restoring the new copies of database. Following are the two commands which will be helpful in backup and restore of database

DB Backup :

• Open db2cmd prompt
• Navigate to the directory where you want to take the backup of your database
• Enter the command db2 backup db DBNAME compress  (Replace DBNAME with your database name)

DB Restore: 

• Open db2cmd prompt
• Navigate to the directory where your database copy exists or the database which you want to restore
• Enter the command db2 restore db DBNAME (Replace DBNAME with your database name)

Note : Sometimes after restore of the database WC Server might not start properly. In such cases do a setdbtype and the server will start properly

Web Analytics Product Comparisions:

Product Comparision between the industries leading web analytic products

Reference : http://web-analytics-review.toptenreviews.com/

Creating a new store with desired store id in Websphere Commerce

The store_id for the new store is pulled from the KEYS.COUNTER column. You need to edit the COUNTER column value corresponding to the column tablename='storeent' in KEYS table like below,

The new store_id is generated by value of "KEYS. COUNTER (column value) +1". To get a desired store_id, you can increase or decrease the present COUNTER column value from KEYS table as long as "COUNTER (column value) +1" value is not used in the STOREENT.STOREENT_ID column.

Important Note:
1. If you try to decrease the KEY.COUNTER column value to get a desired store_id, whenever you restart the server then KEY.COUNTER column value is increased by KEY.PREFETCHSIZE column value. So after restarting the server, if the new COUNTER (column value) +1 matches the STOREENT.STOREENT_ID then it will throw an error when you try create a new store.
2. Remember to backup the tables before doing an update.

Reference : http://www-01.ibm.com/support/docview.wss?uid=swg21626815

Integration of Websphere Commerce with MQ

 Following link provides the detailed steps for WCS Integration with Websphere MQ

http://www.websphereusergroup.org/webspherecommerceguru/blog/2012/03/07/integration_of_wcs_commerce_with_mq

Creating Websphere Commerce e-Spot using SQL's

Sometimes as a part of project requirement you might need to create espots for your eComemrce website. Instead of creating them through Management Center it is easy to create through SQL's.

Recently found a nice article which explains the different tables used as a part of eSpot creation. Following is the URL for creating eSpots using SQL's

http://www.daharveyjr.com/creating-a-websphere-commerce-e-marketing-spot-wsql-text-content/

Displaying Numeric Keypad only on mobiles for Numeric Inputs on Forms

In order to display Numeric Keypad only on mobiles/tablets create the <input> types as "number" or "tel" for telephone numbers as shown below

<input type="tel" name="mobilenumber"/>

<input type="number" name="age"/>

or

<input type="text" pattern="[0-9]*" /> (Works only for iOS)