Cli driver sql1224n a

If you are running bit applications running on AIX operating systems, you can set the environment variable EXTSHM to ON to increase the number of shared memory segments to which a single process can be attached.

Most likely your db2 connection had some issues. You can refer to db2diag. No Account? Sign up. By signing in, you agree to our Terms of Use and Privacy Policy.

Already have an account? Sign in. By signing up, you agree to our Terms of Use and Privacy Policy. Enter the email address associated with your account. We'll send a magic link to your inbox. Email Address. All Sign in options. Enter a Email Address. Problem Type Select the Nature of the Issue reported. User Types Select the Type of Users involved.

Project Phases Select the Project Phase. System Information Last Modified Date. To Be Removed Title. URL Name. Article Record Type. There is an architectural limit of 11 shared memory segments in any AIX bit process. In a DB2 client application, one of these is reserved for tracing, even if tracing is not enabled. This leaves 10 shared memory segments, which allows 10 concurrent connections, each communicating with a different db2 agent through a unique shared memory segment.

For example, these segments may be created by the client process itself, but would not be directly related to db2 activity. In this case, the total number of shared memory segments may exceed 11, though the number of non-EXTSHM segments for DB2 connections still cannot exceed If the application process is also EXTSHM-enabled, it would be able to attach to a large number of these segments, and thus achieve a large number of concurrent db2 connections.

DB2 documentation is erroneous in implying that more then 10 concurrent connections from a single process can be achieved by enabling EXTSHM in the application environment.

DB2 supports raw devices for storing data as well as logging. As mentioned before, there is a solution. I'm using DB Looks like a DB2 went down..

Cheers Serge Quote:. Nothing to do with Websphere. How many connections are you trying to do from your application running locally? Since I'm running the same application, remote or local, I think the same. Is there a way for me to count how many transaction an application makes in the database?

I traced the application and placed some printf's so that I would know when it connects and disconnects from the database. When you get the or the , what does the command: list applications show details from the db2 server show? Regarding your questions: Quote:. I have now isolated the exact connection handle that fails to disconnect. I tried creating few sample DB2 files with minimal data and it resulted in successfull creation.

Also i tried retrieving the same amount of data and holding this data in Focus file and i was able do it.

As JG mentioned i guess it could be a shared memory issue. I will check with Admin and i will post back if i get know any solution regarding this. Thanks all for your inputs Francis, Could this be a code issue written to fetch the data? Please Wait.

Your request is being processed Connect to myibi. Personal Zone. Member Directory. Focal Point Forums. Ignore List.