• Share
  • ?
  • Profiles ▼
  • Communities ▼
  • Apps ▼

Blogs

  • My Blogs
  • Public Blogs
  • My Updates

Thoughts from Support

  • Log in to participate

About this blog

Part of the IBM Analytics family, focused on support for IBM Analytics products. This blog is administered by Kate Nichols and follows the IBM Social Computing Guidelines.
  • Facebook
  • Twitter
  • Google
  • LinkedIn
  • RSS

Archive

  • April 2018
  • March 2018
  • February 2018
  • January 2018
  • December 2017
  • November 2017
  • October 2017
  • September 2017
  • August 2017
  • July 2017
  • June 2017
  • May 2017
  • April 2017
  • March 2017
  • February 2017
  • January 2017
  • December 2016
  • November 2016
  • October 2016
  • September 2016
  • August 2016
  • July 2016
  • June 2016
  • May 2016
  • April 2016
  • March 2016
  • February 2016
  • January 2016
  • November 2015
  • October 2015
  • September 2015
  • August 2015
  • July 2015
  • June 2015
  • May 2015
  • April 2015
  • March 2015
  • February 2015
  • January 2015
  • December 2014
  • November 2014
  • October 2014
  • September 2014
  • August 2014
  • July 2014
  • June 2014
  • May 2014
  • April 2014
  • March 2014
  • February 2014
  • January 2014
  • December 2013
  • November 2013
  • October 2013
  • September 2013
  • August 2013
  • July 2013
  • June 2013
  • May 2013
  • April 2013
  • March 2013
  • February 2013
  • January 2013
  • December 2012
  • November 2012
  • October 2012
  • September 2012
  • August 2012
  • July 2012
  • June 2012
  • May 2012
  • April 2012
  • March 2012
  • February 2012
  • January 2012
  • December 2011
  • November 2011
  • October 2011
  • September 2011
  • August 2011
  • July 2011
  • June 2011
  • May 2011
  • April 2011
  • March 2011
  • February 2011
  • January 2011
  • December 2010
  • November 2010
  • October 2010
  • September 2010
  • August 2010
  • June 2010
  • May 2010
  • April 2010
  • March 2010
  • February 2010
  • January 2010

Tags

All posts
  • Sort by:
  • Date ▼
  • Title
  • Likes
  • Comments
  • Views

How to drop CF from cluster when the Operating System on the resided physical machine wrongly removed?

Yi Lei Wang 2700069G84 | | Visits (2830)

Tweet
Customer wrongly removed the Operating System on one cf host , now they need to stop the service and drop it from cluster  , how to do next ?  Following is the scenario in customer's real case , the procedure contains how to achieve the purpose and how to solve the problem we hit during the process , record here for you to follow or refer to  . 1. We can use  "db2stop cf 129 force" and "db2stop instance on p780k8 force"to stop the service 2. db2sdin1@p780k5_KEHUA:/home/db2sdin1> db2instance -list... [More]

How to offline change IP address on pureScale ?

Yi Lei Wang 2700069G84 | | Visits (2929)

Tweet
(We have technote below to online change IP address , customer followed the steps , it's not progress unfortunately .) http://www-01.ibm.com/support/docview.wss?uid=swg21594983 Following procedure is got by working with GPFS team and has already validated by customer ,  note that this is a completely offline operation . 1. As an instance user, perform the following steps:     1). Stop the database manager on all hosts by issuing the following command on a single host:     su -iname    ... [More]

'STMTID' the 2nd episode - Understanding by examples

Jun Su Lee 27000725GN | | Visits (4254)

Tweet
Some years ago, I wrote a blog about using 'STMTID' to track long term performance changes for SQLs. ( Blog link : 'STMTID' - The key for long term performance tracking of an SQL ) Has anyone of you ever applied to your system ? Intermittently, I have gotten personal contacts asking to give some examples showing how it works. So here let me introduce very simple examples just to share what I meant. To remind, ' mon_get_pkg_cache_stmt ' function has... [More]

Tags:  performance

Decimal data type conversion differences between db2 and oracle mode

WoongChoi 505V5WD6N5 | | Visits (3031)

Tweet
When float/double data type number is converted to decimal data type, some digits might be truncated by the precision and scale parameter in decimal data type definition. In this situation, db2 mode and oracle mode use different policies like as follows. 1. db2 mode : digits are just  truncated from the end of the decimal number if the number of digits to the right of the decimal separator character is greater than the scale scale . 2. oracle mode : digits are truncated based on the DECFLT_ROUNDING  in db cfg.     For... [More]

[DB2 LUW] Sample administrative task schduler ADMIN_TASK_ADD and ADMIN_TASK_REMOVE usage

hidehy 100000AYJ5 | | Visits (3791)

Tweet
QUESTION: Could you guide us how to use administrative task scheduler ADMIN_TASK_ADD and ADMIN_TASK_REMOVE? We found each usage at KC but could not locate any sample usage case at the internet. ANSWER: Before using it, it is suggested to review below KC page for finding out the outline. The administrative task scheduler https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.admin.gui.doc/doc/c0054380.html ... The administrative task scheduler enables DB2R database servers to automate the execution of tasks. It also provides a... [More]

Tags:  db2support db2 db2luw

[DB2 LUW] When will DB2 LUW V11.1 PDF manuals be available?

hidehy 100000AYJ5 | | Visits (5645)

Tweet
QUESTION: ========= There is V11.1 online manual available at: DB2 database product documentation http://www-01.ibm.com/support/docview.wss?uid=swg27009474 but could not find any link for PDF manuals as V10.5, V10,1, V9,8. Here is an example, V10.5 for your reference: DB2 database product documentation http://www-01.ibm.com/support/docview.wss?uid=swg27038430 ... DB2 documentation available online and downloads DB2 documentation updates DB2 documentation as PDF manuals Best practices for DB2 for Linux, UNIX, and Windows ... When will V11.1 PDF... [More]

Tags:  db2support db2luw db2

Debunking the online vs offline db2dart myths

Jeff Andersen 060001JDPH | | Visits (3909)

Tweet
  There is a common misconception that db2dart is only an offline tool.   To understand the truth we have to understand 2 things:  that db2dart only reads data from disk and that there are 3 distinct types of db2dart options.      The answers begin by understanding that db2dart only reads data that is stored on disk.  This can cause issues when multiple pages are compared, such as during an inspection operation.   For example, if db2dart is validating a table and a user has inserted a row... [More]

Tags:  offline db2dart online

IBM Analytics new support option- Continuing support after product EOS including Db2,Informix,Cognos,ILG&ECM product line

dianesu 27000123JT | | Visits (6580)

Tweet
  Abstract IBM is pleased to announce a new support option available to you when your software reaches End of Service (EOS). IBM will offer Continuing Support for selected Analytics(Db2,Informix,ILG, ECM&Cognos) products and releases. This offering will provide you with continued access to the same knowledgeable global Support team you are working with today. Content IBM is pleased to announce a new support option available to you when your software reaches End of Service (EOS). IBM will offer Continuing Support for selected Analytics... [More]

Tags:  support ecm continuing cognos db2 analytics ilg

IBM Analytics产品线(Db2,Cognos,ILG&ECM)推出EOS后持续支持新选项

dianesu 27000123JT | | Visits (4373)

Tweet
  对 于不能在 终止技术支持服务(EOS) 之 前完成系 统升级的 客户, IBM Analytics 产品线近日推 出了一个 新举措来为 客户的业 务连续性 保驾护航 : 这些产品在EOS 后 继续提供 非代码补 丁级别的 技术支持 。 有了这个新服务,客户就可以在产品 EOS 后继续选择享受 IBM 全球的技术支持资源 – 只需继续购买产品的标准维保服务( S&S )即可。   这是 : 对现有标准维保服务的增强 客 户 有更多的 时间缓 冲做系 统 升 级 继续协助并解决客户遇到的技术问题 可以提供已有的代 码补 丁 但非 : 替代 现 有的 标 准 维 保服 务 替代 现 有的 维 保延 续 服 务 代 码级别 的新 补 丁 第三方的 组 件 问题   涵盖的产品线及版本: Db2 所有版本   Cognos BI 10.2及后续版本   Content Collector 4.0 及后 续 版本 Content Collector for SAP Applications 4.0 及后 续 版本 Content Foundation 5.2 及后 续 版本 Content Integrator 8.6... [More]

Tags:  ecm support analytics ilg cognos db2 eos

Db2 Warehouse on Cloud - my new "daily driver"

ryanmark 120000EPU7 | | Visits (4060)

Tweet
There's a saying amongst car fans to designate the vehicle that they use for general transportation - the daily driver.  While exotic cars may be suited for the race track, or for special occasions, the daily driver is reliable, convenient and straightforward to use. I had been using Db2 (formerly DB2 for Linux, UNIX, and Windows) for years to maintain business process information and perform ad-hoc queries... about Db2! I need to be able to answer questions like "how many Db2 V11 PMRs were opened in the last 3 months", or... [More]

Tags:  dsm db2 dashdb

How to list row-orgnized or column-organised tables in DB2 V10.5 onwards.

AjayMPatil 31000030FM | | Visits (3765)

Tweet
We can use SYSCAT.TABLES and TABLEORG column under same . TABLEORG     CHAR(1)                C = Column-organized table     R = Row-organized table     N = Not a table To list row organized Tables: db2 "SELECT substr(tabschema,1,20) AS tabschema,substr(tabname,1,40) AS tabname FROM syscat.tables WHERE  tableorg='R' AND tabschema NOT LIKE ('SYS%')" To list column organized Tables: db2 "SELECT substr(tabschema,1,20)... [More]

Tags:  organized column syscat.tables tableorg row

Db2 SQL Performance Optimization using IBM Data Server Manager

katieschiefer 50TA3PN504 | | Comment (1) | Visits (3432)

Tweet
Db2 SQL Performance Optimization using IBM Data Server Manager   IBM DSM helps to optimize the SQL performance of IBM Db2 LUW/zOS databases. If you are a developer, DBA, or query tuning specialist, your understanding of the basics of access paths is critical in allowing you to precisely tune queries and query workloads before they cause a problem in your production environment. This basic understanding, coupled with the visualization and tuning advice provided by IBM DSM, will help make you more efficient at this task. Please join Ashok... [More]

Db2 最新版本 v11.1.2 发布了

dianesu 27000123JT | | Visits (4177)

Tweet
亮点 - BLU 性能增强 允许在 列组织 表中执行并行插入的增强功能 HADR功能增强 更快速的 pureScale® 成员崩溃恢复 pureScale支持数据库重建功能 数据库可配置为允许在崩溃恢复期间进行连接 数据库崩溃恢复和事务回滚性能改进 提供避免锁升级的数据库配置 支持创建加密样本数据库 CLI 增强 引进 Developer-C版本 ...... 详情请查阅官网的信息中心: https://www.ibm.com/support/knowledgecenter/zh/SSEPGG_11.1.0/com.ibm.db2.luw.wn.doc/doc/c0061179.html 该版本包含的APAR列表: http://www-01.ibm.com/support/docview.wss?uid=swg21995889   Download

Tags:  v11 db2

DB2 China Newsletter June Edition(DB2 中国月刊)

dianesu 27000123JT | | Visits (2764)

Tweet
The theme of this edition is "DB2 recovery". Check out the link below to find more http://content.emm.ibmmail.com/frontend/dynamicAssets?e=t1265FF49FBF9450CDC8CB7BEFD638B2B44F8F925ECFB432943722976C87A34845591957300630E4900A467C15C2F9679F410CBA0C3A26F9522DCF20CA7FFC1344ADEA7E888AF3EF5DA087CC57C7087C5F4C13C563393ACD51AEFBFF9B0229DB3502FDA80BA565411

Tags:  db2, recovery newsletter

[One page problem in plan optimization] Will an access plan be remain unchanged after collecting stats if no further stats is corrected and auto_runstats is disabled ?

ikalos 12000082VW | | Visits (2936)

Tweet
We are sometimes asked questions about plan stability. For example. -We can correct stats and check the access plan, but if we no longer correct stats, will the plan be stable ? -Does applying db2look -m output generates the same plan on another databases ?     The answers are no, not always. Even after collecting stats, DB2 may fabricate stats which may change the access plan if the data fits into initially allocated one page of the table and exceeded later on. Here's the outlined repro scenario of the symptom. Note, It can be... [More]

Tags:  db2luw optimizer
  • Show:
  • 10
  • 20
  • 30
  • Previous
  • Next
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61