Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2008

    Cool Unanswered: Partition Information

    I am running shell script to prune the old logs.I have t0 pass dbname and partition information

    what is the command to find partition information.

    version : 9.7 fp3

    Plz help me I am new to dpf.

  2. #2
    Join Date
    May 2003
    You can use the DB_PARTITIONS table function, which reads the db2nodes.cfg file and allows you to access it with SQL.
    DB_PARTITIONS - IBM DB2 9.7 for Linux, UNIX, and Windows

    If you want to access the db2nodes.cfg file yourself without SQL, it is located in $HOME/sqllib directory.
    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