Usually , we will suggest customer to collect following data : 1. db2support with catalog information db2support -o db2support.zip -d <dbname> -sf ./problematic.sql -cl 1 2. Section dump We prefer to use first method , we can choose method #2 if the EUD id is not easy to identify for the fast complete SQL statement. Method #1： 1> Run problematic statement 2> Find out the corresponding EDU ID 3> db2pd -dump <eduid>＃ We will have file with name like ..dump.bin generated under DIAGPATH Method #2： 1> db2 ".db2service... [More]

There are several approaches to resolve your IBM software issues - 1.  Search for answers from internet via search engines like Google, baidu or IBM website. 2.  Post a question in dwAnswer community for simple questions     https://developer.ibm.com/answers/index.html   3.  Open a ticket for complex issues either through SR tool or call IBM hotline, this is open to entitled customers only and requires an "ICN" customer number。      SR tool link ... [More]

Tags:  support hotline handbook sr tool software

在DBA常用的命令中，有的命令需要的时间可能比较长。以下总结了常见的命令及监视方法。 DB2命令 监视方法 Crash Recovery db2pd -rec -db <dbname> db2pd -util 参照: http ://w ww-0 1.ib m.co m/su ppor t/do cvie w.ws s?ui d=sw g216 5528 6 优化: UTIL_HEAP_SZ, adjust parallelism by  setting number of redo workers, eg, set to 5 below(the below number 6 = 5 workers + 1 redo master): db2set DB2BPVARS=<path to buffer pool config file> In the config file, put this line: PREC_NUM_AGENTS=6 Rollforward db2pd -rec -db <dbname> db2 list utilities show detail or db2pd -util 优化: same as Crash... [More]

Question: Why does "prune history and delete" retain history entries and LOG files on V10.5 FP8?   Cause: It is an known expected behavior. Answer: Here is a sample test scenario. ---------- #!/bin/ksh db2 drop db db1 export ARCHMETH=/tmp/archmeth rm -rf $ARCHMETH mkdir $ARCHMETH db2 create db db1 db2 connect to db1 db2 "create table t1(c1 int)" db2 update db cfg for db1 using LOGFILSIZ 10 LOGPRIMARY 6 LOGSECOND 2 db2 update db cfg for db1 using LOGARCHMETH1 DISK:$ARCHMETH db2 backup db db1 to /dev/null db2 connect to... [More]

Tags:  db2support db2luw db2

Enhanced IBM SDDUU Java utility for uploading large files to ECuRep.  Check out more details from the following link - https://www.ibm.com/developerworks/community/blogs/IBMElectronicSupport/entry/video_using_sdduu?lang=en   For China clients, you can also refer to the following technote for the tips of tool configuration http://www.ibm.com/support/docview.wss?uid=swg21985751&myns=swgimgmt&mynp=OCSSEPGG&mync=E&cm_sp=swgimgmt-_-OCSSEPGG-_-E

Tags:  pmr upload，tool

DB2管理者が行うコマンドの中に、時間がかかる可能性のあるコマンドの監視方法をまとめました。 DB2コマンド・アクティビティ 監視方法 クラッシュ　リカバリー db2pd -rec -db <dbname> db2pd -util ほかの情報: http ://w ww-0 1.ib m.co m/su ppor t/do cvie w.ws s?ui d=sw g216 5528 6 パフォーマンス　最適化: UTIL_HEAP_SZ, adjust parallelism by  setting number of redo workers, eg, set to 5 below(the below number 6 = 5 workers + 1 redo master): db2set DB2BPVARS=<path to buffer pool config file> 次の1行を入れる: PREC_NUM_AGENTS=6 ロール　フォーワード db2pd -rec -db <dbname> db2 list utilities show detail or db2pd -util パフォーマンス 最適化:　クラッシュ... [More]

Unavoidably some commands are time-consuming. This blog summarizes the commands that you can use to monitor the progress of DB2 commands. DB2 Commands/Activities Monitoring Commands Crash Recovery db2pd -rec -db <dbname> db2pd -util Further reading: http://www-01.ibm.com/support/docview.wss?uid=swg21655286 Perf tuning: UTIL_HEAP_SZ, adjust parallelism by  setting number of redo workers, eg, set to 5 below(the below number 6 = 5 workers + 1 redo master): db2set DB2BPVARS=<path to buffer pool config file> In the config file, put... [More]

This blog explains a scenario that caused rollforward failure. The following is the rollforward command that failed: $ db2 "rollforward database DB1 to end of backup ON ALL DBPARTITIONNUMS and complete tablespace (TS1) online" SQL1042C An unexpected system error occurred. SQLSTATE=58004 To diagnose the problem, verify db2daig.log: <timestamp> LEVEL: Warning PID : 12345678 TID : 123456 PROC : db2sysc 0 INSTANCE: db2ins1 NODE : 000 DB : DB1 APPHDL : 0-1234 APPID: *N0.db2ins1.12345678 AUTHID : DB2INS1 HOSTNAME: host11 EDUID :... [More]

Tags:  rollforward

This Blog explains how you can monitor the progress of your load commands and in case there is a performance concern on the load commands, where you can check the cause of the slowness. 1. Monitor Load Progress You can use db2pd -util command to monitor load progress. For instance, the following output has two load commands ongoing: Database Member 0 -- Active -- Up 6 days 05:15:41 -- Date 2016-12-14-03.31.20.222374   Utilities: Address           ... [More]

Tags:  load

1. db2look failed with following error: $ db2look -d sample -e -o db2look.ddl -- Generate statistics for all creators -- Creating DDL for table(s) -- Output is sent to file: sample.ddl SQL10004C  An I/O error occurred while accessing the database directory. SQLSTATE=58031 2. error in db2diag.log 2017-04-11-02.48.11.615491-240 I38860E2300           LEVEL: Error (OS) PID     : 28473               ... [More]

Tags:  db2luw im_support

DB2 v9.7 and v10.1 will be EOS(end of support) on Sep. 30, 2017.  Customers can upgrade their DB2 v9.7 or v10.1 systems to DB2 v11.1 FP1 directly to skip 11.1 GA version.    The first fix pack delivered for DB2 V11.1 changes the modification level of the product to 1 and has the product signature of DB2 11.1.1.1. Subsequent fix packs for the DB2 V11.1 product will be based on this modification level (e.g. the next fix pack will have the signature DB2 11.1.1.2).

Tags:  upgrade v10.1 db2 v11.1 eos v9.7

http://edm.file.greatseacn.com/2017edm/2017031701/index.html

Tags:  newsletter 10.1 9.7 11.1 upgrade ha hadr eos purescale db2 china

I am sharing the experience of how to change hostname+ipaddress in existing purescale environment with db2iupdt -drop/-add options. The current existing environment is as followings: ----------------------------------------------------------------------------------------------------- db2sdin1@ps101:~> db2instance -list ID        TYPE             STATE               ... [More]

Tags:  db2support purescale imsupport db2luw

SYSIBMADM.SNAPSTORAGE_PATHS administrative view  is not returning values against some of the columns.  Instead it's showing "-".   Example, $ db2 "select FS_TOTAL_SIZE, FS_USED_SIZE, STO_PATH_FREE_SIZE from sysibmadm.snapstorage_paths" FS_TOTAL_SIZE        FS_USED_SIZE         STO_PATH_FREE_SIZE -------------------- -------------------- --------------------... [More]

Tags:  db2support snapstorage_paths db2luw