Administration

Running IMS?

Read about GT Software in the "I am IMS" feature in the IMS Newsletter.
 

Are you IMS?

Schedule A Free On-Site Workshop

Discover why Ivory is so...
RAPID. EASY. PROVEN.


Go here for proof

Enter Promo Code Web.

 

Take the survey

Ivory® Data Access administrative functions and batch processors

Administration is done via a Windows workbench application which allows the data access administrator to configure, control, monitor and analyze Ivory Data Access operations. This application also displays all mainframe data sources in a tree structure, showing all field and index information. User-level security ensures that the user is only able to access data sources that are part of his security profile (i.e. RACF).

Based on the information provided by Ivory Data Access, the user can easily select data from mainframe data sources and transfer them to another system without any detailed knowledge of the mainframe or the native data file. Ivory Data Access automatically optimizes access to the data source. Key fields, alternate indexes, descriptors, dub-descriptors and super-descriptors are taken into account to optimize the data access path and system performance.  All the advantages of the SQL engine apply.

Scheduling functions for bi-directional data transfer

Ivory Data Access can transfer data bi-directionally between the mainframe and another system. This data transfer can be completely automated and initiated from either side. The data transfer can be scheduled to start at a specific time or on a specific event. Interfaces are available to integrate Ivory Data Access into existing scheduling procedures.

Structured data transfer

With Ivory Data Access, there is no need to transfer entire files from the mainframe to a workstation and then select the records on the PC for further processing. Ivory Data Access knows the data format and structure, and selects data from mainframe sources based on logical conditions. It then creates a physical record which contains only the desired fields to be downloaded to the PC, within security parameters. This approach also improves performance, increasing the data transfer rate by reducing the amount of transferred information to conserve networking bandwidth.

Compression

To reduce the amount of data transmitted and to provide optimum response times, Ivory Data Access compresses data before it is transmitted and decompresses when it is received. Depending on the file structure and the number of records selected, compression rates up to 90+% can be achieved with the Ivory Data Access compression algorithm, reducing data transfer overhead to the absolute minimum.

Control

 Ivory Data Access also provides logging and monitoring functions that create audit trails for every communication request. The log data can also be used for charge-back procedures. Data transmission procedures can be automated and integrated into IT process flows. Every Ivory Data Access process terminates with a return code, indicating the success or failure of the process, hence automatic actions can be performed.   Finally, a complete set of configuration parameters can be set to control every aspect of data access.   For example, the user can limit rows returned, stop queries without filters, limit I/Os, etc.

Monitoring

Ivory Data Access provides a facility to monitor all data exchange operations, facilitating administration and making data exchange more transparent.   A new SQL/Analyzer feature allows the administrator to graphically display data usage by user, SQL request, or data table.   Metrics display activity in a dashboard type display that can easily identify problem areas.

Ivory Data Access makes it possible to rapidly implement data integration solutions, with no programming required.

Features:

  • MS Windows application provides complete centralized maintenance functionality
  • Performs data structure analysis
  • Facilitates definition of SQL statements, Joins and Views
  • Cross-platform data transfers
  • Data exchange monitoring
  • User-level security support

Click here to request additional product information