TREETIP: tcVISION Allows for Surprisingly Innovative Uses

tcVISONv6

Treehouse Professional Services consultants help Adabas / Natural customers in a variety of ways, including DBA services, performance tuning, change management implementation and training, and data replication planning and training. Our experience and long history of service to the Adabas / Natural community helps us create innovative solutions for our customers’ challenges.

Recently Treehouse Senior Technical Representative Chris Rudolph assisted a customer with a tricky data replication problem. The customer uses tcVISION to perform bi-directional replication between Adabas and an RDBMS during the phase-in of a new application. Unfortunately, the new application incorrectly updated certain columns in the RDBMS, which were then replicated to Adabas. The customer attempted to address the issue by running a series of ADASEL reports against the Adabas PLOG and manually checking for “bad” transactions, which was a very time consuming process that pulled the Adabas DBA away from her normal duties.

Chris explained that tcVISION could expedite the process by replicating all transactions for the Adabas file to a journal table capturing the “before” and “after” values of the problematic columns. The developers working on the new application could then identify invalid values, correct the application, and patch the data themselves. This also allowed the Adabas DBA to return to their normal duties.

The journal table now includes columns to display the “before” and “after” values of the corrupted column, Adabas transaction time, end transaction time, operation and Adabas userid. The customer’s developers immediately recognized immense value from being able to query the journal table to find bad data, patch the data, prove that corruption is no longer taking place, and verify that all corrupted instances of the data have been patched. Journal tables have been added for all replicated Adabas files, and the developers now rely on the journal tables for all of their data patches.


Find out more about tcVISION — Enterprise ETL and Real-Time Data Replication Through Change Data Capture

tcVISION provides easy and fast data migration for mainframe application modernization projects and enables bi-directional data replication between mainframe, Linux, Unix and Windows platforms.

_0_tcVISION_Simple_Diagram

tcVISION acquires data in bulk or via change data capture methods, including in real time, from virtually any IBM mainframe data source (Software AG Adabas, IBM DB2, IBM VSAM, IBM IMS/DB, CA IDMS, CA Datacom, even sequential files), and transform and deliver to virtually any target. In addition, the same product can extract and replicate data from a variety of non-mainframe sources, including Adabas LUW, Oracle Database, Microsoft SQL Server, IBM DB2 LUW and DB2 BLU, IBM Informix and PostgreSQL.


__TSI_LOGO

Visit the Treehouse Software website for more information on tcVISION, or contact us to discuss your needs.

PRODUCT SPOTLIGHT: tcVISION v6 Overview and Updates

tcVISONv6

Several exciting new features and updates are now in tcVISION v6, including new output targets Adabas LUW, DB2 BLU, EXASOL, Hadoop,and MongoDB. Additionally, new input sources include z/OS VSAM Logstream (CICS and Coupling Facility / Shared VSAM),z/OS VSAM Batch Extension, z/OS DBMS to Logstream, CA IDMS v17, CA Datacom CDC, IMS Active Log and SMF data.

Another feature recently announced is the tcVISION “Direct Loader” for BULK_LOAD processing. The function does not require output to a sequential file, and the loader utility for the target DBMS is called via API with data passed directly. Direct loader supports PostGreSQL, Microsoft SQL Server and DB2 LUW / DB2 BLU. The advantage of using the Direct Loader is the elimination of disk access in writing and reading the sequential loader data file. File output is still supported (e.g., where loader data is to be distributed to other machines).

Finally, as mentioned in a previous Treehouse Blog, with tcVISION v6 comes the newly enhanced web statistics functionality and web server. Any standard web browser can access this server (Internet Explorer, Firefox, Opera, Chrome, Safari, etc.)

This valuable feature enables users to view data from the tcVISION Manager Monitor, and statistical and operational information from the tcVISION Manager network.


Find out more about tcVISION — Enterprise ETL and Real-Time Data Replication Through Change Data Capture

tcVISION provides easy and fast data migration for mainframe application modernization projects and enables bi-directional data replication between mainframe, Linux, Unix and Windows platforms.

_0_tcVISION_Simple_Diagram

Visit the Treehouse Software website for more information on tcVISION, or contact us to discuss your needs.

Join us at the Software AG TechEd User Conference in Austin, Texas

SAG_TechEd_05_2016

The third annual Software AG TechEd User Conference is planned for May 3-4 in Austin, Texas this year. In prior years, this event has developed a reputation for having the best source of technical information in our niche field, as we can learn from our peers and Software AG product experts about best practices, new features and use cases that you can apply on the job, and this year’s conference will be no exception. Of course, there is also the added benefit of being able to network with the largest collection of Adabas/Natural peers in North America.

Register here: http://www.softwareag.com/us/community/usergroup/events/default.asp

In addition to the presentations planned, there will be an Adabas Internals Class offered after the TechEd conference if there is enough interest. This class will be taught by Gene Miklovich with upgraded content for v8. Many people who attended last year’s TechEd conference expressed an interest in this topic, so if you were one of these people and/or are interested in this opportunity, please go to the Software AG Education portal to register.


__TSI_LOGO

 

 

Register Today for December’s Software AG TechEd 2015 User Conference!

By Wayne Lashley, Chief Business Development Officer for Treehouse Software

_0_Treehouse_Software_TechEd_12_2015_Presentation

This year, TechEd returns to Philadelphia, PA on Monday, December 7, 2015. I, and others from Treehouse Software will be attending, and I will be presenting “Essential Capabilities for Adabas-to-Adabas Data Migration”.

Share ideas with, and gain insights from, your contemporaries. Hear how Software AG can help you rise to the challenge of driving your business forward on the shoulders of Technology and Innovation.

I strongly encourage all Adabas/Natural customers to sign up for the *FREE* TechEd 2015 HERE.

See you in Philadelphia!

 

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:

trimmfnrCommandsPerMinuteScreen

TRIM Real-time Monitor Commands Within File Screen:

trimscwfCommandsWithinFileScreen

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 Now for Upcoming Software AG Eastern Region User Group Meeting in Reston, VA

SAG_Americas_User_Groups

You are invited to the upcoming Software AG Mid-Atlantic Region User Group Meeting. Share ideas with and gain insights from your colleagues in the Metro area. Hear how Software AG can help you rise to the challenge of driving your business forward or better reaching your agency’s mission on the shoulders of Technology and Innovation.

Wayne Lashley, Chief Business Development Officer, will present “Revitalize and Maximize Adabas/Natural” on behalf of Treehouse Software.

September 24, 2015 | 8:30 AM – 4:30 PM EST

AAFMAA Partner Location – MetroStar Systems, Reston, VA 20190

Click Here to Register>>


Register Now for Upcoming Software AG Webinar with ConnX and Treehouse Software

_0_SAG_TSI_Webinar_06_2015

Wayne Lashley, Chief Business Development Officer, will present on behalf of Treehouse Software for this webinar. Wayne will show how our real-world customers are implementing strategies to integrate, modernize and extend mission-critical Adabas/Natural applications by leveraging Treehouse products and services.

Thursday, June 25, 2015 | 11:30 AM, EST
Click here to register for this webinar>>