BOS Software Soluzioni
BOS Software
Soluzioni

Soluzioni pratiche

Qui troverete soluzioni selezionate e su misura nella pratica dei nostri clienti soddisfatti. Potete anche utilizzare il filtro per selezionare le vostre fonti e i vostri obiettivi e ottenere esempi pratici.

Filtro per:

Ripristino delle impostazioni del filtro »

International Ministry of Transport

International Ministry of Transport

leggi tutto
Management of the road network, driving licenses and vehicle registrations
tcVISION
IBM Db2, IBM IMS/DB, VSAM
Cloud
Close
International Ministry of Transport

International Ministry of Transport

Focus

A state Department of Transport in Australia is responsible for the administration of the state's road network. The administration of all driver's licenses and vehicle registrations is also a departmental responsibility.

Environment
  • IBM mainframe with the z/OS operating system
  • VSAM files and IMS and Db2 databases on the mainframe
  • Cloud systems under AWS and AZURE
Target

Reduction of the high maintenance and operating costs of the old applications, lack of experienced staff and dependence on the existing data led to the decision to transform the legacy application, to provide a modern data platform and - in connection with this - to build new business services.

Implementation

By using tcVISION, a cost-efficient and modern infrastructure was built.

The transformation of legacy systems met customer expectations with new services:

  • Internal and external users get data access via new interfaces and update functions.
  • Reduced dependency on mainframe data and resource access.
  • New business functions were enabled by integrating modern elements (APIs, mobile apps, digital channels).
  • The time to market of new business services has been significantly reduced due to the interoperability of modern hardware and software.
  • The timely and bidirectional data synchronization by tcVISION between the mainframe data and the new platforms forms the basis for successively converting other legacy systems and implementing new business initiatives.

The results are examples of a gradual modernization of mainframe applications on new platforms. It is mandatory to synchronize the data between the mainframe and the new platform in real time. Both data storage platforms (mainframe and Windows Azure Cloud and AWS) are equal. Data changes can be carried out on both data platforms. Bidirectional data replication is therefore essential. This is carried out by tcVISION in real time and thus supports a gradual modernization or migration without having to create your own synchronization modules and programs.

tcVISION
IBM Db2, IBM IMS/DB, VSAM
Cloud
International Authority

International Authority

leggi tutto
Training and education service, services and job placements
tcACCESS
VSAM
Application program
Close
International Authority

International Authority

Focus

The customer offers services based on legal requirements in the area of training and education services as well as employment agencies.

Environment
  • IBM mainframe with z/VM and z/VSE operating systems
  • VSAM files on the mainframe
  • Windows workstations with Visual Basic applications
Target

Access to productive VSAM files for processing unemployment claims and checking basic social security data with the social security agency.

Implementation

Before using tcACCESS there was no way to authenticate this information. With the help of tcACCESS, the customer is now able to integrate data from VSAM files into Microsoft Visual Basic applications via standard SQL queries. These applications perform processing and validation.

The customer wants to expand the applications in order to be able to change and maintain VSAM data from a Microsoft Visual Basic application.

Conclusion

tcACCESS is a powerful and versatile solution that enables open systems applications to perform direct SQL access to existing z/VSE and z/OS data resources (e.g. VSAM, IMS, DLI, ADABAS etc.) and mainframe applications direct access to Open Systems data permitted.

tcACCESS
VSAM
Application program
Automotive sector

Automotive sector

leggi tutto
Information, communication and data processing
tcVISION
VSAM
IBM Db2 (LUW), Microsoft SQL Server
Close
Automotive sector

Automotive sector

Focus

The customer offers services for the Dutch automotive sector in the areas of information, communication and data processing.

Replacement of existing mainframe applications and parallel operation of old and new applications.

Environment
  • IBM mainframe with z/VM and z/VSE operating systems
  • Linux servers, UNIX and Windows workstations
  • Database system IDMS, MS SQL Server and Db2/LUW
Target

The network-oriented database system IDMS is to be replaced by the relational system Db2 and MS SQL Server at the same time as a migration of the IBM mainframe to the Unix and Windows platforms.

Implementation

The challenge for this project is to keep the data in both system worlds synchronized in real time as far as possible. This is the only way to phase out the legacy system.

Before the migration, new applications were already developed that access the IDMS databases using SQL with the help of tcACCESS and the use of ODBC from Windows and UNIX applications.

To implement the migration, tcVISION was used to automatically determine all changes in the IDMS in real time and to synchronize them with Db2/LUW and Microsoft MS-SQL Server databases. The IDMS network topology was mirrored in the relational world. It is important that the different systems are completely equal and that changes can be made in parallel. Organizational measures have been implemented to ensure parallel use. This affects applications running under UNIX/AIX and Windows.

Since all applications can make changes at the same time, it must be ensured that changes to a system are not replicated back to the target system after they have been adapted. This is very specific and complex, especially in connection with IDMS. However, the tcVISION loopback procedure ensures error-free processing.

Conclusion

All applications were migrated to the new platforms and databases much faster than originally planned. The use of tcVISION ensured parallel operation between the 3 platforms involved, which ultimately also enabled a problem-free - and shorter than planned - migration.

tcVISION
VSAM
IBM Db2 (LUW), Microsoft SQL Server
Import and wholesale

Import and wholesale

leggi tutto
International trade of mineral oil products
tcVISION
VSAM
Microsoft SQL Server
Close
Import and wholesale

Import and wholesale

Focus

International trade and import and wholesale of petroleum products.

Migration of mainframe applications to new client/server applications.

Environment
  • IBM mainframe with z/VSE operating system
  • Windows workstations
  • VSAM and MS SQL Server
Target

All of the customer's applications have been created over the past decades and are tailored to the company's business processes. Nevertheless, the decision was made to migrate to new systems and new technologies. The previous old system was difficult to manage because the necessary know-how was no longer available or difficult to find. The primary goal was a so-called smooth migration. This meant a completely new development of the trading solution in the Microsoft .Net environment. The legacy system under VSE should be used as a "blueprint" and replaced in phases.

Implementation

The challenge for this project is to keep the data in both system worlds synchronized in real time as far as possible. Only in this way is a phased replacement of the legacy system possible at all. The migration was implemented via mirror tables with the help of tcVISION to replicate the data from both platforms in both directions. The loopback procedure available in tcVISION ensures that changes to a system are not replicated back after adaptation in the target system.

After a short implementation phase, the project was phased into production.

Conclusion

The customer migrated to the new system environment more quickly than originally planned, thereby saving considerable costs for continued use of the old system. With the help of tcVISION, the customer's IT landscape was converted to the latest technologies and is therefore up to the challenges of the global economy.

tcVISION
VSAM
Microsoft SQL Server
Public corporation

Public corporation

leggi tutto
Commercial professional association and carrier of the statutory accident insurance
tcACCESS
VSAM
Oracle, Word processing
Close
Public corporation

Public corporation

Focus

The customer is a commercial professional association and carrier of the statutory accident insurance.

Integration of modern word processing into existing mainframe processes.

Use of modern reporting systems with access to mainframe data by the department.

Environment
  • IBM mainframe with z/VSE operating system
  • Online system under CICS
  • Data management under VSAM, MS Word and Oracle database
Target

The customer's goal was to replace a word processing system installed on the mainframe with a modern office component under MS Windows. However, the COBOL text modules available on the mainframe should continue to be used and used via macros of the word processing and integrated into the individual texts.

The department should be able to independently access the VSAM files using modern reporting tools in order to create the required reports, without having to create an individual COBOL program for each user department requirement.

Another requirement is the daily transfer and processing of VSAM data into the Oracle database system.

Implementation

Formatted templates of the Office component WORD were developed for users in the departments. The user can enter the insurance number via a dialog box. A VBA macro uses the tcACCESS ODBC driver and calls an existing CICS COBOL program via a CALL. The insurance number and parameters relating to the document are transmitted. tcACCESS integrates the COBOL program into its processing, it is executed and the data required for the document is returned to the VBA macro via tcACCESS.

In addition, tcACCESS is used to call up a WORD form letter directly from CICS applications and to equip it with data that is made available by the online application.

The VSAM data structures, which have grown over decades, are very complex and are processed daily by tcACCESS and transferred directly to an Oracle database.

Conclusion

The use of tcACCESS creates a perfect symbiosis between information and applications that are stored and processed on the mainframe and modern, new applications. The integration of modern workstation-based applications with the business logic on the mainframe was transparently implemented for the department. The department can continue to create necessary evaluations and queries independently without having to use IT programming resources.

tcACCESS
VSAM
Oracle, Word processing
Financial economy

Financial economy

leggi tutto
Leading manufacturer-independent leasing company
tcVISION
VSAM
Datamart, Oracle
Close
Financial economy

Financial economy

Focus

The customer is a leading manufacturer-independent leasing company.

Introduction of a data mart and stabilization of the service level agreements with the department.

Environment
  • IBM mainframe with z/OS operating system
  • UNIX and Windows workstations
  • VSAM file format and DB2 and Oracle databases
Target

The aim was to replace old technologies with new applications. The new technologies should be implemented according to the "hub and spoke" principle, i.e. the data from the old applications of the mainframe is transferred to a so-called staging area and processed there in a data mart according to the business processes. The staging areas are Oracle databases.

In addition, the replacement of the old technologies should guarantee and stabilize compliance with the service level agreed with the department for the availability of the online systems.

Implementation

The initial implementation consisted of nightly batch processing with the transfer of data extracted from Db2 or VSAM and transferred via FTP. However, this method quickly reached the limits of this form of processing. The batch window was not long enough to transfer the data and the customer ran the risk of not being able to meet the service level agreements.

The decision to replace the existing process was made with tcVISION. The changes in Db2 could be determined directly and in real time or via log files and transferred to the staging area. An analogous procedure was implemented for the VSAM files after batch processing. The tcVISION batch compare method was selected for this purpose.

Conclusion

The process went into production in a very short time and the expectations were more than met. On average, 6 hours of processing time per day were saved. The data is available to the department at 9 a.m. and all service level agreements are met. Another advantage was the drastic saving of mainframe resources through the use of tcVISION.

tcVISION
VSAM
Datamart, Oracle
Public corporation

Public corporation

leggi tutto
Digitization of public procedures
tcACCESS
IBM IMS/DB
Application program
Close
Public corporation

Public corporation

Focus

Digitization of public procedures

Environment
  • Mainframes running z/OS
  • IMS databases
  • Online systems under IMS TM
  • ORACLE in the client/server environment
Target
  • Integration of IMS databases and applications with client/server applications and applications
Implementation

tcACCESS is used in various areas with the aim of realizing digitization for both customers of the administration and departments. The diverse connectivity options of tcACCESS are used to access the IMS databases and IMS applications.

A client/server application accesses an IMS database via SQL statements and makes the data available to the end user.

Further integration via tcACCESS is the call of IMS programs directly from the client/server applications. The STORED PROCEDURE function of tcACCESS is used for this. Communication with tcACCESS takes place either via ODBC or JDBC. The IMS program is started and transfers the information to tcACCESS for further processing.

This is a fast and secure method to transparently integrate the existing business logic on the mainframe into the new client/server application.

Data is collected daily via applications and stored in an ORACLE database. This database is read at the beginning of the batch processing and entered into IMS via the tcACCESS JDBC interface and processed by the mainframe application

tcACCESS plays an important role in the daily process. During mainframe processing, tcACCESS tasks are started that retrieve additional information from the open systems and integrate them into mainframe processing.

Another application is the start of print jobs with parameters from IMS applications. The print jobs are JAVA applications. These access IMS databases with SQL statements on the basis of the parameters passed and start the print jobs on selected printers in the network.

Conclusion

tcACCESS helped the customer to digitize IMS applications transparently and quickly and to open up new areas of application.

tcACCESS
IBM IMS/DB
Application program
Materials management

Materials management

leggi tutto
International manufacturer of quality furniture
tcACCESS
IBM DLI
Web-Anwendung
Close
Materials management

Materials management

Focus

BOM (Bill-of-material)  under web applications

Environment
  • Mainframe with DL/I and z/VSE
  • Online systems under CICS
  • Networks with Windows
Target
  • Online access to mainframe data
  • Integration of mainframe and open system resources into web applications
Implementation

The customer is an international manufacturer of quality furniture. All materials management and bills of materials applications are own developments and tailored to the special requirements. The data is stored in hierarchical DL/I databases.

The aim is to implement materials management and parts list processing in the company network via web applications and to combine the information from the DL/I databases with the corresponding graphics from product planning.

The original plan to migrate from DL/I to a relational database was discarded for cost reasons. The decision in favor of tcACCESS was made on the basis of a reference visit to a tcACCESS customer.

tcACCESS represents the link between the mainframe and the web applications. The parts list information available in the DL/I databases can be retrieved from the web applications via SQL requests. The hierarchical DL/I data is thus treated like relational tables.

Information per application is stored in a MySQL database and specify which fields in the DL/I database should be accessed and whether SQL functions (e.g. SUBSTR, LEFT, etc.) should be used for certain columns, as well as color attributes of the values in the browser.

With the help of this information, the data is read and processed via tcACCESS. Changes in the DL/I databases (new or modified or deleted fields or segments) can thus be easily made in the SQL database without having to change the access programs.

The application is being used by the department and has been received very positively, especially the web interface and the associated options for easily linking components to one another.

Conclusion

The application has been received very positively by the department, especially the web interface and the associated options for easily linking components with one another.

The DL/I database became a relational database.

tcACCESS
IBM DLI
Web-Anwendung
Airport

Airport

leggi tutto
Passenger movements, baggage traffic, refueling and cleaning of the aircraft
tcACCESS
VSAM
Web application
Close
Airport

Airport

Focus

General airport information

Environment
  • Mainframes running z/OS
  • Online systems under CICS
  • Networks with Windows and UNIX systems
Target
  • Online access to mainframe data
  • Integration of mainframe resources in open system applications
  • Porting of mainframe applications to WINDOWS
Implementation

The user is an international European airport.

The first steps in the mainframe modernization were so-called face-lift attempts, i.e. the beautification of the classic 3270 masks. This however was not enough to integrate the mainframe world with the open systems.

After a test installation, the decision for tcACCESS was made.

tcACCESS allows direct access from JAVA, C++ and VB applications via SQL statements to the mainframe's VSAM files. Aircraft positions on the apron and the staffing at each gate are processed under Windows or UNIX and displayed via web applications.

Access to the mainframe data through tcACCESS enables the airport to coordinate all activities around the gates, monitor and graphically display passenger movements, baggage traffic, fueling and cleaning of the aircrafts.

Conclusion

Significant advantages were achieved through the use of tcACCESS. The mainframe is an important, invisible part of the new systems and the goal of Enterprise Application Integration was successfullyimplemented.

tcACCESS
VSAM
Web application
Public Corporation

Public Corporation

leggi tutto
Increase in productivity in the user department
tcACCESS
IBM Db2, VSAM
Word processing
Close
Public Corporation

Public Corporation

Focus

Increase in productivity in the user department

Environment
  • Mainframe with z/VSE
  • Online systems under CICS
  • VSAM and Db2 data management
Target
  • Integration of a Windows word processor with online mainframe applications
Implementation

A new Windows word processing system is used company-wide in the user departments. All productive data is stored on the z/VSE mainframe under VSAM and DB2 and processed with CICS applications.

By using tcACCESS, the Windows word processing was integrated completely transparently into the CICS application.

The user works with a CICS application, e.g. the customer address data. The selection screen for over 400 different word processing templates is called up via a function key.

The desired form is selected. The CICS application starts the word processor on the user's workstation and passes the template name and a variable list containing mainframe data to a word processor macro. The macro reads the list of variables and inserts them into the desired document.

The finished word processing document can now be further processed individually by the user.

Conclusion

The transparent integration of a modern word processing into existing CICS applications was realized in a short time with tcACCESS and existing on-board resources. In addition, other operative solutions for the data center and the operating and work preparation staff have been created with tcACCESS.

tcACCESS
IBM Db2, VSAM
Word processing
Church data center

Church data center

leggi tutto
Ecclesiastical electronic reporting
tcACCESS
tcVISION
Software AG ADABAS
Microsoft SQL Server
Close
Church data center

Church data center

Focus

Ecclesiastical electronic reporting

Environment
  • Mainframe with z/VSE
  • Online systems under CICS
  • ADABAS data management
Target
  • Migration of ADABAS databases to Microsoft SQL Server
Implementation

The electronic registration procedure manages the church registration data with about 13 million people from a total of about 9000 parishes. tcACCESS and tcVISION synchronize the  data between the z/VSE mainframe and the new application under WINDOWS with the SQL server database.

Two challenges had to be mastered for the migration of the application:

  1. The transfer of data from the mainframe with simultaneous conversion to MS SQL Server.
  2. Timely synchronization of 70 ADABAS tables with changes both on the mainframe and on Windows (bi-directional).

In particular, the special storage formats of ADABAS (multiple groups, multiple fields and a combination of both) are taken into account by the synchronization via tcVISION and implemented under MS SQL Server.

Important for the customer is the fact that tcVISION writes detailed logs and all changes are well documented.

The goal of processing all changes bidirectionally has been implemented.

All changes made by the parish offices in the SQL_Server database via the web application will be applied into the ADABAS database via tcACCESS/ODBC. tcVISION records these changes and they must not be propagated back to the MS SQL server. tcVISION offers a so-called LOOPBACK method for this. Changes made directly in ADABAS on the mainframe are replicated by tcVISION to SQL Server. The LOOPBACK function prevents replication back to ADABAS.

Conclusion

By using tcVISION, the migration could be carried out in a much shorter period of time than originally planned. With the help of tcVISION, the diocese has created modern, new applications that are used online by the diocese's parishes, thus enabling the greatest possible transparency in the administration of the parishes and their citizens.

tcACCESS
tcVISION
Software AG ADABAS
Microsoft SQL Server
Billing service

Billing service

leggi tutto
Consumption-based billing of energy costs
tcVISION
IBM DLI
IBM Db2
Close
Billing service

Billing service

Focus

Consumption-based billing of energy costs

Environment
  • Mainframe with z/VSE
  • Online systems under CICS
  • DL/I data management
Target
  • Migration of the DL/I databases to Db2
Implementation

The changes made in the productive DL/I databases in daily production operation by online users and through batch operation are captured by tcVISION in real time and written to a special Db2 table - or, if Db2 should not be active, to a VSAM file. These changes are processed at regular intervals and applied to the Db2 databases.

Once the migration is complete, changes in Db2 are also replicated from tcVISION to DL/i in order to comply with legal archiving regulations.

The daily change volume is more than 200,000 changes, at the peak more than 500,000.

Conclusion

Meanwhile, the customer has converted almost all applications to the new system and changes to the new system are still being maintained in the old system via tcVISION in order to meet all legal revision requirements. The use of tcVISION ensures orderly parallel operation.

tcVISION
IBM DLI
IBM Db2
Health Insurance

Health Insurance

leggi tutto
Health insurance specialist of the cooperative banks
tcVISION
VSAM
Microsoft SQL Server
Close
Health Insurance

Health Insurance

Focus

Health insurance specialist of the cooperative banks (Volksbanken Raiffeisenbanken)

Environment
  • Mainframe with z/VSE
  • CICS for online systems
  • Data is stored in VSAM files
Target
  • Migration of the VSAM/Cobol applications to Microsoft SQL Server/Java
  • Offloading of VSAM files and loading into SQL server tables as well as a bidirectional replication in real-time between VSAM and the Microsoft SQL server
Implementation

Through tcVISION, a method to recognise bidirectional changes and securely exclude multiple changes was developed.

tcVISION is mainly used to offload VSAM files on a time-controlled base and bulk load them into SQL tables with similar structures. Approximately 30 million data records per week are transferred with this method.

Log files are created to document the correct replication scenario.

Conclusion

The transfer of the VSAM structures, which have developed over decades, into a relational model under SQL Server was made possible with tcVISION without any major programming effort.

tcVISION
VSAM
Microsoft SQL Server
Information Service Provider

Information Service Provider

leggi tutto
tcVISION
Oracle, Software AG ADABAS
Oracle, Software AG ADABAS
Close
Information Service Provider

Information Service Provider

Focus

Central data processing with integrated specialist applications and a central database for agricultural organisations

Environment
  • z/OS system with Adabas
  • Linux with Oracle
  • Mainframe applications in PL/I and NATURAL
Target
  • Bidirectional data synchronization in real-time between the mainframe with Adabas and Linux with Oracle
Implementation

The synchronization scenario is based on changed data capturing on the mainframe in real-time. The Adabas extension of tcVISION captures the changes and these changes are then propagated to a LINUX system using a mainframe collector and data pool storage. The LINUX system hosts an Oracle database that acts as a mirror of the Adabas databases. tcVISION directly propagates the mainframe changes into the Oracle database.

Both platforms act as equals (master/master). The tcVISION DBMS extension for Adabas captures changes on the mainframe in real-time and replicates those changes into an Oracle mirror database, from which the changes are applied to the Oracle production database.

The replication path from Oracle to Adabas on the mainframe is maintained through Oracle and the JDBC component of tcACCESS.

A tcACCESS Stored Procedure developed in PL/I obtains the Adabas Internal Sequence Number (ISN) for new inserted records for the Oracle environment.

The bidirectional replication guarantees that changes already applied on one of the platforms are not replicated back via the capturing mechanisms (tcVISION Loopback processing).

Log files are created to document the correct replication scenario.

Conclusion:

The bi-directional replication was a transparent migration of the applications. The Loopback method of tcVISION guranteed the correct synchronization between the ADABAS ISNs and the corresponding ORACLE tables fpr new record insertions.

tcVISION
Oracle, Software AG ADABAS
Oracle, Software AG ADABAS
Metal Processing

Metal Processing

leggi tutto
Metal Processing
tcVISION
IBM Db2, IBM IMS/DB
IBM Db2, IBM Db2 (LUW), Oracle
Close
Metal Processing

Metal Processing

Focus

Production of fittings systems

Environment
  • IBM mainframe with z/OS and programming language PL/I
  • Windows systems with Db2/LUW
  • Db2/zOS and DL/I databases
  • Oracle data warehouse
  • Various application servers with Java
Target
  • Parallel maintenance of the master data in Db2 and DL/I
  • Migration from DL/I to Db2
  • Implementation of an operational data store involving a near real-time copy of the operational data for reporting purposes
  • Continuous and bidirectional data replication between headquarter and subsidiaries
  • Unidirectional replications between different systems, i.e. between the mainframe and the Oracle data warehouse
  • As little overhead on the two production systems as possible
Implementation

The replication is bidirectional. Both systems are of equal priority and changes applied to both systems must be replicated. The near real-time replication method provided by tcVISION is used. tcVISION extracts all changes found in the Db2 Active Log for tables with the 'Change Data Capture' attribute and replicates them to the partnering system. Since the replication is bidirectional, it is important to assure that changes already applied to one system are not replicated back. tcVISION provides functions to check this in the replication scripts, so a possible loopback effect can be avoided. The replication between the Db2/zOS and the Db2/LUW uses a dedicated LINUX machine.

Conclusion

Successful migration from IMS to Db2 on z/OS.

Bi-directional replication between the Db2 system on z/OS and the Db2 systems on Windows at the subsidiaries.

Development of a data store with timely transfer of operative data for evaluation purposes.

tcVISION
IBM Db2, IBM IMS/DB
IBM Db2, IBM Db2 (LUW), Oracle
Insurance/Pension

Insurance/Pension

leggi tutto
Indemnity, accident and life insurances
tcVISION
IBM Db2
IBM Db2 (LUW)
Close
Insurance/Pension

Insurance/Pension

Focus

Indemnity, accident and life insurances

Environment
  • IBM mainframe with z/OS
  • Db2 as production database
  • Data warehouse
Target
  • Feeding the data warehouse with current Db2 data on a daily basis
  • Shifting the reporting from the mainframe to Db2 tables on a mirrored Db2 database on a Windows server
Implementation

The production implementation of tcVISION supports more than 370 Db2 tables. The operational changes to mirrored Db2 tables are replicated on the Windows replication server. The replication processes are part of the daily IT operations. The online systems and batch applications are responsible for the changes applied to Db2. All tables that are supposed to be replicated have the attribute ‘DATA CAPTURE CHANGES’ and all the changes are kept in the Db2 log. The log files are sent to the replication servers using FTP processes as soon as the online logs are archived by Db2. Once received, tcVISION processes the log files on the replication server. To process the log files and capture the changes, tcVISION has to understand the structures of the Db2 tables. This metadata is stored in a central repository which is also stored in the Db2. tcVISION provides import functions for creating the metadata from the Db2 source database. This metadata is used for the initial load of the Db2 tables to the server as well as for the processing of the Db2 log files.

The initial load of the Db2 tables on the replication server is performed by the BULK TRANSFER function of tcVISION. The input is a Db2 imagecopy that is sent to the replication server via FTP. The copy is processed and loaded to Db2 with the help of a LOAD statement generated by tcVISION. Then, the tables are available on the replication server and changes can be applied via the log file processing.

A special challenge was presented by the Db2 Compression Dictionaries and the fact that the structures of the tables can be changed during the daily operations. The information about the compression algorithm in use is scanned by tcVISION while importing the metadata and stored in the central repository. Each table is stored in a table space of its own. The different dictionary versions and corresponding compression algorithm are kept in the repository, so tcVISION can always use the correct algorithms for the decompression when processing the log files or imagecopies. The metadata reflects the structure of the data at the time of the import. tcVISION historicizes this structural information during a new import after a structure change. This way, tcVISION recognises changes of the data structure and is able to apply the changes to the target tables in accordance with the structure in place at the time the change was performed. That is why all Db2 structural information is refreshed every day by an automated process. This automated process guarantees the correct metadata and compression information to be used. tcVISION provides tools and utilities to delete all the historical repository entries that are no longer required.

Conclusion

The automatic daily processing and transfer of the Db2 changes to a data warehouse, as well as the provision of the Db2 changes on a mirrored system under Windows for evaluation purposes is implemented. Operational structural changes to the Db2 tables under z/OS are automatically recognized and taken into account by tcVISION.

tcVISION
IBM Db2
IBM Db2 (LUW)
Service Industry

Service Industry

leggi tutto
Service Industry
tcVISION
IBM Db2
Oracle
Close
Service Industry

Service Industry

Focus

Management of project planning, implementation and maintenance of infrastructures and technical services; The services are provided to banks, corporations, public administration bodies and central institutions in the areas of credit and debit card processing, collections and payments, capital markets, and network services for connectivity and messaging.

Environment
  • IBM mainframe with z/OS, z/VM, and z/Linux
  • Linux Server, UNIX, and Windows workstations
  • The database efficiency is based on Db2 and Oracle.
Target
  • Replication solution with the lowest possible mainframe load
  • A central console to monitor and maintain all required operations for the data replication
  • Functions to feed the Oracle database, including the initial database load as well as the ongoing replication in "near real-time"
Implementation

The tcVISION replication is based on a central repository which can be stored in any relational database, like Db2 or Oracle. The metadata, transformation and replication rules required by the processing are part of that repository.

tcVISION uses the Db2 Instrumentation Facility to capture the changed data in real-time from the active Db2 log. A combination of archived and active logs is used for the batch processing.

The tcVISION Agents on z/OS are connected to other tcVISION Agents (z/OS and z/LINUX) via TCP/IP. The changed data is applied to the target systems either via Db2 or the Oracle Call Interface (OCI).

The tcVISION Dashboard (GUI) is used to monitor all systems and to define and implement the replication scenarios.

The replication is fail-proof and can be restarted at any time.

Conclusion

tcVISION has proven itself in the need to integrate and synchronize data between the central systems and distributed systems. From the user-friendliness point of view, tcVISION has proven to be a simple and efficient system.

tcVISION
IBM Db2
Oracle
Data Provider

Data Provider

leggi tutto
tcVISION
IBM Db2
Data distribution on Linux
Close
Data Provider

Data Provider

Focus

Data provider for master and transaction data

Environment
  • IBM mainframe with z/OS
  • Db2 as data management system
Target
  • Flexible data distribution
  • Reduction of the data transfer volume
Implementation

The distribution of the subscription data is performed by tcVISION. The subscribed data is captured in real-time from the active log of a shared Db2 system on a z/OS system. The capture mechanism of tcVISION uses the Instrumentation Facility Interface of Db2. The changed data is transferred to an Intel based Linux system via TCP/IP, where the distribution of the data records to the customers is performed based on data record attributes.

Technically this was realised using a bit string as an integer attribute for the relevant tables. A comparison is performed for every replicated record by using a logical bit compare with different comparison values to check whether the record should be distributed to the customer. If the bit comparison is not successful, the record is rejected.

In addition to the bit string logic, a comparison based on a Lookup SQL and character string comparisons are performed. To serve each individual customer based on his requirements, a subscription system has been developed that only transfers the stock exchange values to which the customer has subscribed.

All processing definitions are stored in a central tcVISION repository.

Conclusion

Distribution of financial data to subscription customers. Each customer receives the data corresponding to their subscription.

With tcVISION, enormous amounts of data are constantly being propagated to customers. These large amounts of data (e.g. more than 2 million securities prices per day) can only be managed if the technology components used work perfectly and efficiently.

tcVISION
IBM Db2
Data distribution on Linux
Financial Institution

Financial Institution

leggi tutto
tcVISION
IBM Db2
Apache Kafka
Close
Financial Institution

Financial Institution

Focus

Retail Banking and Small Business, Corporate Lending and Investments, and Treasury Services and Markets

Environment
  • IBM mainframe with z/OS operating system
  • Data Lake Architecture with Apache Kafka Hadoop
  • Company data is held in Db2 databases
Target

Reduction of mainframe load to reduce costs by offloading data from the core database system to a less expensive system in real-time and transferring read operations to the new infrastructure

Implementation

tcVISION is used for the real-time replication and Apache Hadoop is used as a cost-efficient system for storing the data. This can cover additional use cases, such as real-time event handling & stream processing, analytics based on real-time data as well as the possibility to report and analyse structured and unstructured data with excellent performance. The system can be inexpensively operated on Commodity Hardware and has no scalability limitations. Considering the savings, the costs of replication (CPU consumption) with tcVISION are very low.

Conclusion

tcVISION enables a significant reduction in mainframe costs, while being very economical thanks to the log file-based replication. In addition, there is the possibility to implement numerous use cases based on the replicated data, which would be too resource-intensive on a mainframe.

tcVISION
IBM Db2
Apache Kafka