Treehouse Software Onsite Training Classes are Available

New installation of a Treehouse Software product? New employees? Need a refresher course? Want to explore untapped product features? Three-to-five-day training sessions are available for tRelational / DPS and other Treehouse products.


Treehouse Software training sessions are customized to meet your site’s unique environment and needs. As an example, the following three-day tRelational / DPS training class was conducted at a large University where they are using tRelational / DPS to create an archive of their legacy Adabas data to Oracle in preparation for their upcoming mainframe system retirement.

Over the course of the three-day session, the Treehouse instructor covered:

  • tRelational AUTOGEN feature (auto-generation of complete RDBMS schemata – Tables, Columns, Primary Key, and Foreign Keys – based upon existing ADABAS file structures). AUTOGEN was quite attractive since it will be a very time efficient way to create the Adabas-to-Oracle mappings.
  • The customer wanted to use Relational / DPS to automate as much of the process as possible, and take advantage of the batch functions of tRelational. Generally, the workshops of the class are all online, but in this case, the class ran through one online example after the File Implementation section of the training, and then jumped to the batch section of the training to show how that works. The class then returned to run additional File Implementations, Analysis, and Reporting in batch.
  • The class continued through the Modeling and Mapping section, and ran more batch jobs with some additional Adabas files.
  • Admin and Configuring DPS Parameters sections were next on the agenda. Because of the desire to automate as much as possible, the work focused on how to set up a single job stream that could be generated programmatically, where it was fed in the name of the file to be implemented and then do the AUTOGEN all in the same job. The tRelational AUTOGEN user exit was set up so the customer could identify and cater to the possibility of duplicate table names where multiple Adabas files have the same named MU (like “COMMENTS”); and handle the addition of an ETR (external transformation routine) being automatically added (there were some known HEX values in some fields) and then update the DPSCOLLGTH.
  • The class finished up the Materialization (initial loading of data) training section and then set up the jobs to run Materialization, and installed DPSSPLIT (used to separate the control and data files into one control and one data file per table materialized) on one of their servers. Generally, most class attendees are not the ones responsible for running the Materialization and Propagation (ongoing synchronization of data) jobs, so the instructor doesn’t usually set them up, but in this case, it made sense. The class started out by running the Materialization from a full database ADASAV taken over the weekend. The output of the Materialization job was FTPed to their Server and DPSSPLIT run against it to create the individual loader files. GENDDL (generate the control statements that can be passed to the RDBMS to define the tables and columns) was also run and that output transferred. After setting up the SQL job to process the DDL, the Oracle SQL*LOADER was successfully run to load the data.

Finally, the class went through some additional tRelational / DPS features, and as a final exercise, set up a Propagation job and ran it against a current PLOG just to make sure it worked satisfactorily.


If you are interested in finding out more about Treehouse training classes for your product, contact Treehouse Software today for more information, or to schedule onsite training.

TREETIP: TRIM’s Real-Time Monitor Provides a Window into Your Adabas/Natural World

by Joseph Brady, Manager of Marketing and Technical Documentation at Treehouse Software, Inc.

Adabas/Natural customers need a reliable, effective, and efficient way to analyze and optimize performance. TRIM is a robust performance monitor for Adabas and Natural. The TRIM Real-Time Monitor provides a wealth of key performance statistics, including:

  • Adabas activity in various categories across time intervals
  • Session statistics
  • Adabas queues and tables
  • And much more.

TRIM screen shot examples…

TRIM Real-time Monitor Commands Per Minute Screen:


TRIM Real-time Monitor Commands Within File Screen:


This information can help the site quickly find and eliminate performance problems, and online help, PF-Keys, Direct Commands, and other features simplify TRIM usage.

Reminder of the Special Offer For CA APAS/Insight and CA PLEU Customers…

If your company uses CA APAS/Insight and/or CA PLEU, you have been notified that support for the products is longer be provided by CA. As a result, we are pleased to extend a special offer to CA APAS/Insight and CA PLEU customers to adopt comparable Treehouse Software solutions, and enjoy the assurance of our commitment to supporting and updating TRIM, AUDITRE, NatCDCSP, NatQuery, and our other solutions that complement ADABAS and NATURAL.

Treehouse Software representatives are ready to help you implement our solutions to address your key requirements — all at specially-discounted pricing.

Visit the Treehouse Software website, or contact us to discuss your needs.

Register Today for the Software AG TechEd 2015 User Conference!

By Wayne Lashley, Chief Business Development Officer for Treehouse Software

In 2014, I attended Software AG’s inaugural “TechEd” conference, held in Chicago in April. This was a free event, modeled loosely on the annual European “Software AG International User Groups”, offering customers the opportunity to attend presentations and get information that would otherwise be left to regional user group meetings—which have been largely discontinued—and/or to Innovation World. Several dozen Adabas/Natural customers attended last year, and their reviews were positive.


This year, TechEd returns to Chicago on April 21-22, 2015. I and others from Treehouse will be attending, and I will be presenting “Treehouse Software: Maximize and Revitalize Adabas/Natural”, about how our real-world customers are implementing strategies to integrate, modernize and extend mission-critical Adabas/Natural applications by leveraging Treehouse products and services.

While the conference will include not just an Adabas/Natural track but also tracks for webMethods, Terracotta, ARIS and Alfabet, there will be two full days of Adabas/Natural-related content. Topics include Adabas/Natural futures, zIIP Enabler for Natural, Web/mobile enablement, modernization/integration, Adabas SQL Gateway and Event Analytics for Adabas/Natural/EntireX, in a mix of Software AG and customer presentations. And in the evening of April 21, Software AG will host a customer celebration social event.

For the last half-day of the conference, Becky Albin will be giving her Adabas v8.3 Master Class. This is something that you would normally expect to have to pay for, but in this case it will be included at no charge. Something not to be missed!

I strongly encourage all Adabas/Natural customers to sign up for the *FREE* TechEd 2015 at See you in Chicago!

A Job Well-Done by Treehouse Software Consulting Services for Swiss Reinsurance Company, Ltd.


Since 2002, Treehouse Software consultants have provided DBA services for the Software AG (SAG) mainframe environment at Swiss Reinsurance Company, Ltd. (Swiss Re). Treehouse services included all SAG product support and upgrades for ADABAS, NATURAL, NATURAL Security, PREDICT, and COM-PLETE.

Additionally, Treehouse consultants installed the TRIM ADABAS and NATURAL Performance Monitor product to help in monitoring ADABAS and NATURAL usage, and the tRelational / DPS product set was used for converting and archiving Swiss Re’s ADABAS data as the new Oracle-based systems were implemented.

As this chapter of the long-time Treehouse Software / Swiss Re partnership has drawn to a close, we express our gratitude for having such a good and loyal customer, and we appreciate their sentiments towards us:

“Thank you for your professional and prompt DBA and support services to Swiss Re for the last many years. You have kept our systems on the most current level of software upgrades, helped us to successfully migrate our mainframe from in-house facilities to an outside provider, as well as migrate from the Toronto system to a global platform-based L&H system, and finally provided archival data extracts for the total decommissioning of the Toronto system.

At all stages we have received excellent and cost-effective services from Treehouse.

We sincerely thank each one of you for helping us achieve our goals. Best wishes for the future.”

Sheila Gupta
Vice President, Information Technology
Swiss Reinsurance Company Ltd.

About Treehouse Software Consulting Services

At Treehouse Software, our business is mainframe systems software and services. We know that organizations using mainframe systems for their business operations are feeling the pressure to be more efficient and to contribute to overall enterprise cost savings, and we’re here to help.

Customers can take advantage of Treehouse’s decades of experience in mainframe optimization, systems security, control, auditing, performance enhancement, etc. Our Mainframe Consulting and Remote DBA Services can be a life-saver when dwindling financial and human resources make it difficult to maintain past levels of IT services for an organization.

Treehouse Software’s expert consultants can provide ADABAS/NATURAL performance analysis, environment tuning, and optimization; development, training and implementation services involving any Software AG technology; help with special routines or user exits for ADABAS/NATURAL; product installation, upgrades, and training; data transfer and integration; and DBA services.

Contact Treehouse Software for more information on our Consulting Services.

Upcoming ADABAS/NATURAL-Related Event: Software AG Eastern Region User Group Meeting


We encourage Treehouse Software customers and blog visitors to register for this event.

Date and Time: August 7th, 2014 (Thursday), 8:30am – 3:00pm

Place: Reston, VA 1856 Old Reston Avenue, Suite 100 – MetroStar Systems Reston, VA 20190

Phone: 703.481.9581 ext. 0


8:30 – 9:00 am Registration and Continental Breakfast
9:00 – 9:10 am Welcome & Introductions – Amarish Pathak UG President
9:10 – 9:30 am AAFMAA & MetroStar Success Story – Amarish Pathak, AAFMAA
9:30 – 10:15 am Realware to Real Time – ADABAS Data Distribution – Don Knepper, Tomy International
10:15 – 11:00 am Automating Application Business Rules with Adabas-Natural – Eugene Miklovich, DoBee Sys
11:00 – 11:15 am Break
11:15 – 12:00 pm NATURAL Code Versioning – It’s a MUST!” – Wendi Herrington and Rusty Sodergren, Penn State University
12:00 – 12:45 pm webMethods Presentation – Subhash Ramachandran, Software AG
12:45 – 1:45 pm Lunch
1:45 – 2:30 pm webMethods Presentation – Sachin Gadre, Software AG
2:30 – 3:30 pm Aris Presentation – Markus Linsin, Software AG
3:30 – 4:30 pm Alfabet Presentation – Frank Engelbert, Software AG

Click Here to be taken to the registration page, provided by Software AG.