XTIVIA BLOG
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...
How Much Memory is DB2 Using?
Memory usage can be an issue for DB2 whether a server has 2 GB or 2 TB of memory. There can be issues with making DB2 use all of the memory, and there can be issues with DB2 causing paging or even kernel panics. Because of this, it is important to understand how much memory DB2...
Collecting Statistics in DB2
Statistics are the most basic element of DB2 performance. One of the first questions any consultant or support person will (should!) ask you when you come to them with a query performance problem is when the last runstats was run for the tables involved. What are Runstats? The...
A Road Map Is Required for a Successful BI Program
What would you like your business intelligence program to look like two years from now? Imagine that your software applications shared common data, and that data was clearly defined and understood by those who managed and used it. Imagine business teams would...
Customizing the InforCRM Address Dialog
The address control in InforCRM 8.2 (and other versions) is implemented as a semi-dynamic Javascript widget. I say semi-dynamic because while the widget is driven by configuration, the configuration is very much hard-coded. In this post I will examine how to do common...
How to fix Importing ERROR In SQL Developer Data Modeler 4
Symptom: Very recently, using SqlDeveloper 4 Data Modeler I tried to pull and import schema object data (i.e tables) to create an Entity Relationship Diagram ERD from an Oracle database. After carefully going through the required steps, I kicked off the import process. An error...
Including a custom stylesheet in InforCRM
There are 3 main ways to include a custom stylesheet in your InforCRM client: Add it to SageStyles.jsb so that it gets compiled into sage-styles.css - this is the best performance approach. It is relatively upgrade safe but not completely Create a custom module to load it -...