Results 1 to 9 of 9
  1. #1
    Join Date
    Apr 2002
    Posts
    188

    Unanswered: AXI and max num of connections

    Hello ,

    How do you about increasing the number of connections to a
    DB2 on AIX (4.0), I have already increase the MAXAPPLS and
    agents values but still I am getting the error in which It tells me
    to increase the memory segments..

    Any ideas,

    thank you

  2. #2
    Join Date
    Apr 2002
    Posts
    188

    AIX and gcc

    Has anybody use the gcc on AIX to help on the SP process ?
    if so , do you have some kind of guidelines on how go about
    succesfully compile SP on DB2/AIX ?

    If you have use javac, if you can tell me also the steps you took
    to include the files I would really appreciate..

    thank you

  3. #3
    Join Date
    Oct 2001
    Posts
    68
    On AIX, you have to catalog the database and "fool" it into thinking it's remote. This is due to a known problem with AIX shared memory segments.

    If the database you want your applications to access is DBDA, then you can create a physical database DBDB as follows:

    CREATE DATABASE DBDB ON <optional args etc.>;

    Now set up a loopback node and catalog the "remote" alias as DBDA

    CATALOG TCPIP NODE NODE00 REMOTE 127.0.0.1 SERVER db2cdb2inst1;

    CATALOG DATABASE DBDB AS DBDA AT NODE NODE00;

    Now your apps can connect to DBDA up to the MAXAPPLS setting.

    WP

  4. #4
    Join Date
    Apr 2002
    Posts
    188
    Thanks

    I will explorer that route, now is this AIX bug documented somewhere ?



    Originally posted by WPSullivan
    On AIX, you have to catalog the database and "fool" it into thinking it's remote. This is due to a known problem with AIX shared memory segments.

    If the database you want your applications to access is DBDA, then you can create a physical database DBDB as follows:

    CREATE DATABASE DBDB ON <optional args etc.>;

    Now set up a loopback node and catalog the "remote" alias as DBDA

    CATALOG TCPIP NODE NODE00 REMOTE 127.0.0.1 SERVER db2cdb2inst1;

    CATALOG DATABASE DBDB AS DBDA AT NODE NODE00;

    Now your apps can connect to DBDA up to the MAXAPPLS setting.

    WP

  5. #5
    Join Date
    Oct 2001
    Posts
    68
    Why yes it is. I'll have to go looking for it. It's been a while since I had to research the problem, now it's second nature.
    William P.O'Sullivan

    IBM Certified Solutions Expert - DB2 UDB V7.1 Database Administration for Unix, Linux, Windows and OS/2
    OS/390, AIX, Linux and Windows2000

  6. #6
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    The following link has some information on what you are looking for :

    http://www-3.ibm.com/cgi-bin/db2www/...d2w&fn=1009742



    Originally posted by Maor71
    Thanks

    I will explorer that route, now is this AIX bug documented somewhere ?




  7. #7
    Join Date
    Apr 2002
    Posts
    188
    thanks sathyaram_s

    but the link goes nowhere, ibm error



    Originally posted by sathyaram_s
    The following link has some information on what you are looking for :

    http://www-3.ibm.com/cgi-bin/db2www/...d2w&fn=1009742




  8. #8
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    works in mine ...

    well in the DB2 UDB Online Support Page at
    http://www-3.ibm.com/cgi-bin/db2www/...dex.d2w/report

    navigate to 'knowledge base',' technotes', '3rd party tools' , 'websphere' .

    You find an article titled 'DB2 issues SQL1224N and WebSphere Application Server (WAS) admin server fails with StaleConnectionException when attempting more than 10 local concurrent DB2 connections from a single process' .

    and this is it ....

    HTH

    Cheers

    Sathyaram



    Originally posted by Maor71
    thanks sathyaram_s

    but the link goes nowhere, ibm error




  9. #9
    Join Date
    Apr 2002
    Posts
    188
    Thanks, I found it, very well documented and very hidden from
    the general searchs ..



    Originally posted by sathyaram_s
    works in mine ...

    well in the DB2 UDB Online Support Page at
    http://www-3.ibm.com/cgi-bin/db2www/...dex.d2w/report

    navigate to 'knowledge base',' technotes', '3rd party tools' , 'websphere' .

    You find an article titled 'DB2 issues SQL1224N and WebSphere Application Server (WAS) admin server fails with StaleConnectionException when attempting more than 10 local concurrent DB2 connections from a single process' .

    and this is it ....

    HTH

    Cheers

    Sathyaram




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •