DB2 Merge Query Example (Adding WC SHPARRANGE Records)

DB2 Merge Query Example (Adding WC SHPARRANGE Records)

So, I was recently working on a client engagement and was needing to update the WebSphere Commerce SHPARRANGE table, to enable certain functionality in an external application. Not knowing what data already existed in the production system, I wanted the ability to write a query that would update existing or insert new data, to verify the records that I needed to exist.

[ Read More ]

DB2 Database Backup and Restore Using the Command Line

DB2 Database Backup and Restore Using the Command Line

I was recently working with an off-shore developer, trying to get their WebSphere Commerce database updated to a state that it can be used with the current state of the WebSphere Commerce project I’m currently working on. They were having permission issues when attempting to run a database backup and restore through the IBM Control Center for DB2 on Windows. As a result of the need to control the user credentials that will be backing up and restoring the database, I put together the following commands that can be ran on the command line to perform database backup and restore operations, and figured I’d share these with everyone.

[ Read More ]

Setup, Start or Schedule an Aurora Page Layout w/SQL

Setup, Start or Schedule an Aurora Page Layout w/SQL

On my last post, Create and Enable Aurora Page Layouts in WebSphere Commerce, I left the last step in that tutorial to be completed through the use of Management Center by business users. As there are sometimes where it’s entirely a techie responsibility, I wanted to follow that post up with the actual SQL used to setup and schedule that newly created page layout to the actual WebSphere Commerce page.

[ Read More ]

Create and Enable Aurora Page Layouts in WebSphere Commerce

Create and Enable Aurora Page Layouts in WebSphere Commerce

As part of WebSphere Commerce v7.0 Feature Pack 5, IBM released a new feature, the Aurora page layout framework, that has the potential to significantly allow the business users to maintain and change specific page designs and content, schedule them, and prioritize them based upon business or creative needs.

[ Read More ]