![]() These utilities enable you to recover your databases after data is lost or becomes corrupted due to hardware or software failure or accident. Backup and Restore Guide These topics describe how to use the HCL® Informix® ON-Bar and ontape utilities to back up and restore database server data.Using SQL Editor to view SQL execution plan.Getting Started This topic provides a brief tutorial to help you get started with InformixHQ.System Compatibility Before you install InformixHQ, make sure that your computer meets the system requirements.Architecture InformixHQ consists of three distinct pieces that come together to give you a comprehensive monitoring and administering experience for Informix.What's new in InformixHQ This topic includes information about new features in InformixHQ.SNMP Subagent Guide These topics describe the Simple Network Management Protocol (SNMP) and the software that you need to use SNMP to monitor and manage HCL Informix® database servers and databases.Performance Guide These topics describe how to configure and operate your HCL Informix® database server to improve overall system throughput and to improve the performance of SQL queries.DB-Access User's Guide This publication describes how to use the DB-Access utility to access, modify, and retrieve information from HCL® Informix® database servers.Administrator's Reference These topics include comprehensive descriptions of HCL Informix® configuration parameters, the system-monitoring interface (SMI) tables in the sysmaster database, the syntax of database server utilities such as onmode and onstat, logical-log records, disk structures, event alarms, and unnumbered error messages.Administrator's Guide These topics provide the information required to administer HCL Informix®.List of utilities HCL Informix® includes utilities and applications that you can use to perform administrative tasks and capture information about configuration and performance.InformixHQ is the centralized hub for graphical monitoring, alerting, and administration of your Informix database servers. Moreover, it's a tool that can be shared by the DBAs, the app developers, the ops engineers, and management and accessed from any desktop, laptop, or mobile device. InformixHQ is designed to be scalable to efficiently manage and monitor as many Informix database server instances as you need. Its monitoring system feeds directly into a customizable alerting system so you can be immediately alerted via email, Twilio, or PagerDuty whenever an issue occurs on one of your Informix database server instances. It provides critical performance management capabilities, monitoring how key performance metrics are changing over time and tracking how efficiently Informix is running your workload even when you’ve stepped away from your screen. It is purpose built for ease-of-use, scaling out, and optimizing DevOps needs. InformixHQ Guide InformixHQ is a modern web console for visualizing, monitoring, and managing your Informix server instances.System administration These topics contain concepts, procedures, and reference information for database and database server administrators to use for managing and tuning HCL Informix® database servers.Administering In addition to administering the database server, you can tune performance, replicate data, and archive data.Although the site works in https, you never know. You are advised not to enter passwords, authentication tokens, etc. Your queries pass through the network, avoid playing with production data. Thus, once your data has been generated using this tool, you can import it into your database.You also have the option of exporting data from your "select" queries in CSV format. Once you have performed your SQL queries, you can export all the data from your database (in SQL format or in sqli format for SQLite). And some features are not available on all databases. As you must know unfortunately each database deviates more or less from the standard. You can also quickly validate if your query is compatible on different databases. Thus the requests can be tested easily by your interlocutors. This is useful when exposing a problem on a request on the forums specialized. So you can easily share one or more SQL queries. This can be really useful and a time saver when you have to validate queries for a multi-database software.Īnother use of this online SQL compiler is to share a snippet. This tool allows you to test SQL queries from different databases without installation.
0 Comments
Leave a Reply. |