Results 1 to 4 of 4

Thread: slow connection

  1. #1
    Join Date
    Apr 2002
    Posts
    84

    Question Unanswered: slow connection

    Dear All,

    I installed DB2 in two servers A and B, and linked a A's database XYZ
    in B. However, it is pretty slow to access XYZ from B. From the command
    window, "connect to XYZ" took quite a while to execute.

    Is there any way to check where the bottleneck is, and how to fine
    tune the performance?

    Thanks.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Make sure that your databases are catalogued with the "authentication server" option (assuming that you are using type 2 connections).

    If you don't have applications always connected, then issue the "activate db" command. Unless a database is activated, the first connection has to allocate a lot of memory each time (including all the buffer pools), and these are de-allocated when the last connnection disconnects. Using activate db eliminates that problem.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Aug 2003
    Posts
    14
    Just a question myself - how come the 'authentication sever' option is quicker?

    I've noticed since going from DB2 8.1 FP7A to FP9A, I've had to recatalog all my databases from 'DBM config' to 'authentication server' to make the connection quicker.

    Also - I've tried 'activate' a database to overcome users' complaints that connections are slow initially. However I find i have to reactivate every other day. Is there a permanent settting somewhere? eg some environment variable etc?

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I don't exactly know why, and I don't particularly care.

    Activate db should be permanent. But if someone issues a force application command, quiesce, db2stop, etc, then it may be need to be issued again.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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