by XTIVIA | Feb 9, 2017 | Blog, MySQL
A MySQL error commonly encountered is to have “packet too large” reported and it is often coupled with a “lost connection to MySQL server during query” error as the server closes the connection. The errors occur when a MySQL communication...
by XTIVIA | Feb 8, 2017 | Blog, MySQL
The MySQL InnoDB storage engine is used by default in all newer versions of MySQL (5.5.5+). As a well-performing transactional storage engine with crash recovery capability, it is the storage engine of choice for most database settings. One of the most important...
by XTIVIA | Jan 11, 2017 | Blog, Db2
What is db2prereqcheck? db2prereqcheck is a tool IBM provides to check for all OS and software prerequisites prior to and during the installation of Db2. It is included with every fixpack and base code that Db2 provides. When to use db2preqcheck Use db2prereqcheck...
by XTIVIA | Dec 14, 2016 | Blog, Db2
The row size for a table in Db2 is important in several ways. It determines which page size can be used for a tablespace, and it can help us estimate table size – either optimal or future. Selecting a Page Size Db2 page sizes are adjustable only for tablespace...
by XTIVIA | Jun 15, 2016 | Blog, Db2
Today is the day! On June 15, 2016, a new version of Db2 is being released! IBM has also announced that Db2 9.7 AND Db2 10.1 will reach “End of Support” on September 30, 2017. There is so much information flying out there, so I thought I’d share some...
by XTIVIA | Apr 19, 2016 | Blog, SQL Server
Just as your car needs its oil changed, tires rotated, and fluids checked every few thousand miles, your database is a complex machine that relies on maintenance to function well. A health check is important to pinpoint problem areas so you can supplement your...
