Informix

 View Only

lg_IIUG_url_text_logo.gif

Latest Discussions

  • Profile Picture

    RE: ALTER TABLE Error #106: non-exclusive access

    By: David Grove , 9 hours ago

    Thank you, Art. That is a useful piece of info. I don't think I ever knew that. DG

  • Profile Picture

    RE: ALTER TABLE Error #106: non-exclusive access

    By: Art Kagel , 10 hours ago

    David: Just an FYI: If you include the -e option to dbaccess it will echo the SQL entered to the output along with the error messages. Witness: $ dbaccess -e testdb - Database selected. > select first 2 * from extents; select first 2 * from ...

  • Profile Picture

    RE: ALTER TABLE Error #106: non-exclusive access

    By: David Grove , 10 hours ago

    Thank you, Andreas. I'm not sure how to actually apply your suggestion. I would need to "catch it in the act" so to speak, right? The script has 4,015 ALTER TABLE statements. I can execute it using dbaccess (with stdout and stderr redirected to ...

  • Profile Picture

    RE: Duplicate DBSERVERALIAS

    By: Dennis Melnikov , 12 hours ago

    As we got down to Connection Manager, what is a reasonable value for WORKERS which defaults to 4? How can I decide that 4 is not enough? ------------------------------ Sincerely, Dennis ------------------------------

  • Profile Picture

    RE: Duplicate DBSERVERALIAS

    By: Thomas Beebe , 13 hours ago

    If you are setting up connection manager I would also suggest you set USEALIASES=OFF, that way it won't look at the sqlhosts file for any additional listeners. ------------------------------ Thomas Beebe Vice President xDB Systems, Inc Woodbridge 5713399029 ...

    1 person likes this.

Latest Blogs

  • Profile Picture

    IBM Champion Spotlight: Art S. Kagel

    By: Namitha K 5 months ago

    Meet Art S. Kagel, President & Principal Consultant at ASK Database Management Corp., and has been an IBM Champion since the inception of the program! With a passion for technology and a deep love for IBM Informix, Art shares his insights, experiences, ...

    3 people like this.
  • Profile Picture

    The Evolution of Informix: Is It Obsolete?

    By: Youssef Sbai Idrissi 11 months ago

    nformix, a relational database management system (RDBMS), has been a significant player in the database landscape for several decades. However, in the face of rapidly advancing technologies and emerging trends, it is worth exploring whether Informix is ...

  • Profile Picture

    Uncovering Weaknesses in Informix: Strategies for Improvement and Optimization

    By: Youssef Sbai Idrissi 11 months ago

    nformix, a popular relational database management system (RDBMS) developed by IBM, offers robust features for data storage and retrieval. However, like any software system, Informix has its own set of weaknesses that can impact performance, scalability, ...

    1 person likes this.
  • Profile Picture

    Smooth Transition: Migrating from IBM DB2 to Informix Database

    By: Youssef Sbai Idrissi 11 months ago

    As technology landscapes evolve, organizations often find the need to migrate their databases to align with changing requirements. If you're currently utilizing IBM DB2 and considering a migration to Informix Database, this article will guide you through ...

  • Profile Picture

    Demystifying Famous Errors in Informix and Their Resolutions: A Technical Guide

    By: Youssef Sbai Idrissi 11 months ago

    Informix, a powerful database management system, is widely used in various industries for its performance and reliability. However, like any complex software, it is not immune to errors. In this technical blog, we will explore some famous errors encountered ...

Community Members
738 Members
Ashley Bassman
group Admin
group Moderator
group Leadership
Kevin Black
group Admin
group Moderator
Carlton Doe
group Admin
Hidden Member
group Admin
Scott Pickett
group Admin
Nishant Kumar Sinha
group Admin
Kip Yego
group Admin
group Moderator
Mohammad AboSoud
John David Adamski
Rajat Agrawal
Sheshnarayan Agrawal
Marcelo Aguirre
S Akshatha
Josef Albert
Muhammad Ale
Hasnat Ali
Mohammed Ali
Noreddine Allay
Paul Anderson
Camilo Andrade Perez
Doutor Andre
Gary Andrus
Florian Apolloner
RACHID ARIZKI