(Marco Deluca and Bosco Li) This article describes how to use CKEditor with WebSphere Commerce. It explains how to add custom cascading-style-sheet (CSS) so your content displays similar to your store. It also describes how to add custom fonts and responsive design templates to the palette.

(Troy L Coleman) Certain DB2 changes can cause your application package to be marked invalid. When this occurs, the VALID column of SYSIBM.SYSPACKAGES will contain a value of other than “Y.”

(Jim Cooper) SQL on IBM i includes expressions and functions for working with date and time values. Externally, date values are character strings containing numbers for the year, month, and day and (in some formats) date separators.

(Lockwood Lyon) Prudent disaster recovery planning involves the ability to recover your data to a consistent point (the recovery point objective, or RPO) within a limited time period (the recovery time objective, or RTO).

(Jack Vamvas) Question: When I try to view the *.evt file in $DBHOME/db2event/db2detaildeadlock it looks like binary. I’d like to be able to read the details in human readable format. Is there a DB2 utility to format the event monitor trace file data?

(Vasfi Gucer) Based on the open source Cloud Foundry technology, IBM Bluemix is an open-standard, cloud-based platform for building, managing, and running applications of all types such as web, mobile, big data, new smart devices, and so on. Bluemix abstracts and hides most of the complexities that

(Lockwood Lyon) Big data is the latest craze. Hardware and software vendors have overwhelmed IT departments with high-speed analytical software, proprietary high-performance hardware, and columnar-based data stores promising quick access and lightning-fast answers to ad hoc analytical queries.

(Kent Milligan) After my last article, I had a number of readers express interest in a solution that would work on servers running pre-IBM i 7.1 operating system release levels. Luckily, recursive SQL capabilities were first made available with the DB2 for i V5R4 release, so this article will provid

(Yang Gao and Kevin Yu) Search solution is an important feature in the WebSphere Commerce product, and is widely used by Commerce customers. Therefore, it is important for customers to understand the best practices to optimize Search solution performance.

(Troy L Coleman) Software vendors that develop products for the IBM z/OS mainframe know that when new DB2 features are introduced, the old features must still be able to function so that applications running on z/OS aren’t affected.