适用db2support收集诊断信息
来源:互联网 发布:sql查询字段相同记录 编辑:程序博客网 时间:2024/05/18 02:25
当db2发生故障需要DB2 支持部门支持时,往往需要我们提供db2support的信息,一般这样即可。 /db2/db2prd/logbak为存放生成的诊断信息的目录,可以为有权限的任意目录
bash-3.2$ db2support /db2/db2prd/logbak/ -d prd -c -s -f _______ D B 2 S u p p o r t ______This program generates information about a DB2 server, includinginformation about its configuration and system environment. The output ofthis program will be stored in a file named 'db2support.zip', locatedin the directory specified on the application command line. If you areexperiencing problems with DB2, it may help if this program is runwhile the problem is occurring.NOTES: 1. By default, this program will not capture any user data from tables or logs to protect the security of your data. 2. For best results, run this program using an ID having SYSADM authority. 3. On Windows systems you should run this utility from a db2 command session. 4. Data collected from this program will be from the machine where this program runs. In a client-server environment, database-related information will be from the machine where the database resides via an instance attachment or connection to the database.Output file is "/db2/db2prd/logbak/db2support.zip"Time and date of this collection: "Fri Apr 29 15:31:40 GMT+08:00 2016 GMT+08:00"Collecting "System files" "110101301.000" "110756701.000" "112067441.000" "123864281.000" "56362901.000" "70123821.000" "83886141.000" "a8388614.000" "db2cos110101301.0" "db2cos110756701.0" "db2cos112067441.0" "db2cos121897161.0" "db2cos56362901.0" "db2cos70123821.0" "db2diag.log_2016-04-29-15.17.57" "db2eventlog.000.crash" "db2prd.nfy" "l0620148.000" "l2066938.000" "l4568838.000" "l7044938.000" "r11010130.000" "r11075670.000" "r11206744.000" "r12189716.000" "r5636290.000" "r7012382.000" "t11010130.000" "t11075670.000" "t11206744.000" "t12189716.000" "t5636290.000" "t7012382.000" "t8388614.000" "DB2TSCHG.HIS" "SQLBP.1" "SQLBP.2" "SQLDBCON" "SQLDBCONF" "SQLOGCTL.LFH" "SQLOGMIR.LFH" "SQLSGF.1" "SQLSGF.2" "SQLSPCS.1" "SQLSPCS.2" "db2rhist.asc" "db2systm" "db2cli.ini" "sqldbbak" "sqldbdir" "sqldbins" "report.log" Collecting "Detailed operating system and hardware information"Collecting "System resource info (disk, CPU, memory)"Collecting "Operating system and level"Collecting "JDK Level"Collecting "DB2 Release Info"LIC1440I License compliance report generated successfully. Collecting "DB2 install path info"Collecting "Registry info"Collecting "EEE node information" Collecting "Get dbm cfg" Collecting "Get admin cfg" Collecting "List database directory"Collecting "Sqllib directory listing"Collecting "Sqllib directory listing" SQL Code: "-1027" Collecting "List node directory" SQL Code: "-1027" SQL Code: "-1027" Collecting "List admin node directory" SQL Code: "-1027" SQL Code: "-1311" Collecting "List DCS directory" SQL Code: "-1311" Collecting "Get cli cfg" Collecting "List DCS applications extended" Collecting "Query client" Collecting "List active databases" Collecting "DB CFG for node 0" Collecting "List history since 20160329 for db prd" SQL Code: "-104" Collecting "List datalinks managers for database prd" SQL Code: "-104" Collecting "List applications for database prd global show detail"...attempting to connect to database: "prd" Collecting "Buffer pool information"Collecting "Table space information" Collecting "List nodegroups show detail" Collecting "Get snapshot for all applications" Collecting "Select count(*) from sysibm.systables where type='T' and creator <> 'SYSIBM'" Collecting "Select max(stringid) from sysibm.sysxmlstrings" Collecting "Get snapshot for all databases global" Collecting "List packages for all" Collecting "List tables for all show detail" Collecting "List indoubt transactions" SQL Code: "-1462" Collecting "List DRDA indoubt transactions" SQL Code: "-1462" Collecting "List command options" Collecting "List nodes" SQL Code: "-1297" Collecting "List ODBC data sources" SQL Code: "-1297" Creating final output archive "db2support.html" "db2_sqllib_directory.txt" "db2_log_directory.txt" "db2supp_system.zip" "JDKlevel.supp_cfg" "prd_node0_db.supp_cfg" "prd_node0_detailed_db.supp_cfg" "admin.supp_cfg" "bp.supp_cfg" "cli.supp_cfg" "dbm.supp_cfg" "dbm_detailed.supp_cfg" "ngrp.supp_cfg" "spcs_bp.supp_cfg" "ODBC_datasources.supp_out" "prd_dlfm.supp_out" "prd_list_hist.supp_out" "active_db.supp_out" "admin_nodedir.supp_out" "appsnap.supp_out" "db2greg.supp_out" "db2level.supp_out" "db2licm.supp_out" "db2licm_report.supp_out" "db2set.supp_out" "db_dir.supp_out" "dbmsnap.supp_out" "dbsnap.supp_out" "dcs_dir.supp_out" "dcsext.supp_out" "list_DRDA_trans.supp_out" "list_apps.supp_out" "list_cmd_opts.supp_out" "list_nodes.supp_out" "list_packages.supp_out" "list_tables.supp_out" "list_transactions.supp_out" "nodedir.supp_out" "query_client.supp_out" "tbspc.supp_out" "db2diag.log" "stmm.0.log" db2support is now complete. An archive file has been produced: "db2support.zip"
压缩包内有个db2support.html文件,从里面可以查看大致的一些情况
bash-3.2$ du -s -m *
3.58 db2support.zip
================================================
I. Collecting general support data
Enter the following command to collect the required data for the support team:
db2support -d -c -s -f
If problems occur when the system connects to the database, use the following command:
db2support -d -s -f
“`
0 0
- 适用db2support收集诊断信息
- 收集RAC诊断信息
- 自动化收集SQLSERVER诊断信息
- Java诊断日志收集
- db2 db2support
- 【转自mos文章】数据库 hang问题的诊断信息收集方法
- 数据库 数据库诊断信息
- 【转载自mos中文文章】Oracle 集群 10gR2/ 11gR1/ 11gR2/ 12cR1 诊断信息收集指南
- 信息收集
- 信息收集
- 信息收集
- 信息收集
- 信息收集
- 信息收集
- 信息收集
- 信息收集
- db2pd和db2support
- db2pd和db2support
- thinkphp框架中,URL传参c/123,接收不到参数的问题
- iOS制作演示gif
- 史上最全最强SpringMVC详细示例实战教程
- 使用AES时出现 Illegal key size or default parameters 时的解决办法
- Android调用系统裁剪的方法
- 适用db2support收集诊断信息
- 合并有序数组
- ssh连接超时自动logout问题
- linux之间copy传输文件方法
- 链表的实现(C++)
- OpenCV_基于混合高斯模型GMM的运动目标检测
- 连微软都不得不称赞的15款软件
- java设计六大原则之开闭原则(OCP)
- 百度地图:普通覆盖物,以及多边形覆盖物,及他们的描述信息的添加,修改,删除,查看功能,还有多边形根据名称查询功能;