Adabas Vista and Fastpath Questions and Answers
By Michael Meehan, Senior R&D Manager, Software AG
In his capacity as manager responsible for the Adabas "Add-On" products Mike Meehan meets and talks to many current and potential users of these products. In these two articles he answers common questions about and explains the major features of Adabas Vista and Fastpath.
Table of Contents [-]
- 1 Adabas Vista - Overview and Fequently Asked Questions
- 1.1 Background Information
- 1.1.1 Business: Credit Reference Service
- 1.1.2 Business: Mobile Phone Network
- 1.1.3 Business: (Internet) Vehicle Information Service
- 1.2 Vista - Partitioned Files Background
- 1.3 Vista - File Translation Background
- 1.4 Vista – Frequently Asked Questions
- 1.4.1 What influenced your decision to buy / implement Adabas Vista? What were your expectations of the product?
- 1.4.2 Were these expectations met?
- 1.4.3 Can you give us an estimate as to how much CPU (in percentage) you have saved?
- 1.4.4 How easy was the installation?
- 1.4.5 Were there any tuning procedures you had to go through?
- 1.4.6 Did you have to make any changes to your production environment to introduce Vista?
- 1.4.7 What time scale are we talking about to get Vista into a production environment?
- 1.4.8 Would you recommend that other users install Vista?
- 1.4.9 Is there any way in which a customer can estimate the expected CPU gain? Is there a trial kit available?
- 2 Adabas FastPath - Frequently Asked Questions
- 2.0.1 What considerations affected your decision to buy / implement Adabas Fastpath?
- 2.0.2 Were these expectations met?
- 2.0.3 Can you give us an estimate as to how much CPU (in percentage) you have saved?
- 2.0.4 How easy was the installation?
- 2.0.5 Were there any tuning procedures you had to go through?
- 2.0.6 Did you have to make any changes to your production environments to introduce Fastpath?
- 2.0.7 What time scale are we talking about to get Fastpath into a production environment?
- 2.0.8 Would you recommend that other users install Fastpath?
- 2.0.9 Is there any way in which a customer can estimate the expected CPU gain? Is there a trial
Adabas Vista - Overview and Fequently Asked Questions#
Background Information#My recent customer site visits bring me into contact with various uses of Adabas Vista and Adabas Fastpath. A common theme is that Vista is used to replace huge customization software components developed to provide translation of database and file numbers, using Vista’s file translation feature. All these sites also use the other primary Vista feature, file partitioning. Here is a very brief rundown of what can be done using Vista:
Business: Credit Reference Service#One of the partitioned files has 450 million records in 31 partitions, another has 18 partitions. Vista translation is also extensively used to enforce separation between application file numbers and physical file placement.
Business: Mobile Phone Network#One example of partioning at this customer is the Account Statement History file. Just this file takes up around 60 disk packs with hundreds of millions of records partitioned by account number. Vista is the only alternative to keeping planned (and unplanned) outage in a manageable amount of time. Vista translation is used at this site as well.
Business: (Internet) Vehicle Information Service#350 million records growing at 3+ million per month currently using around 45 partitions, partitioned by vehicle registration. Again, the maintenance of such a file demands Vista partitioning. Vista translation is also used extensively.
Vista - Partitioned Files Background#Although Adabas is able to accommodate files with vast amounts of records; these customer sites have found this presents operational difficulties when outage times are required to be minimal to keep the businesses running 24 hours a day. Adabas Vista allows one large file to be partitioned multiple files. Each file is a fully independent Adabas file in its own right. Vista makes the files appear as one to the application. This means the application gets all the advantages of programmatically dealing with one file by retaining lower developing costs through simplicity while the database operations side gets all the advantages with being able to manage smaller files in parallel and/or individually.
Vista - File Translation Background#These sites have used file translation for many years, making the application fully independent of the database and file numbers used. This allows database operations to be fully in control of file placement. For example, files can be placed according to individual operations requirements without the need to worry about the file numbers used in the applications. Originally these sites all used a home-grown file translation customization software framework. The approach was simplistic, inflexible in all cases (it is a very complex subject to solve this software challenge generically) and all these sites had to deal with all the risks associated with being in the software development business. Now, Vista’s generic file translation is used without any drop-off in performance and at the same time there is a massive increase in the flexibility the generic approach provides.
Vista – Frequently Asked Questions#
What influenced your decision to buy / implement Adabas Vista? What were your expectations of the product?#These sites all wished to replace in-house partition and translation software. Over time there are too many risks associated with home-grown solutions. For example, these sites are forced to employ, manage, motivate and retain software development skills. This is a big diversion from their real focus which is database administration and operation. Also, Vista provides a full function answer to translation and partitioning rather than the previous simplistic, inflexible customization. In all cases, the expectations were that all the advantages of Vista could be adopted without a noticeable increase in CPU beyond that already seen by the original customization software.
Were these expectations met?#Yes, exceeded by product-level flexibility over in-house restrictions. For example, Vista can handle access across all partitions of a file for descriptors that are not associated with the partition criteria whereas the home-grown solution could not – a massive improvement in capability and performance.
Also, Vista improves 24x7 coverage. With Vista, it is possible to take individual partitions offline for maintenance leaving the others online for continuous use. Or conversely, all partitions can be taken out of service together with maintenance performed on them in parallel, significantly reducing planned outage time.