XTIVIA BLOG
Tuning Basic JVM Performance for Liferay DXP 7
Over the nearly 10 years that we have worked with the Liferay platform, we have had ample opportunity to hone our understanding of how Liferay interacts with the Java virtual machine (JVM), and how to optimally tune the JVM performance for Liferay as a Java application....
Addresses in InforCRM / Saleslogix
You may have noticed that in recent versions, InforCRM introduced the concept of "Primary", "Primary Billing" and "Primary Shipping" address. This has been a source of confusion for many long time InforCRM / SalesLogix users since these were not concepts they were used to. What...
Using Liferay Resources Importer to Develop Site Content
I'm going to share with you some tips and tricks I've used to keep track of changes with web content during the development stage of a project. To set up the scene, I'm a Front-End developer on a small project with a few back-end developers. The client has a lot of starter...
Infor CRM / SalesLogix – Splitting Up the Values from a Multi-Select Picklist
Customer Question: I have values in a multi-select picklist. Unfortunately many of them no longer exist in my picklist definition. How do I clean these up? Answer: The challenge here is that these values are saved as comma separate values in a single field in the database. For...
DB2 SQL: Rewriting a Distinct with a Correlated Sub-Query to a Group By for Performance Improvement
Sometimes a client calls for help with a performance problem. On one particular Tuesday, a client called about a long-running query. Actually they basically said "What's wrong with DB2? my query is running long! Are there lock timeouts happening?" The query came from a new...
Analyzing Lock Escalation
What is Lock Escalation? When LOCKLIST and MAXLOCKS are not set to AUTOMATIC, or total system memory is constrained, lock escalation can occur. When there is not enough room in the lock list to store additional locks that an application needs to continue processing, lock...
Timing Your SQL Server Maintenance Jobs
Maintenance in General is a necessity for SQL Server. No different than changing the oil in your car or going to the Doctor for the annual exam. There is going to be times when you are going to need to run maintenance on your server. The tricky part is trying to determine when...
Stopping Your SQL Server Jobs
Maintenance in General is a necessity for SQL Server. No different than changing the oil in your car or going to the Doctor for the annual exam. There are going to be times when you need to perform maintenance on your server. The tricky part is trying to determine when you...
Dropping a DB2 Schema and Objects it Contains
It may be something that's not terribly common to have to do, but that makes it all the more important that we document how to do it. Dropping a schema and all of the objects in that schema used to be tedious and time-consuming. We used to have to look for a large number of...
Handling Transactions Across Multiple Liferay API Calls
There are times when you want to handle multiple Liferay API calls as a single, atomic transaction. For example, let's say you have a business process that has the following 3 steps: Create an Organization. Add a Role to the User. Update the User's status. Let's say steps...