Posts Tagged DB2

Linoma Starts Off the Year with Several Product Releases

Posted by on Friday, 18 June, 2010

When things get hectic and life gets crazy, let’s face it, we could all use a release. All puns aside, Linoma Software has been busy the past 5 months issuing several releases which provide our current and future clients the business edge they need in this ever changing market. Linoma released updates for Surveyor/400, Crypto Complete, GoAnywhere Services and last but not least GoAnywhere Director.

In February, Linoma released Surveyor/400 3.7. Surveyor/400 allows users to easily query and download data from IBM i to their desktops and network servers. Version 3.7 provides support for Excel 2007 with custom formatting options to create professional-looking spreadsheets. Surveyor/400 additionally supports earlier versions of Excel, as well as CSV, fixed width text, HTML and XML documents.  Surveyor/400 conveniently provides over 20 IBM i tools in one application.

In addition to Surveyor/400, Linoma also released Crypto Complete 2.20 in February. The new release of Crypto Complete 2.20 incorporated tokenization. Tokenization should be considered when sensitive data is stored on multiple systems. Tokenization is the process of replacing sensitive data with unique identification numbers (e.g. tokens) and storing the original data on a central server in encrypted form. By centralizing sensitive data, tokenization helps to thwart hackers and minimize the scope of compliance audits such as PCI. Additionally, Crypto Complete 2.20 offers faster encryption for backups while eliminating the need for intermediate save files.

Let’s fast-forward to June; Linoma released GoAnywhere Services 1.3.0. Version 1.3.0 adds enhanced security features with IP Filtering, Syslog feeds and additional Trigger actions, along with other updates and usability options. GoAnywhere Services is a secure file server that provides internal and external trading partners with a secure connection to your system for exchanging files within a fully managed and audited solution.

Also in June, Linoma released a new version of GoAnywhere Director. GoAnywhere Director 3.2.0 provides a connector for sending data using the AS2 version 1.2 standards. This includes support for multiple file attachments within a single AS2 message, synchronous MDN receipts and message integrity verification. AS2 messages can be sent over an SSL tunnel, making it a secure option for the transfer of sensitive data. Version 3.2.0 also includes Syslog server integration, advanced scheduling options, enhanced server certificate handling and FTP checksum validation options. GoAnywhere Director is a managed file transfer solution for the enterprise.

If you need any additional information about any of our product releases or if you need a solution and aren’t sure what is the best product for your circumstance, give us a call. If we don’t have the product your business needs, we can point you in the right direction.

It has been a great start to 2010 and we would like to say thanks to all of our clients for their continued support.

SQL Field Procedures in IBM i 7.1

Posted by on Tuesday, 20 April, 2010

Field Encryption on the IBM i just got easier.

SQL Field Procedures are a new DB2 feature in version 7.1 that allows a user-specified “exit” program to be called whenever data is read from, inserted into, or updated in a field (column).   This is somewhat similar to database column triggers; however there are two distinct advantages:

  1. Field Procedures allow data to be modified on a Read operation, which allows the exit program to automatically decrypt the field value before it is returned to the customer’s application.
  2. Field Procedures provide a separate internal space to store the encrypted version of the field value.  This allows organizations to encrypt numeric fields such as packed decimal, signed decimal and integer data types without having to store the encrypted values in a separate file.

While IBM provided the hooks into the database with Field Procedures, they rely on 3rd party vendors like us to provide the encryption functions and key management. Linoma worked closely with IBM to test the new Field Procedures and provide feedback to their development team during the early release beta program for 7.1.  This also allowed Linoma sufficient time to fully integrate Field Procedures into Crypto Complete for readiness when i 7.1 ships.

We’re excited about Field Procedures since it will allow customers to implement column-level encryption on the IBM i without modifying their applications.  This is especially important if a customer is running a canned application and/or does not want to modify their source code.

1.800.949.4696  |  sales@linomasoftware.com  |  privacy policy
Copyright ©1994 - 2012 Linoma Software  |  All rights reserved