We received an email asking that we restart a given server as the ATG lock manager had a required lock and a scheduled job could not move forward. I don’t like to do that without some triage. We were stuck…
Querying hive from Excel
Install 32 bit driver from the following URL https://downloads.cloudera.com/connectors/hive-2.5.5.1006/Windows/ClouderaHiveODBC32.msi Start Excel and run the query wizard Create a new Data Source Enter the values shown below Enter the values shown below Click the Test button Select the stores table from…
Purging Akamai cache
To purge content from the cache on the Akamai edge servers, you can use the main LUNA control center, which will push the request out to the edge servers affected. As such, keep in mind the cache is not immediately…
Where is a given thread connecting?
We start by getting the PID of our running JVM… -bash-4.1$ jps 29527 Main 3560 Jps …then we print each lightweight process (threads in our JVM) in which we are interested. In our case, these are threads with zafu in…
Common retail terms defined
Inventory turn rate – How often you replenish inventory given its cost. The impact of this metric is to show efficiently inventory is managed. Dependent on the business, a low inventory turn rate can result in markdowns. For example, if…
Quick way to approximate the RBA for a given SCN
While setting up GoldenGate, we wished there was a way to say “create extract myextract begin scn “, or something similar. However, there is no supported way to get this (of which I am aware at least, but would gladly…