Chinaunix

标题: AS400 查看Job（特别是ODBC) Performance 两种方法对比 [打印本页]

作者: tomroom 时间: 2009-11-07 18:43
标题: AS400 查看Job（特别是ODBC) Performance 两种方法对比
AS400 查看Job（特别是ODBC) Performance 两种方法对比 ,抛砖引玉下不知道大虾们还有其他更好的方法，供应商推荐要付钱的iDoctor 这个东东还没有机会接触

小结：对指定job 的性能监控Performance菜单中工具比较好，DB Monitor对ODBC ，SQL的作业查看具体运行细节比较好。

方法一利用 Performance菜单中 Performance Report
进入菜单Performance Tools for iSeries
PERFORM             IBM Performance Tools for iSeries
                                                         System:
Select one of the following:

   1. Select type of status
   2. Collect performance data
   3. Print performance report

   5. Performance utilities
   6. Configure and manage tools
   7. Display performance data
   8. System activity
   9. Performance graphics
   10. Advisor

   70. Related commands


Selection or command
===>

F3=Exit F4=Prompt F9=Retrieve F12=Cancel F13=Information Assistant
F16=System main menu
先在上图2. Collect performance data确认性能收集已经启动，且记下收集的文件和LIB
                        Collect Performance Data
                                                         11/07/09  13:57:20
Collection Services status:
Status  . . . . . . . . . . . . : Started
Collection object . . . . . . . : Q311000007
   Library . . . . . . . . . . . : QMPGDATA
Started . . . . . . . . . . . . : 11/07/09  00:00:07
Default collection interval . . : 00:05:00
Retention period  . . . . . . . : 14 days 00 hours
Cycle time  . . . . . . . . . . : 00:00:00
Cycle interval  . . . . . . . . : 24
Collection profile  . . . . . . : *STANDARDP
然后F3 退出选择 3. Print performance report  在选择上面收集性能的LIB,如这台机器QMPGDATA 然后选择对应日期的member（若设置性能数据收集一天归档一个压缩包文件查看其它日期需要CRTPFRDTA去生成后面会单独讲到）

                  Print Performance Report - Sample data

Library . . . . . . QMPGDATA

Type option, press Enter.
  1=System report 2=Component report 3=Job report 4=Pool report
  5=Resource report

Option Member    Text                               Date    Time
  3    Q311000007 IN USE                            11/07/09 00:00:07
选择按JOB 生成性能报表

                        Select Categories for Report

Member . . . . . . . . . . . : Q311000007

Type options, press Enter.  Press F6 to print entire rep
1=Select

Option    Category
         Time interval
1       Job
         User ID
         Subsystem
         Pool
         Communications line
         Control unit
      Functional area
可以按JOB name等参数来筛选，如下 ODBC JDBC 作业 job name：QZDASOINIT
                           Select or Omit Jobs

Member . . . . . . . . . . . : Q311000007

Type options, press Enter.
  1=Select 2=Omit

Option    Job          User          Number    Thread
  1       QZDASOINIT
递交出报表会最下面有类似Job 116037/ZHANGLI/PRTJOBRPT submitted to job queue QBATCH in library QGPL 提示报表默认将在QBATCH中运行，运行结果会有SUMMARY和DETAIL

                                                      Job Interval Report
                                                Non-Interactive Job Summary
                                                            ODBC
Member  . . . : Q311000007 Model/Serial  .       Main storage  . .
  Library . . : QMPGDATA System name . . :             Version/Release .
Partition ID  : 001       Feature Code  . : 7495-8971
Itv Act CPU  ----- Number of I/O Per Second ----- -- CPU/ I/O --- Line
End Jobs Util Sync    Async Logical Cmn Sync Async Count
----- ------- ----- --------- --------- --------- ------ ------- ------- --------- -
00:05    35 9.1    217.6    46.8    24.8    .0    1    7       0
00:10    5  11.6    4.3    3.9    8.3    .0    106    119       0
00:15    6 .6    32.3    7.9    21.1    .0    0    3       0
00:20    13 1.0    53.3    2.9       .7    .0    0    14       0
00:25    5 .2    5.2       .3    1.1    .0    1    25       0
00:30    7 .1    3.7    2.3       .5    .0    1    3       0

                                                      Job Interval Report
                                                   Non-Interactive Job Detail
                                                            ODBC
Member  . . . : Q311000007 Model/Serial  . : 570       Main storage  . .
  Library . . : QMPGDATA System name . . :             Version/Release .
Partition ID  : 001       Feature Code  . : 7495-8971
Itv    Job    User Name/ Job Current                   Elapsed  CPU --- Nbr
End    Name Thread    Number User       Pool Type Pty Time Util Sync
----- ---------- ---------- ------ ----------  ---- ---- ---  ------- ------ ------
14:35 QZDASOINIT QUSER    002319 HHTSYS       6 BJ 25    5:00 .00    0
14:35 QZDASOINIT QUSER    044019 HHTSYS       6 BJ 25    5:00 .07    9
14:35 QZDASOINIT QUSER    051014 QUSER       6 BJ 25    5:00 .01    1
14:35 QZDASOINIT QUSER    059218 QUSER       6 BJ 25    5:00 .01    1
14:35 QZDASOINIT QUSER    061483 HHTSYS       6 BJ 25    5:00 .30    5
14:35 QZDASOINIT QUSER    062373 HHTSYS       6 BJ 25    5:00 .08    15
14:35 QZDASOINIT QUSER    062374 HHTSYS       6 BJ 25    5:00 .31    18

若设置性能数据收集一天归档一个压缩包文件查看其它日期需要先Navigator 查压缩包名字和再CRTPFRDTA去生成.，之后再用上面方法去生成报表
先打开Navigator 在My connection->Configuration and Service -> Collection Services 中列出所有性能收集压缩包，获得文件名例如Q297000004

                     Create Performance Data (CRTPFRDTA)

Type choices, press Enter.

From collection  . . . . . . . . Q297000004 Name,
Library  . . . . . . . . . . .    QMPGDATA Name
To member  . . . . . . . . . . . P20091025    Name,
To library . . . . . . . . . . . BOT          Name,

方法二是使用STRDBMON
http://publib.boulder.ibm.com/in ... opic=/rzajq/dms.htm
http://publib.boulder.ibm.com/in ... q/dbmonexamples.htm
首先要知道job number ，user，job name 启动dbmon
                     Start Database Monitor (STRDBMON)

Type choices, press Enter.

File to receive output . . . . . > DBMON1107    Name
Library  . . . . . . . . . . . > BOT       Name, *LIBL, *CURLIB
Output member options:
Member to receive output . . . *FIRST       Name, *FIRST
Replace or add records . . . . *REPLACE    *REPLACE, *ADD
Job name . . . . . . . . . . . . > QZDASOINIT Name, generic*, *, *ALL
User . . . . . . . . . . . . . > QUSER    Name, generic*, *ALL
Number . . . . . . . . . . . . > 009787    000000-999999, *ALL
Type of records  . . . . . . . . *BASIC       *BASIC, *DETAIL, *SUMMARY
Force record write . . . . . . . *CALC       0-32767, *CALC
Run time threshold . . . . . . . *NONE       0-2147483647, *NONE
Storage threshold  . . . . . . . *NONE       0-2147483647, *NONE
Include system SQL . . . . . . . *NO          *NO, *YES, *INI


会提示一个monitor ID 记住这个号码关闭DBMON时候会使用到，DBMON长期开着可能会占用大量系统资源
                     Additional Message Information

Message ID . . . . . . : CPI436A    Severity . . . . . . . : 00
Message type . . . . . : Information
Date sent  . . . . . . : 11/07/09    Time sent  . . . . . . : 17:19:15

Message . . . . : Database monitor started for job 009787/QUSER/QZDASOINIT,
monitor ID 0097870001.
Cause . . . . . : The database monitor was started for job
009787/QUSER/QZDASOINIT. The system generated monitor ID for this database
monitor is 0097870001.
   If multiple monitors have been started using the same generic job name,
the monitor ID is needed to uniquely identify which monitor is to be ended
with the ENDDBMON command.
Recovery  . . . : If multiple monitors have been started using the same
generic job name, remember the monitor ID. The monitor ID will be required
when using the ENDDBMON command to end this specific monitor.



用STRSQL查看 DBMON1107 会有被监控作业的具体运行的SQL等诸多信息（被监控作业时PD写的ODBC 作业）

QQ1000
-
SELECT "XQ11_USR", "XQ11_CPY", "XQ11_DPT", "XQ11_DPTDSC", "XQ11_LNGCOD", "FILLE
'C8E9C1C1F0F1F1404040'

HZTDB/XQ11L1  4, HZTDB/XQ11  0
-



SELECT "XQ11_USR", "XQ11_CPY", "XQ11_DPT", "XQ11_DPTDSC", "XQ11_LNGCOD", "FILLE

CLOSE SQL_CUR0003E708
SELECT DISTINCT substring("XQ05_USR",3,2)  FROM "XQ05" WHERE ( "XQ05_APP" = ?
'AM', 'ARTMTC ', 'GD', 6

关闭DBMON 填入别监控job 的name，user，number和Monitor ID
                     End Database Monitor (ENDDBMON)

Type choices, press Enter.

Job name . . . . . . . . . . . . > QZDASOINIT Name, generic*, *, *ALL
User . . . . . . . . . . . . . > QUSER    Name, generic*, *ALL
Number . . . . . . . . . . . . > 009787    000000-999999, *ALL
Monitor ID . . . . . . . . . . . > 0097870001 Character value, *ALL
Comment  . . . . . . . . . . . . *BLANK

作者: jusdfjj 时间: 2009-11-23 11:32
标题: lecteur mp3
lecteur mp3 as become an event bigger than anyone could have ever anticipated.Being just another lecteur mp3 player,what makes the baladeur mp3 playerdifferent then?

作者: jusdfjj 时间: 2009-11-23 11:33
标题: ipod Nano MP4 Player
The best MP4 Player will not be the same to everyone. Depending on the features you require, the best iPod Nano MP3 Player and ipod Nano MP4 Playerfor you will most likely be a different model then the best model for anyone else.

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)