Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2003
    Location
    Seattle
    Posts
    8

    Question Unanswered: onstat -d -- how to vary the order?

    onstat -d sorts the chunks by chunk number. Is there a command that would sort this listing by dbs?

    Thanks!

  2. #2
    Join Date
    Aug 2002
    Location
    Bonn/Germany
    Posts
    152
    A quick and dirty approach:

    onstat -d | sort +2n

    However you might also take a look at the appropriate
    sysmaster tables (syschunks, sysdbspaces) to access
    the same information in a more structured way.

    You can also check my website for sysmaster queriers:

    http://www.herber-consulting.de/cgi-...action=IfmxSmi

    Best regards

    Eric
    --
    IT-Consulting Herber
    WWW: http://www.herber-consulting.de
    Email: eric@herber-consulting.de

    ***********************************************
    Download the IFMX Database-Monitor for free at:
    http://www.herber-consulting.de/BusyBee
    ***********************************************

  3. #3
    Join Date
    Jul 2003
    Location
    Seattle
    Posts
    8
    Thank you, this is so very helpful!

    Can you explain to me what exactly the "sort +2n" means?

  4. #4
    Join Date
    Aug 2002
    Location
    Bonn/Germany
    Posts
    152
    numeric sort on the third field (i.e. 0,1,2)

    Just execute: 'man sort'

    Best regards

    Eric
    --
    IT-Consulting Herber
    WWW: http://www.herber-consulting.de
    Email: eric@herber-consulting.de

    ***********************************************
    Download the IFMX Database-Monitor for free at:
    http://www.herber-consulting.de/BusyBee
    ***********************************************

  5. #5
    Join Date
    Jul 2003
    Location
    Seattle
    Posts
    8
    Great, thank you once again, your help is much appreciated.

Posting Permissions

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