DB2 Database Backup and Restore Using the Command Line
Database

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
WebSphere

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 ]

Retrieve WebSphere Commerce Merchant Key
WebSphere

Retrieve WebSphere Commerce Merchant Key

I recently was working on a client project in WebSphere Commerce, specifically within the payment framework and needed to update some data within the PPCEXTDATA table. As I needed to encrypt the data specific to the WebSphere Commerce instance, I needed to discover the plain text merchant key to encrypt the data so it could be read and decrypted properly.

[ Read More ]