IBM Support

Error "ISAM error: too many users" is returned

Troubleshooting


Problem

This document describes the error the error "ISAM error: too many users" when you are trying to connect to a database

Symptom


You are trying to connect to a database using IBM® Informix® OnLine and you receive the following message:


529: Cannot attach to shared memory.
129: ISAM error: too many users


In the message log this message is returned:


11:31:56  User table overflow - user id 200, process id 17075

Cause


The current maximum number of users has been exceeded.

Important: This is only one possible cause of the problem. If this document does not give you what you need then search for other documents with the same problem.

Resolving The Problem


Increase the USERS parameter in the TBCONFIG configuration file.
Also increase the TRANSACTIONS parameter in the TBCONFIG configuration file to be at equal or higher than USERS. See linked documents.

[{"Product":{"code":"SSGHZP","label":"Informix OnLine"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Not Applicable","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF025","label":"Platform Independent"},{"code":"PF008","label":"DYNIX\/ptx"},{"code":"PF010","label":"HP-UX"},{"code":"PF015","label":"IRIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"5.0;5.1;5.2","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21174063

Page Feedback