home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36

Admin-Scout News & Developers Blog

  • Admin-Scout 4.0 - Development and Release Steps

    Admin-Scout 4.0
    Development and Release Steps

    All changes up to Release 4.0
    of August 2024

    Read more

  • Admin-Scout 3.3 - Informix Enterprise Replication

    Admin-Scout 3.3
    Informix Enterprise Replication Module

    Informix ERInformix Enterprise Replication is a powerful way to replicate data assets across distributed installations and keep them consistent.

    With version 3.3, Admin-Scout helps Informix administrators to set up, configure and monitor Informix Enterprise Replications.

    This article provides an overview of Informix Enterprise Replication with our Admin-Scout for Informix.

    Read more

  • Admin-Scout 3.2 - Create individual users / test roles with the SQL Editor

    Admin-Scout 3.2
    Create individual users / Test roles with the SQL-Editor

    Informix compareCustomized use of the Admin-Scout thanks to the new role concept

    Whereas Admin-Scout previously only knew the default users "cursoradmin" and "openadmin", the new version 3.2 allows the creation of individual users. In combination with a dedicated assignment of rights on menu level, different roles can now be built up specifically.

    Checking role and rights concepts with the SQL-Editor

    Administrators have to deal with roles and access rights of database users. To make it possible to check the rights of a user, the new version allows to test accesses of the SQL-Editor under a different user name

    Read more

  • Admin-Scout 3.2 - New ONCONFIG Module

    Admin-Scout 3.2
    ONCONFIG Explorer

    Informix compareWith the ONCONFIG Explorer, Admin-Scout 3.2 offers a completely new module for managing ONCONFIG variables.

    The goal of our development was to clearly summarize the ONCONFIG variables in one place and to present all information related to selected variables.

    The ONCONFIG Explorer displays all ONCONFIG variables alphabetically sorted in a tree structure. A search field can be used to narrow down the number of hits.

    For all documented variables a help button supports the quick display of the reference entry from the manual.

    Read more

  • Admin-Scout 3.2 - New Storage Module

    Admin-Scout 3.2
    New Storage Module

    Informix compareThe entire storage administration clearly arranged in one module!

    Admin-Scout 3.2 offers a complete overhaul and restructuring of storage management. The new module combines storage administration and reporting in one menu item. Administrators are now able to see all storage objects immediately through a hierarchically sorted object tree. A simple click provides all relevant details, sensibly organized via individual tabs.

    Read more

  • Admin-Scout 3.2 - New module to compare DB objects

    Admin-Scout 3.2
    compare DB-objects

    Informix compareAdmin Scout 3.2 offers a long-awaited feature: easy comparison of the databases' structures in different instances.

    The new module compares the typical database objects such as tables, views, external tables, sequences functions and access rights, including the respective associated indexes, constraints and triggers.

    This premium feature increases productivity while matching and adapting database structures and objects.

    Read more

  • Admin-Scout 3.1 - Highlights for developers and administrators

    Admin-Scout 3.1 - Highlights for Developers and Admins

    Version 3.1 continues the journey to new functions for developers and administrators.
    Security UpdateDevelopment
    • Editing in multiple windows, parallel working with multi-tabs in the SQL-Editor.
    • SQL history accessible at any time.
    • Evaluation of dependencies and constraints for table objects.
    • Informix error numbers, direct access to IDs and descriptions.
    Administration
    • Database Explorer, auto generation of archecker scripts for table restore.
    • Locked tables, which sessions keep locks and which are waiting.
    • SSH shell to the server, now simply open via "shell in a box".
    Monitoring
    • Day- and Month-Reports, individual customization according to your personal requirements.
    • Performance checks, extended output with disk I/O per chunk.
    • Schema changes, logging with the new DDL-History2 Report.

    Read more

  • Admin-Scout 3.0 - Functional right from the start!

    Admin-Scout 3.0 - Functional right from the start!

    Admin-Scout 3.0 offers a completely revised design and up to 60% faster evaluations.
    Security UpdateRevised user interface

    The entire user interface of the Admin-Scout is designed more uniformly and with better performance. The access to configuration and server administration is clearly structured. Optimized table structures and scaling of the display, lead to a considerably faster page layout.

    New SQL Toolbox

    The version 3.0 impresses above all with the new SQL Toolbox with many powerful functions in the Database Explorer and SQL Editor. As a result the Admin-Scout offers more interesting functionalities for development and tuning of Informix databases.

    Read more

  • Admin-Scout 2.3 - New Scheduler Module

    Admin-Scout 2.3 - New Scheduler Module

    schweissen 600x400cWe asked the question, which areas of an Informix database system have to be administered manually and where is it possible to set up an automated administration? The goal is to achieve increasing automation and independent optimization of the system through an interaction of sensors and tasks.

    Informix provides an SQL API and corresponding commands as a basis for setting up tasks. If you are an Informix administrator and are rarely concerned with setting up and managing tasks and sensors, you will find that this can quickly become a complex challenge. Therefore, in the new version of our Admin-Scout, we have intensively addressed the topic of a task scheduler and developed a new Admin-Scout module for the administration of tasks and sensors.

    The new Admin-Scout 2.3 Scheduler module offers a centralized administration of all tasks and sensors

    Read more

  • Admin-Scout 2.3 - Overview new features in version 2.3

    Admin-Scout 2.3 - Overview new features in version 2.3

    Informix secure SSL connectionAlready in the last versions many improvements were introduced for the security of the Admin Scout. It was very important for us that during a login no more passwords are transferred between Admin-Scout and the browser.

    Version 2.3 continues our efforts to provide increased security against data spying between Informix Server and client or our Admin-Scout.

    Overview of the new features:
    • https port is now active - generating of a self-signed certificate.
    • Setting up an encrypted SSL connection on the database port.
    • Easier selection of instances - access to instances of different groups.
    • Autologon-Feature – automatic connection to a standard instance.
    • New Scheduler module - all Scheduler modules are now available in one place.
    • New module Cluster Configuration.
    • New module DBSpace Layout History.
    • Backup/Restore now with SQL Editor Files.
    • Additional reporting on the InformixHQ Monitoring Database.

    Read more

  • Admin-Scout 2.2 - Ready for Informix 14.10

    Admin-Scout 2.2 - Ready for Informix 14.10

    release 22 00 1080x360Important features for cluster configuration and better analysis of instances in a group
    Overview:
    • Informix Control Center (ICC) - Dashboard, new tabs and additional tooltips.
    • Better overview of Informix instances of a group.
    • Detailed overview of Informix cluster configurations.
    • Visualization without Adobe Flash (separate article).
    • New SQL editor with syntax highlight (separate article).
    • InformixHQ - Memory Requirements.

    Read more

  • Admin-Scout 2.2 - Now 100% Adobe Flash free!

    Admin-Scout 2.2 - Now 100% Adobe Flash free!

    • The CURSOR Service Distribution will release the new Admin-Scout Version 2.2 in March 2019.
    • The Admin-Scout 2.2 is the first release that is delivered without any Adobe Flash modules.
    Gießen, 22 February 2019

    For years, Adobe Flash was the first choice to visualize animations and sophisticated graphics in a browser. Due to recurring security issues, the use of Adobe Flash Player has long been discouraged. The IBM Informix OpenAdmin Tool also uses the Adobe Flash Player in some areas for the graphical representation of complex contexts.

    Security warnings and the end of support for the Adobe Flash Player, already announced for 2020, prompted us early on to switch the graphical interface of the Admin-Scouts to the Dojo Toolkit and HTML5. We have step by step converted all relevant modules. This involved the redesign of all charts and the elaborate redesign of important modules such as the SQL-Trace or the Storage-Module.

    Read more

  • Admin-Scout 1.4.4 - Dashboard Overview

    Admin-Scout 1.4.4 - the new dashboard, an overview

    Admin-Scout / the Dashboard OverviewThe Admins-Scout Dashboard is an extremely powerful and informative tool that gives you an overview of the state of your Informix servers
    • The Admin-Scout Dashboard is the central overview for important parameters and states.
      All Informix servers in a group are listed and the status of a server is displayed with icons.
    • The details of an instance are very useful for troubleshooting or for identifying optimization potentials. For example, it is very easy to find tables where indexes are missing or the index structure is not ideal.
    • In contrast to the OAT, the Admin-Scout offers the possibility to switch between the tabs - without waiting times and without having to start the reporting from the beginning.
    This article describes the Admin-Scout Dashboard and its individual sections.

    Read more

  • Admin-Scout 1.4.4 - DBSpaces and Storage Report

    Admin-Scout 1.4.4 - DBSpaces and Storage Report

    Admin-Scout DBSpaces and Storage ReportAn Admin-Scout feature for fast analysis of DBSpaces
    • DBSpaces - key data and workload at a glance
    • shows access, page I/O, read and write times
    • view details down to single a database
    • drill-down information down to chunk level
    • DBSpace history data for storage planning
    • The Admin-Scout Storage Report provides a basic overview of all DBSpaces.

    Read more

infomix-nosql-techpaper-470x50informix-nosql-150x100s

 

 

 

With the introduction of support for JSON as a native type and the ability to shard collections of documents, Informix has entered into the fast-paced, dynamic domain of NoSQL web and mobile application development, where engaging with customers has moved beyond merely recording transactions.

IBM has introduced the ability to use the Informix and DB2 relational database management system (DBMS) to store NoSQL Javascript Object Notation (JSON) documents through the MongoDB clients. JSON has become the dominant format for information exchange in web and mobile applications, and MongoDB, which only exchanges information as JSON documents, has the largest market share of NoSQL document storage systems. Informix is more specifically an object-relational DBMS. The existing ability to create new types and functions to work with them has made it possible to implement JSON and binary-JSON (BSON) types as first class citizens.

The domain of NoSQL database management systems is very broad. It encompasses NoSQL systems which do not manage relationships between sets of information at all and those not using the SQL language for such relationships (“no SQL” systems), and those with the capability to use both SQL and relational data, and non-relational functions for accessing structured information (“not-only SQL” systems).

Informix is now one of the “not-only SQL” DBMS.

icon IBM-Informix-12.10.xC2-Enhancements-Introducing-NoSQL-Capabilities-(2013-10)

share document

Setting up the NoSQL functionality on an existing instance


nosql-leafs-200x133sWith the Version 12.10.xC2 IBM created the opportunity to access the Informix database with MongoDB-clients and to use the Informix NoSQL functionality.

Unfortunately getting this fantastic feature requires to build up a new instance. All descritptions of the IBM proclaim, that the installer of the xC2 version has to create a new instance. Then the functionality, based on the copiyng and adjusting of 2 files, can be transferred to further new instances which are created manually.

48673

Read more …

Upgrading to Informix 12.10

Understanding the new, enhanced, and discontinued features in Informix 12.10 to better plan the upgrade
Sergio Dias, Software Engineer, IBM

Summary:  IBM® Informix® version 12.10.xC1 comes with striking new features and enhancements in existing features—as well as a few features or products that were removed. Understanding the new, enhanced, and discontinued features is crucial for better planning and determining which functions should be disabled or enabled during the upgrade process. This minimizes the impact of conversion/reversion and results in a smooth upgrade to Informix 12.10. This article provides all the necessary information to help database administrators make an informed decision on setting the 12.10 features during conversion and then changing the settings, if needed, after the upgrade. The article also covers the required steps in case a reversion is needed.

The scope of this article is to cover the upgrade impact that is related to the IBM Informix Database Server 12.10.xC1 and the IBM Informix Client SDK 4.10.xC1 in comparison to Informix Database Server 11.70.xC7 and Informix Client SDK 3.70.xC7.

This article provide all the necessary information about the migration paths to Informix 12.10, the Conversion Guard, the new SQL keywords, the removed features or products, and an overview of new and enhanced features, so you should be able to plan a successful and smooth upgrade to Informix 12.10.

View Article ...
11110

IBM's New Move in Big Data:

Accelaration, Optimization, and an Open Source Alternative

IBM Almaden Labs, San Jose, CA, April 2, 2013 - Announcements Review

In a major, multi-faceted announcement, IBM announced yesterday that it will soon deliver “speed-of-thought” analytics using DB2 “BLU” acceleration, improvements in its Big Insights and Stream products, and a tuned-for-Hadoop PureData System. IBM also announced time series improvements in Informix database line.

What do all of these announcements mean?

Probably the biggest news in IBM’s extensive announcement is the announcement of an analytics accelerator known as “BLU” acceleration. Although classified as an accelerator, to us, BLU acceleration is more like a process that uses a series of steps to analyze a very large database ? delivering results in seconds or less as opposed to hours or days.

The remainder of this report looks at IBM’s announcements more closely.

Clabby Analytics -  April, 2013
http://www.clabbyanalytics.com

 

icon IBMs New Moves in BigData

share document

IBM Informix Dynamic Server Storage Optimization

IBM® Informix® Dynamic Server (IDS) now offers data compression technology in the Storage Optimization Feature, available in April 2009 with the 11.50.xc4 release. IDS is sharing the same great technology first introduced in DB2® LUW which has been a huge success for DB2 customers.

IDS provides full online support for turning on storage optimization and compressing existing table data while applications continue to use the table. This means that no system downtime is required to utilize the IDS storage optimization technology.

Customers have been able to achieve up to 80 percent savings in storage, depending on their data characteristics. A reduction in data volumes also means less time to complete backup and restore operations. Many customers have experienced up to a 20 percent performance improvement in their applications due to less I/O and improved bufferpool utilization. 

icon IBM Informix Dynamic Server Storage Optimization

share document

  1. IBM Informix Warehouse Accelerator - Performance is everything
  2. Build smart metering solutions with IBM Informix TimeSeries (2011-06)
  3. Administering Informix Dynamic Server on Microsoft Windows
  4. About Admin-Scout development

ADMIN-SCOUT -

AKTUELLES -

DISTRIBUTION -

VERTRIEB -

SERVICE -

ADMIN-SCOUT-LANDING-PAGE -

WEBSHOP -

FORMULARE -

Page 11 of 28