Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2011
    Posts
    7

    Unanswered: SQL query to get db2nodes.cfg info

    Hi,

    I would like to know is there any SQL query to any table in SYSCATSPACE or any other tables to get hostname and logical port information in db2nodes.cfg

    Thanks,
    Gautham.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Code:
    select * from table(sysproc.db_partitions()) as x
    Works on DB2 V9.5 for LUW.

    Andy

Posting Permissions

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