FW: onstat -g xqs ouput [62]

-----Original Message----- From: xps-bounces@iiug.org [mailto:xps-bounces@iiug.org] On Behalf Of Bob Kruse Sent: Monday, January 09, 2006 3:23 PM To: xps@iiug.org Subject: onstat -g xqs ouput [62] Greetings All, Does anyone have any idea how to relate the output from the "onstat -g xqs <plan id>" command to actual dbspaces or chunks? We are trying to optimize performance on an XPS 8.50 server we've built and we have noticed the time for some of the scan threads to be significantly higher for some devices than others from the output in the sqexplain.out file. In the "onstat -g xqs" output, the instance iterator (labeled inst) corresponds to each dbspace in the dbslice where the scanned table is fragmented. I'd like to be able to correlate the inst number to a specific dbspace (or chunk) so I can identify the devices that it is taking longer to scan. Thanks for the input. Cheers, Bob Kruse Cosvr_ID: 1 Plan_ID: 1657 type segid brid information ---- ----- ---- ----------- scan 4 0 inst cosvr time rows_prod rows_scan ---- ----- ---- --------- --------- 0 1 71 247678 1539536 1 1 71 247988 1539088 2 1 70 245837 1528111 3 1 74 245466 1526252 4 1 73 246357 1529553 5 1 72 245947 1531720 6 1 71 246306 1529163 7 1 71 246976 1531645 8 1 96 246369 1529312 9 1 96 246530 1527000 10 1 96 246349 1528117 11 1 96 246148 1529607 12 1 96 246122 1527002 13 1 97 246670 1530640 14 1 96 246073 1528552 15 1 96 246987 1527004 16 1 95 245755 1524992 17 1 96 246943 1527924 18 2 71 248933 1539981 19 2 71 246857 1528630 20 2 71 246677 1529835 21 2 71 247461 1530049 22 2 73 246577 1530402 23 2 69 246753 1526448 24 2 70 247284 1528355 25 2 71 246326 1524950 26 2 96 245975 1528878 27 2 97 245522 1527530 28 2 96 246947 1529729 29 2 96 246566 1530013 30 2 96 246495 1531139 31 2 96 246892 1531234 32 2 96 245922 1527649 33 2 97 245806 1529288 34 2 96 247103 1528058 35 2 96 246628 1528542 36 3 72 247752 1537901 37 3 71 246411 1530586 38 3 71 246956 1527607 39 3 72 246576 1530926 40 3 73 247211 1530410 41 3 71 245744 1527765 42 3 71 246466 1527115 43 3 96 246992 1529368 44 3 96 246391 1530099 45 3 95 246635 1528462 46 3 96 246743 1529960 47 3 97 246101 1528623 48 3 96 246451 1528241 49 3 97 246251 1526132 50 3 96 247102 1529394 51 3 96 246688 1528217 52 3 96 246730 1527898 53 3 94 246266 1530115 54 4 73 248608 1539221 55 4 71 246579 1528584 56 4 81 246571 1528757 57 4 73 246806 1530631 58 4 73 246658 1528397 59 4 71 246954 1529337 60 4 76 247702 1529650 61 4 97 245635 1528278 62 4 96 246638 1528759 63 4 96 245923 1528653 64 4 96 246751 1527280 65 4 96 246802 1528664 66 4 95 245569 1527903 67 4 96 246360 1531233 68 4 96 246656 1529332 69 4 96 246125 1525287 70 4 96 246625 1529188 71 4 95 245902 1529491 -------------------------------------- 72 17755555 110123392 --Boundary_(ID_J+JDjsdB+qvO9yU2GZfOsg) **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.