(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]

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

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]

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

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

  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

  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

  对 于不能在 终止技术支持服务（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

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

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   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]

亮点 - 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

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

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