Our blog is an invaluable resource for anyone struggling with the challenges of managing a database, applications, or clouds.
We understand the difficulties involved in troubleshooting, building, improving, securing, and operating these platforms,
and we’re here to share our insights and expertise with you. Browse through our collection of blog posts below,
and don’t hesitate to leave your comments and feedback.
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...
Online Defragmentation Do you have large tables that contain too many extents but haven't been able to schedule a maintenance window to reorganize? With the release of Informix 11.70, IBM introduced a new defragmentation utility that lets you reorganize a table or...
A common question asked from super users of applications is, "What is the difference between Windows Authentication and SQL Server Authentication?" While there are many details under the covers of SQL Server and Windows Authentication, the differences can be summed up...
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 and...
A Foreign Key is a constraint. Due to this definition, it only places a limitation on what data can be inserted into a column(s) and does not address the indexes needed to help performance when joining tables Take the following design. If you wanted to join the 2...
Sometimes, the time it takes and the size of the snapshot is too large for easily configuring transactional replication. To deal with this situation, SQL Server offers the ability to initialize the subscriber from the backup of the database at the publisher. Using a...
With the newer releases of the IBM Informix Dynamic Server engine, the capability to perform backups to the file system has been greatly improved. The TAPEDEV onconfig parameter can now be set to a single file, a directory, or the value STDIO for standard output. With...
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 details and...
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...
XTIVIA is highlighting the following new features in SQL Server 2014 and can assist you with the implementation of these features, as well as all other new features available with the 2014 version. We are excited to discuss how implementing new features, can help...