Results 1 to 7 of 7
  1. #1
    Join Date
    Sep 2009
    Posts
    66

    Unanswered: coordinator partition in a DPF environment

    Ho to find which partition in a DPF environment is the coordinator?

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    It's the one the application is connected to.
    Code:
    D:\>db2 values current dbpartitionnum
    
    1
    -----------
              0
    
      1 record(s) selected.

  3. #3
    Join Date
    Sep 2009
    Posts
    66
    I need this for all applications.

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    There is one coordinator node for each physical node. It is usually the first partition (lowest partition number) on each physical node. The application will be connected to one physical server, even if there are more in the DPF system.

    The list of physical nodes and logical nodes is in the db2nodes.cfg file in sqllib subdirectory.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    If I understand the question correctly, you need to know the coordinator partition for currently connected applications? In this case, you can use:

    list applications show detail - Coordinating DB partition number
    application snapshot - Coordinating database partition number


    You could also check the location of db2agent(s) - need to use db2pd with -edu starting with v9.5

  6. #6
    Join Date
    Sep 2009
    Posts
    66
    How to check db2agent(s) and physical server?

  7. #7
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    You'll see the partition number next to "db2agent (db_name)" in the ps output (if using v9.1 or lower) or db2pd -edu (if using v9.5 or higher). db2agent is the coordinator agent.

Posting Permissions

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