by XTIVIA | Oct 28, 2015 | Blog, Data Management, Databases
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...
by XTIVIA | Oct 22, 2015 | Blog, Data Management, Databases
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...
by XTIVIA | Oct 19, 2015 | Blog, Databases
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...
by XTIVIA | Oct 14, 2015 | Blog, Data Management, Databases
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...
by XTIVIA | Oct 8, 2015 | Blog, Databases
The option binlog_ignore_db can be used to exclude certain information from the binary log by setting the option equal to a given database name. However, we advise our clients to not use this option. Why? The binary log is a valuable resource for point in time...
by XTIVIA | Oct 6, 2015 | Blog, Data Management, Databases
Data Corruption is something that no one really wants. Yet every now and then, we see some customers run into this. Any such issues are almost always the result of disk or SAN level issues. You will see errors like this: SQL1655C The operation could not be completed...
by XTIVIA | Oct 2, 2015 | Blog, Cloud, Databases, Enterprise Infrastructure, Enterprise Java, Portals
Microsoft recently updated the Azure SQL database to only allow encrypted communication. Now communication between Azure SQL Database and your application requires encryption (SSL) at all times. If your client application does not validate certificates upon...
by XTIVIA | Sep 24, 2015 | Blog, Databases
With fixpack 5 of DB2 10.5, IBM introduced Native Encryption for data at rest in DB2. This is a fairly significant new feature for introduction in a fixpack. It does require separate licensing – either the Advanced Edition of ESE or WSE or the separate purchase...
by XTIVIA | Sep 22, 2015 | Blog, Databases
How to run diff on Informix configuration (onconfig) files IBM introduced a new tool in Informix 11.70.xC4 called “onconfig_diff”, located under the $INFORMIXDIR/bin directory. This tool will show you the difference between two onconfig files in an easily...
by XTIVIA | Sep 19, 2015 | Blog, Business Intelligence, Data Warehousing, Databases, Enterprise Infrastructure
20 years ago when I got a 80386 Windows-95 PC with ¾ inch Floppy Drive, 4 MB RAM (I don’t remember the HDD capacity – I believe it was around 120MB or so) from my infrastructure guy, I felt like I’m hero on the street advertising to everyone the great piece of...
