XTIVIA BLOG
Allocation of Primary Logs in DB2
Recently, we noticed on a staging environment that the LOGPRIMARY setting was set to 35, yet the number of logs on the log path was only 21. Number of primary log files (LOGPRIMARY) = 35 35 Number of secondary log files (LOGSECOND) = 45 45 db2inst1# ls -ltr total 13440704...
Understanding DB2 LUW Error Messages
DB2 LUW Error Messages are some of the more descriptive ones I have seen in the computing world, but maybe everyone thinks that about their chosen specialty. Truly understanding error messages can take a bit of practice and knowledge, so I thought I would share a few tricks and...
Setting Up the Infor CRM Desktop Manager
While Infor CRM works on most browsers, there are certain features that require the installation and configuration of the Infor CRM Desktop Manager. These features are: Mail Merge (Currently only works with Internet Explorer 32 bit and a 32 bit version of Microsoft...
Tip #10 – Storage – Top 10 Tips for SQL Server Performance and Resiliency
This article is part 10 in a series on the top 10 most common mistakes that I have seen impact SQL Server Performance and Resiliency. This post is not all-inclusive. Most common mistake #10: Storage For the final post in the top 10 items that influence the performance and...
Tip #9 – Automatically Shrinking Your Database – Top 10 Tips for SQL Server Performance and Resiliency
This article is part 9 in a series on the top 10 most common mistakes that I have seen impact SQL Server Performance and Resiliency. This post is not all-inclusive. Most common mistake #9: Automatically Shrinking Your Database This is a topic that has been written about...
Including Custom JavaScript in InforCRM
When you need to include a custom JavaScript in the InforCRM web client, the quickest way is to simply add the <script> tag to the base.master file. However this complicates upgrades because the base.master file is often modified in Infor's web updates, and it...
Backup Strategies For Sql Server Data Warehouses
This discussion provides an understanding of what is included in a sound backup strategy for your Sql Server data warehouse application. Most data warehouse applications require a different backup and recovery strategy than a typical online transaction processing (OLTP)...
DB2’s Self-Tuning Memory Manager (STMM)
DB2's Self-Tuning Memory Manager (STMM) was introduced in DB2 9.1. The default for new, single-partition databases was ON from the beginning. What is STMM? DB2's Self-Tuning Memory Manager can allocate and change the size of specific memory areas including the total memory used...
Oracle EBS 12.2 Install with startcd50 – Fatal Error: TXK Install Service Exit=1 (Solved/Workaround)
Ran into an issue today while installing a multi-user EBS Suite install using the latest startCD50. Thought I would share this to help some others if they run into the same problem. The error: Applying one-off patches Using...
Tip #8 – Default TempDB Settings – Top 10 Tips for SQL Server Performance and Resiliency
Tip # 8 – Default TempDB Settings Top 10 Tips for SQL Server Performance and Resiliency This article is part 8 in a series on the top 10 most common mistakes that I have seen impacting SQL Server Performance and Resiliency. This post is not all inclusive. Most common mistake...