XTIVIA BLOG
How to Extract Data Using db2audit
One of our customers recently wanted to extract data using db2audit, but the documentation on this topic is very limited and scarce. Moreover, the commands have changed after V9.7 and finding documentation or following it could be tricky. After some testing, we were able to...
Logging into the Infor CRM Mobile Client with an iPhone / iPad
We're often asked, why can't I login to the Infor CRM (SalesLogix) mobile client using my iPhone / iPad? Here are some common things to check on your device: 1) Click on Settings 2) Click on Safari --> Under Privacy and Security...
Conditional Styling of InforCRM Grid with onStyleRow
This is a very common request - the customer wants to see some rows highlighted in the data grid based on the data. For example, they might want to see opportunities with a sales potential above $1M highlighted in green. How might we achieve that in InforCRM? There is no...
Creating Instanceable Liferay Portlets with AngularJS
AngularJS is a great framework for Single Page Applications (SPAs) - it's easy to learn and use. There's no reason not to (and actually every reason to) create your Liferay portlets as AngularJS SPAs. Our organization considers this a primary implementation...
Tip #7 – Disaster Recovery Plans – Top 10 Tips for SQL Server Performance and Resiliency
This article is part 7 of a 10 part series explaining the most common mistakes that I have seen in reference to SQL Server Performance and Resiliency. However, this post is not all-inclusive. Most common mistake #7: Disaster Recovery Plans Often when people hear “disaster...
DBCC CHECKDB() Error 17053
During routine integrity checks one of our Virtual-DBA customers encountered an error 17053 was encountered causing the job performing these tasks to fail. Investigating the problem further this information was also included with the error in the SQL Error Log: Operating system...
Remotely Accessing Liferay Documents
This blog post explains using HTTP to remotely get and add documents to Liferay’s Document and Media Library. Since documents may require authentication for access, this post explains how to use basic authentication to achieve that. It will also cover accessing documents in a...
Informix onclean – Rescue command for Informix DBAs
The Informix “onclean” command was introduced in Informix 11. I am sure that most Informix DBAs have occasionally faced a situation where the Informix instance won’t come online due to an improper shutdown, killed process, interrupted restore, or an instance crash. In...
Why AngularJS? Why now?
Should we use AngularJS? Should we use it now? In light of the announcement by the AngularJS team to release AngularJS 2.0 as a total rewrite, it is a valid question to ask: Should we build new applications on AngularJS 1.x? And given that 2.x is not available...
Tip #6 – Change History – Top 10 Tips for SQL Server Performance and Resiliency
Tip # 6 – Change History, Top 10 Tips for SQL Server Performance and Resiliency This article is part 6 in a series on the top 10 most common mistakes that I have seen impacting SQL Server Performance and Resiliency. This post is not all inclusive. Most common mistake #6: Not...