XTIVIA BLOG
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 -...
How to Connect to a DB2 Database
To run any SQL or perform runstats or other actions, you must establish a connection to a DB2 database. Connecting to a Database Connecting to an existing database on the same database server the database exists on, or connecting to an already cataloged database is fairly...
How to Catalog a DB2 Database
In order to connect to a DB2 database that is not on the server or workstation you're connecting from, you'll need to make DB2 aware of that database by cataloging it, unless you're using JDBC type 4 drivers. JDBC type 4 drivers do not require that a database be cataloged, but...
MySQL Query Cache – Use it or Disable it?
Having frequently repeated SELECT queries and their results stored in memory can significantly optimize performance on your MySQL database. The query cache will perform such a task however, you must analyze whether your query cache is effective for your workload or if it is...
SQL Toolbox – SQL Server Job History Audit
Keeping track of SQL Server Jobs is an important part of maintaining a database proactively. The below script pulls a quick list of all jobs, completion status, and date the job ran. Taking this a step further one could have the SQL Server email them a copy of SQL...