Tag Archives: IBM
Cognos and SPSS
SPSS enables extracting the essence of the heaps of data available today, and as a result dramatically reducing the time to present actionable information to decision makers. Continue reading
IBM Security Tools
IBM has a comprehensive approach to encourage security by design. A free Red Book is available for developers: The IBM Redbook for Security in Development The home page for IBM’s main security testing tool is IBM Rational AppScan Share and … Continue reading
DB2 9.7.2 Log files on Windows 7
Problem Since Windows Vista (that includes Windows 7), the place where programs store some of their information has changed. This makes finding the DB2 log files (equivalent of db2diag.log) more difficult. Solution The log files have moved under the directory … Continue reading
How to clear the IBM Lotus Domino server's dns cache
Problem When the domino server caches an MX record, and that record changes, it may take time before the cache is refreshed. In some instances it is desirable to have the DNS cache refreshed on demand. Solution On the Domino … Continue reading
Create Explain Tables in DB2 9.7
Problem The explain tables allow to create access plans and visualize them. Before the explain feature of DB2 can be used, the EXPLAIN tables need to be generated. Solution To create the EXPLAIN tables, the following command needs to be … Continue reading
IBM Domino SSL Keyring File access error when using SMTP TLS
Problem When using SMTP TLS, the IBM Domino server shows the following error in the log file: SSL Error: Keyring File access error Solution When engaging the STARTTLS command, the Domino server looks in the default location for the Keyring … Continue reading
LDAP Authentication with IBM Domino Server 8.5.1
Problem When using a complex email infrastructure, multiple email servers are involved usually. The core servers typically take care of managing the data that users access in their day to day activities. Other servers can be used for SPAM/Virus filtering, … Continue reading
DB2 Query Writing Best Practices
Problem Writing efficient SQL SELECTqueries for DB2 can be tricky. Some general SQL guidelines apply, and there are also specific practices that apply only to DB2. Solution Here is a list of tips you can use to write good SELECT … Continue reading
NFS Locking Problem on Net App connected IBM Domino Server 8.5
Problem One of our IBM Domino servers all of a sudden decided that it couldn’t get an exclusive lock on its database files any longer. The databases happened to be on a NetApp head, and even after rebooting the server, … Continue reading
AIX 6.1 OS Patches the Easy Way
Summary Patching AIX can be intimidating at first for someone coming from the Windows / Linux world. AIX has capabilities that natively support production quality operations. One of these qualities is that one can install patches on an alternative volume, … Continue reading