最即時的Sybase ASE Server資料庫診斷工具

Size: px

Start display at page:

Download "最即時的Sybase ASE Server資料庫診斷工具"

屐董
7 years ago
Views:

1 How to using M-Power Server 行 M-Power Report setup.exe M-Power Report Server MPRS 了說 M-Power Report Server 料行料料 M-Power Report Server J2SE Development Kit 5.0 連 port 料 MPRS Web-Application MPRS Page 1 of 18

2 J2SE Development Kit 5.0 行 M-Power Report Server 了 JDK 若 JDK Sun Sun J2SE 若 JDK 利兩令 JDK JRE 令 java -version javac version 行令令 1.5.xxx 了列行 java 令 JRE JRE 行 javac 令 JDK JDK Page 2 of 18

3 JDK 錄錄 JDK 錄 JDK 連 port 了 Apache Tomcat Servlet Container 了連異利行令令 netstat a 來 MPRS 連連來 MPRS 0-4 來 MPRS 令行 Page 3 of 18

4 0-4 連 ( ) 0-5 MPRS netstat -a 令行連 Page 4 of 18

5 0-5 連 ( ) MPRS 連行行 J2SE Development Kit 5.0 連來更行 1: setenv.bat A. <M-Power Report 錄 >\ReportServer\bin\setenv.bat B. J2SE Development Kit 錄 0-6 Page 5 of 18

6 0-6 setenv.bat C. 2: setenv.bat MPRS 立錄便 3 行 A. M-Power Report Report Server B. Tomcat conf\jk2.properties MPRS C. M-Power Report Report Server 3: setclasspath.bat 行 MPRS MPRS 狀來 A. <M-Power Report 錄 >\ReportServer\bin\setclasspath.bat B. rem === set CLASSPATH for MPRS === 行 C. 行令 rem Page 6 of 18

7 D. set mprsroot MPRS 錄 (<M-Power Report 錄 >\ReportServer) E. set CLASSPATH 錄 ( C:\Windows\Fonts 錄 Windows 異 ) 0-7 F. 0-7 setclasspath.bat Page 7 of 18

8 料行 M-Power Report Server 了料料了料 M-Power Report Server 料了料料料料料料料 Table 0-1 Table Name Table Description System / User SYS_PROP 參數 SYSTEM CONN_PROFILE 連 SYSTEM REPORT SYSTEM REPORT_PARAMS 參數 SYSTEM REPORTGROUP SYSTEM REPORTGROUP_REPORT SYSTEM ROLE USER USERGROUP USER USER USER USERGROUP_ROLE USER USER_ROLE USER USERGROUP_PERMISSION SYSTEM / USER USER_PERMISSION SYSTEM / USER MODULE SYSTEM MODULE_ROLE SYSTEM / USER 0-1 Table 列 Page 8 of 18

9 料料料 Table 0-2 Table Name Table Name QRTZ_CALENDARS QRTZ_SCHEDULER_STATE QRTZ_FIRED_TRIGGERS QRTZ_TRIGGERS QRTZ_JOB_DETAILS QRTZ_SIMPLE_TRIGGERS QRTZ_JOB_LISTENERS QRTZ_TRIGGER_LISTENERS QRTZ_LOCKS QRTZ_CRON_TRIGGERS QRTZ_PAUSED_TRIGGER_GRPS QRTZ_BLOB_TRIGGERS 0-2 Table 列 Page 9 of 18

10 MPRS Web-Application 行 M-Power Report Server 了 Web-App 參數 MPRS Web Application 例料讀料 Data Source JNDI Web-App 參數 MPRS web.xml 列 <web-app> <security-constraint> <web-resource-collection> <web-resource-name>mprs resource</web-resource-name> <url-pattern>*.jsp</url-pattern> <url-pattern>*.html</url-pattern> <url-pattern>*.htm</url-pattern> <url-pattern>*.do</url-pattern> <http-method>get</http-method> <http-method>post</http-method> </web-resource-collection> <auth-constraint> <role-name>mprsadmin</role-name> <role-name>mprsuser</role-name> </auth-constraint> </security-constraint> <security-role> <description>the M-Power Report powerful user</description> <role-name>mprsadmin</role-name> </security-role> <security-role> <description>the M-Power Report user</description> <role-name>mprsuser</role-name> </security-role> </web-app> Page 10 of 18

11 例料 M-Power Report {M-Power Report 錄 }\MPowerReport\DemoDatabase 例料 M-Power Report Designer 例料來例料參數錄 server.properties 列 #HSQL Database Properties server.database=test/test server.silent=true server.trace=false server.port=5869 server.no_system_exit=false 若 M-Power Report Server 利料讀料 Tomcat Admin Tool 立 Data Source JNDI 例料 1: admin 2: Tomcat Admin Tool Service(Tomcat-Standalone) Host(localhost) Conext(/mprs) Resources Data Sources 0-8 Page 11 of 18

12 0-8 Context(/mprs) Resources 列 3: JNDI Name jdbc/testdb JNDI Name 4: JNDI 0-10 Page 12 of 18

13 0-10 JNDI Name-jdbc/TestDB- Page 13 of 18

14 了 Save Commit Changes Tomcat 料 0.4 料說了 M-Power Report Server 料 Table 列列料料 M-Power Report 錄 \MPowerReport\ReportServer\bin server.properties 料連料 M-Power Report 錄 \MPowerReport\ReportServer\webapps\mprs\WEB-INF\classes connection.properties 連料 M-Power Report 錄 \MPowerReport\ReportServer\webapps\mprs\WEB-INF\classes quartz.properties MPRS M-Power Report Server Web Application 讀理了 Report Server 邏來理 M-Power Report Server 說..\webapps\mprs htm, html, jsp, js, css..\webapps\mprs\web-inf\lib 錄 mrs.jar M-Power Report..\webapps\mprs\WEB-INF\lib 錄 reportapi.jar Page 14 of 18

15 ..\webapps\mprs\web-inf\lib 錄 jar 料..\common\lib 錄 hsqldb.jar 連料 Oracle Sybase... 料 JDBC Driver 錄 M-Power Report Server..\webapps\mprs\WEB-INF\classes 錄 ReportServer.license..\webapps\mprs\WEB-INF\classes 錄 MPowerChart.license 參數 I..\webapps\mprs\WEB-INF\classes 錄參數 0-3 參數說 log4j.properties log quartz.properties 更 0-3 參數參數 II..\webapps\mprs\WEB-INF\conf 錄參數 0-4 參數說 connection.properties 料更 mprs.properties M-Power Report Server 更 sqlmap.properties SQL command 更 0-4 參數 Page 15 of 18

16 例料說了 M-Power Report Server 不 M-Power Report Server 來連料例 M-Power Report 例料了 M-Power Report Designer Tutorial 料料省略 1: M-Power Report Demo Database Start Demo Database 2: Demo Database 3: Listening for connections... Demo Database Demo Database 例料 1: M-Power Report Demo Database Stop Demo Database 2: Demo Database Page 16 of 18

17 Report Server 說 M-Power Report Server Report Server M-Power Report Server 行兩料 M-Power Report Server 料料料來 M-Power Report Server 4: M-Power Report Report Server Start Report Server 料料了了料 5: Listening for connections... 料料 M-Power Report Server 料來 M-Power Report Server 6:..\conf\jk2.properties M-Power Report Server 0-2 Page 17 of 18

18 0-2 M-Power Report Server Report Server M-Power Report Server 行兩行料 M-Power Report Report Server Stop Report Server Page 18 of 18

untitled

untitled 309 * 麟 ** *** 李 **** ***** 年 2014 年 31 8 91% 5% 4% 1 年年 5 17 18 行 27 1,205 6 率 98.46% 2 3 錄 21 1,171 錄率 92.77% 6 3 錄 11.99 2.13 數 15 4,320 率 73.08% 不數 14 8,044 率 73.89% 4 列率 6 率 1.48% 不易讀 * 立 **