XTIVIA BLOG
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...
Three reasons to not use binlog_ignore_db in MySQL
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 recovery and for...
How to Recover From DB2 Data Corruption
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 due to an...
Liferay Clustering with TCP Unicast
A key step for setting up a reliable Liferay environment is to configure Liferay clustering. Liferay clustering can be achieved in multiple ways. Some of the supported clustering methods are UDP Multicast, UDP Unicast and TCP Unicast. While Multicast is recommended for...
Connecting To Azure SQL Via JDBC SSL
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 connection, your...
Customize InforCRM / SalesLogix customer portal security
The customer portal security can be customized by implementing and registering a IEntitySecurityService. Practically, this means extending CustomerPortalSecurityService and overriding 3 methods (and optionally a 4th one): BuildRestriction - add a restriction to a criteria based...
Keeping Mobile Users Informed Using Liferay Push Notifications
Today we will demonstrate part two of the XTIVIA Mobile Demo application for Android. If you haven't watched part one you should check it out by clicking here. Since the last video we have added several new features that will be covered: Revamped article listing that...