Administering Informix Dynamic Server on Windows NT

Administering Informix Dynamic Server on Windows NT PDF

Author: Carlton Doe

Publisher: Prentice Hall

Published: 1999

Total Pages: 0

ISBN-13: 9780130805331

DOWNLOAD EBOOK →

Hands-on Informix DBA techniques that maximize performance and efficiency! This is the first systematic, hands-on guide to installing, configuring, tuning, and administering Informix-Dynamic Server on Windows NT. Written by the former President of the International Informix Users Group, it delivers exactly what working DBAs need to simplify day-to-day administration and optimization. Coverage reflects the entire lifecycle of an Informix database, including up-front design, installation, and initialization; building a database environment; administering databases, tables, instances and threads; backups and restores; and much more. For new and experienced Informix DBAs-especially those migrating from other platforms or versions Covers Informix Dynamic Server version 7.3-the newest, most full-featured Informix NT release Using the Windows High-Performance Loader in data warehouse, data mart and focused backup operations Using the ON-Bar backup interface with the Informix Storage Manager to backup and restore tables, dbspaces, or instances Comprehensive coverage of the Informix Enterprise Command Center and new SQL commands You'll find detailed, practical coverage of both graphical and command-line tools, High Availability Data Replication (HADR), and every key factor in database performance, including query optimization, virtual processors, and Parallel Data Query (PDQ). CD-ROM INCLUDED On the CD-ROM is a fully functional licensed copy of the Informix NT Engine covered in this book. You also get the Informix "Monitoring and Auditing" training course from CBT systems, worth $225! In addition, there is an extensive library of scripts--all fully documented--designed tostreamline the administration of Informix instances and databases.

IBM Informix Dynamic Server 11

IBM Informix Dynamic Server 11 PDF

Author: Carlton Doe

Publisher: MC Press

Published: 2007

Total Pages: 0

ISBN-13: 9781583470756

DOWNLOAD EBOOK →

The major features and functions of the 11th version of Informix Dynamic Server (IDS 11), IBM’s lead data server for high-volume database applications in nonmainframe environments, are explored and explained in this handy guidebook. Security technologies offered by IDS 11--such as Label-Based Access Control and nonpreemptable connect and disconnect routines--are addressed, as are its newly enhanced Enterprise Replication and High Availability Data Replication capabilities. Oriented for both small business users and large corporate IT departments alike, this is the ultimate reference to one of the most stable, speedy, and adaptable data servers available.

Informix-OnLine Dynamic Server Handbook

Informix-OnLine Dynamic Server Handbook PDF

Author: Carlton Doe

Publisher: Prentice Hall

Published: 1997

Total Pages: 500

ISBN-13:

DOWNLOAD EBOOK →

In this book, the president of the International Informix Users Group shares practical techniques, scripts and expertise that can make any INFORMIX-OnLine administrator dramatically more effective. This book also provides cogent, thorough coverage of high availability and distributed transaction processing environments. On the accompanying CD-ROM, you'll find an extensive library of technical articles, scripts and worksheets - many published here for the first time. All scripts and worksheets are carefully documented. Whether you're administering a database or an INFORMIX-OnLine Dynamic Server instance, these resources could save you hundreds of hours.

Data Warehousing with the Informix Dynamic Server

Data Warehousing with the Informix Dynamic Server PDF

Author: Chuck Ballard

Publisher: IBM Redbooks

Published: 2009-12-10

Total Pages: 478

ISBN-13: 0738433845

DOWNLOAD EBOOK →

The IBM Informix® Dynamic Server (IDS) has the tools to build a powerful data warehouse infrastructure platform to lower costs and increase profits by doing more with your existing operational data and infrastructure. The Informix Warehouse Feature simplifies the process for design and deployment of a high performance data warehouse. With a state-of-the-art extract, load, and transform (ELT) tool and an Eclipse-based GUI environment that is easy to use, this comprehensive platform provides the foundation you need to cost effectively build and deploy the data warehousing infrastructure, using the IBM Informix Dynamic Server, and needed to enable the development and use of next-generation analytic solutions . This IBM® Redbooks® publication describes the technical information and demonstrates the functions and capabilities of the Informix Dynamic Server Warehouse Feature. It can help you understand how to develop a data warehousing architecture and infrastructure to meet your particular requirements, with the Informix Dynamic Server. It can also enable you to transform and manage your operational data, and use it to populate your data warehouse. With that new data warehousing environment, you can support the data analysis and decision-making that are required as you monitor and manage your business processes, and help you meet your business performance management goals, objectives, and measurements.

Migrating from Microsoft SQL Server to IBM Informix

Migrating from Microsoft SQL Server to IBM Informix PDF

Author: Whei-Jen Chen

Publisher: IBM Redbooks

Published: 2010-07-22

Total Pages: 496

ISBN-13: 0738434442

DOWNLOAD EBOOK →

In this IBM® Redbooks® publication, we discuss considerations, and describe a methodology, for transitioning from Microsoft® SQL Server 2008 to the Informix® Dynamic Server. We focus on the topic areas of data, applications, and administration, providing information about the differences in features and functionality, including the data types, data manipulation language, data definition language, and stored procedures. Understanding the features and functionality of the two products assists you in developing a migration plan. We provide a conversion methodology and discuss the processes for migrating the database objects and data from SQL Server to Informix using various methods. We show the SQL differences between SQL Server and Informix and illustrate, with examples, how to convert tables, views, stored procedures, functions, and triggers. We provide script conversion samples for data loading. We describe application programming and conversion considerations. In addition, we discuss the Informix configuration, as well as the administration features and functions Informix provides to help DBAs manage the Informix database server after it is migrated. With this information, you can develop your required transition methodology, and you can plan and execute the conversion activities in an orderly and cost-effective manner.

Solving Business Problems with Informix TimeSeries

Solving Business Problems with Informix TimeSeries PDF

Author: Vaibhav S Dantale

Publisher: IBM Redbooks

Published: 2012-09-21

Total Pages: 148

ISBN-13: 0738437239

DOWNLOAD EBOOK →

The world is becoming more and more instrumented, interconnected, and intelligent in what IBM® terms a smarter planet, with more and more data being collected for analysis. In trade magazines, this trend is called big data. As part of this trend, the following types of time-based information are collected: Large data centers support a corporation or provide cloud services. These data centers need to collect temperature, humidity, and other types of information over time to optimize energy usage. Utility meters (referred to as smart meters) allow utility companies to collect information over a wireless network and to collect more data than ever before. IBM Informix® TimeSeries is optimized for the processing of time-based data and can provide the following benefits: Storage savings: Storage can be optimized when you know the characteristics of your time-based data. Informix TimeSeries often uses one third of the storage space that is required by a standard relational database. Query performance: Informix TimeSeries takes into consideration the type of data to optimize its organization on disk and eliminates the need for some large indexes and additional sorting. For these reasons and more, some queries can easily have an order of magnitude performance improvement compared to standard relational. Simpler queries: Informix TimeSeries includes a large set of specialized functions that allow you to better express the processing that you want to execute. It even provides a toolkit so that you can add proprietary algoritms to the library. This IBM Redbooks® publication is for people who want to implement a solution that revolves around time-based data. It gives you the information that you need to get started and be productive with Informix TimeSeries.

Informix Dynamic Server with Universal Data Option

Informix Dynamic Server with Universal Data Option PDF

Author: Angela Sanchez

Publisher:

Published: 1998-09

Total Pages: 0

ISBN-13: 9780139110740

DOWNLOAD EBOOK →

In this book, object-relational DBMS pioneer Michael Stonebraker evaluates your current architectural options for evolving to ORDBMS and demonstrates why so many leading edge organizations are doing so. Database authority Jim Panttaja shows how Informix DataBlades can revolutionize the way you manage diverse, complex datatypes. Next, a team of database experts demonstrate DataBlades at work in name recognition, optical storage, data mining and other applications. Data warehousing guru Bill Inmon demonstrates in detail how data warehousing can benefit from ORDBMS solutions. Finally, the book includes a step-by-step guide for migrating from yesterday's DBMS technologies to tomorrow's.