DBIQ

0 reviews

DB/IQ is a software solution designed to assess and improve the level of quality and maintainability of Db2 for z/OS applications before they get deployed in your production environment. DB/IQ automates the quality control process according to performance, maintainability, and scalability criteria. DB/IQ analyzes and performs checks on all SQL code; whether in source form, in a DBRM resulting from the Db2 pre-processor, in all Catalog-based SQL (plans, packages, views, MQTs, triggers etc.), or as dynamically executed SQL. • Check the quality of any SQL code according to organization-defined standards • More than 350 quality rules are available “out-of-the-box” and can be customized according to your requirements and SLAs • Provide developers interactive quality control and full EXPLAIN functionality for all SQL statements • Alert and possibly reject programs that violate quality rules Controls can be triggered on demand by developers, directly in their mainframe or Eclipse development environments, and automatically in batch mode during delivery procedures

DBIQ Package Management (PackMan)

0 reviews

DB/IQ Package Management (PackMan) helps manage the DevOps chaos by identifying redundant packages, removing them and reorganizing the Db2 Catalog. The result is a cleaner Db2 Catalog that is streamlined for more reliable application performance. • Clean up the Db2 Catalog by discarding non-required packages. An absolute must, when implementing Change Management Systems within the DevOps method • Prompt DBAs to easily build jobs and keep a clean and efficient Db2 Catalog • Avoid all potential -805/-818 problems by determining inconsistencies between DBRMs, associated packages, and load modules • Make migration to production systems secure by determining any inconsistencies before the BIND process takes place • Maintain EXPLAIN tables down to the required minimum. Improve BIND times • Recreate DBRM members or libraries from Catalog packages • Prevent unnecessary BIND by comparing a new DBRM with its predecessor version

InfoPak

0 reviews

InfoPak offers the best compression rates for your online and backup data. InfoPak reduces the cost of online and offline space, thus considerably reducing the number of accesses to process the same quantity of data. InfoPak is compatible with many hardware technology levels and offers the choice between software and hardware compression. InfoPak applies to DL1, Db2, IDMS and DATACOM data types, as well as to VSAM and sequential files and PDS. A Unique Sofware Compression Technology - From the beginning, it was decided that InfoPak would not use external compression tables. Technologies based on specific tables or dictionaries can expose users to data integrity problems in the event of alteration, loss or confusion of these tables. InfoPak guarantees the highest level of compression with 100% data security. InfoPak guarantees a maximum compression rate over time as data changes. A Simple Operating Mode With InfoPak, simply choose the desired compression module according to the objectives set (compression rate and CPU consumption). A number of “intelligent” algorithms are found in each module that are automatically allocated to data, according to their type. This operation takes place without human intervention and maintains optimum compression during changes in data. Hardware Compression without Constraints With InfoPak, users benefit immediately from hardware compression without superfluous equipment. InfoPak is the only product to provide a hardware solution for IDMS and DATACOM sites. Switch from software compression to “hardware” compression using InfoPak in both directions without conversion and without loading/unloading. InfoPak is a very powerful tool for sites that uses, or will use, a number of machines with different technologies (whether or not they are equipped with a hardware device), which is often the case in a recovery situation following an incident (on the backup site.)

iDBA-Online

0 reviews

Let Machine Learning Automate Your Db2 Maintenance iDBA-Online uses machine learning to provide automatic maintenance capabilities for performing database backups, keeping statistics current and reorganizing tables and indexes as necessary. iDBA-Online sophisticated algorithms combine your SLAs, your business constraints and a cost-benefit analysis to establish in real-time the optimum maintenance schedule. The maintenance utilities are executed automatically to ensure your compliance with SLA and certify that every single operation has a positive ROI for the overall system. Ensure ROI Of Maintenance Operations iDBA-Online determines automatically what maintenance tasks need to be performed on your Db2 environments. The decisions are based on a cost-benefit analysis that takes into account the business constraints (SLAs) defined by users, the use of Db2 data by applications, the current status of the tables and indexes and the cost of the maintenance. By performing only the maintenance tasks that have a positive ROI on your system. iDBA-Online guarantees the Db2 database is constantly optimized for your applications. This cost-driven strategy leads to avoids unnecessary maintenances and minimizes system resources. With iDBA-Online’s machine learning capability you can manage larger workloads with smart and agile automation. Smart and Dynamic Planning iDBA-Online defines the optimum planning for Db2 maintenance operations that will maximize overall system performance while ensuring full data integrity and lower application costs. iDBA-Online collects CPU and workload information to predict when is the best moment to schedule maintenance utilities. The planning and the strategy are dynamically adapted in real-time based on the instant workload. Intelligent Pilot for Db2 Utilities iDBA-Online controls the execution of Db2 utilities and makes live-time decisions on database maintenance without generating any JCL: parallelism management, selection of the execution mode (Online or Offline), recovery… Utilities include online and offline reorganization, synchronous and asynchronous backup, data load and unload, and Db2 catalog statistics update. In the case any problem occurs during a utility cycle, iDBA-Online manages the complete recover to ensure application availability. Enforce your Business SLAs The decisions made by iDBA-Online’s automation take into account the business rules and SLAs defined by your users. A centralized interface allows them to define groups of objects and the rules associated to each group. Those rules includes: data availability, forbidden periods, backup strategies, and more. Business value of application can be set in order to privilege Db2 objects that are important for your business. Benefits • Automate Db2 maintenance tasks with Smart Pilot • Reduce maintenance costs by scheduling necessary tasks only • Reduce application costs by ensuring positive ROI for every single maintenance task • Ensure the maintenance strategy complies with your SLAs • Maintain continuous availability to Db2 data • Control maintenance operation through a centralized interface • Ensure maintenance operations without impacting CPU billing • Collect statistics without affecting applications • Focus DBA’s efforts on innovation rather than basic maintenance management

InfoUnload

0 reviews

High Performance Data Unload Utility for Db2® on IBM® z/OS® Streamline Data Unloading InfoUnload is a high-speed data unload tool that maximizes performance by reducing processor consumption and the amount of I/O. InfoUnload allows unloading from a full image copy or one or more partitions in parallel. It is also possible to perform multiple unloads in parallel or unload a series of VSAM files in bulk. You can unload Db2 data into several files in a single operation and the user has the ability to unload only select rows and columns needed to be unloaded. InfoUnload can also unload into a number of different data formats, including non-Db2 and is compatible with the syntax of all the various tools on the market. InfoUnload Features: • Ultra-fast Db2 table unloading utility, the fastest on the market • Parallel processing of several unloads accessing the same table space • Can unload from a full image copy • Ability to unload selected rows and columns • Ability to unload every “n” rows or unload all rows • Generate load-control statements for subsequent reloads • Create output in multiple formats during a single unload operation

InfoUtil

0 reviews

High Performance Utilities for Db2 for z/OS InfoUtil is a suite of tools for Db2 on z/OS, the fastest on the market. Easy to use, InfoUtil is 100 % compatible with the syntax of standard IBM utilities and thus preserves initial investments. InfoUtil reduces processing times by a factor of up to 10 with respect to standard products, and offers an additional set of functionalities for greater operating flexibility. Your Needs... • Increasing numbers of critical applications require 24/7 availability of company data. • Loading, reloading, transferring and integrating increasing volumes of data is necessary and involves significant cost. • Developing very different applications (ERP, CRM etc.) requires converting data between heterogeneous environments. • Data additions, deletions and upgrades lead to quick disorganisation of tablespaces and Db2 indexspaces. • Significantly reducing processing time is becoming a major challenge.

Arvitam

0 reviews

Protect Your Most Sensitive Archive Data Arvitam is a digital archiving solution for all types of electronically stored information across the enterprise. It preserves your digital assets securely for the long term and is tailored to ensure full compliance with records management policies across a multitude of industries. The safety deposit box for your enterprise Whether it’s invoices, pay stubs, HR records, emails, contracts or images, electronic media of every possible format can reside in Arvitam. Arvitam enables you to define and implement an archiving strategy for each record type, adapted to your business goals or compliance requirements. Classification In Arvitam, you decide how to index and organize records according to your needs. Storage Arvitam supports all media formats – disks, magnetic tape, cloud… You choose where to store which archives, the number of copies you want to keep, the datacenters in which they’ll be stored… Retention Throughout their lifecycle your records must comply with policies and procedures such as retention periods, final disposition, destruction process, workflow… Arvitam orchestrates these phases automatically to ensure that all your records are fully compliant enterprise-wide. Security by Design Authentication, access permissions, integrity checks, traceability, confidentiality policies… Arvitam integrates 15 distinct processes to ensure total security and legal preservation of evidence.

deepeo

0 reviews

Deepeo is a robust data management solution that performs housekeeping tasks across hundreds of databases to manage data deletion according to your company’s data retention policies. It’s an excellent tool to help your company maintain compliance of data within the relevant GDPR laws for your country and any country for which a data subject resides or operates. Compatible with most database technologies, deepeo can be seamlessly integrated with your current software without the need for a costly bespoke system. Deepeo is a user-friendly, configurable system to manage your business data and to help you keep on top of GDPR compliance. Most organisations have huge volumes of data to manage but don’t have a robust system in place to cope with it. This can generate a lot of unnecessary work, or dead time, which means less time is spent focusing on daily business tasks. However, with the right system in place, data management can be simple and undemanding. Why deepeo? Managing your data needn’t be complicated! Here’s how deepeo will work for you: • Data deletion : Create business rules to delete data for subjects who no longer have a relationship with your business. This can either be based on your own records management policies or to comply with GDPR. • Real-time reporting: When developing deepeo, we knew real-time reporting had to be a key feature. With multiple databases to keep track of, companies need to be able to view data and risk exposure in one place and at any time. deepeo’s portal provides you with a consolidated view of your data, enabling you to visualise your usage in real time. • Data anonymisation: deepeo is more than GDPR. It takes your data management one step further by being the only system on the market that can cleanse and anonymise data, allowing you to analyse data while keeping client identities anonymous. • Integration: deepeo is database agnostic, which means it can be seamlessly integrated with your current database management system. We provide integration assistance to ensure deepeo is set up correctly, allowing you to fully utilise everything it has to offer. Our integration team will always be on hand should you need any advice or assistance.