To utilize the transaction-level workload balancing with purescale, you can set enableSysplexWLB as true from your java client application(ref 1). This will distribute your workload to the members in purescale.   For this distribution, a new connection could be made to a member of purescale if your java appclication did not have any connection with that member based on the server list with the connection detail(IP address, port, and weight) for the members of the DB2 purescale instance(ref 2).   However, a new thing I found out is... [More]

There are several ways you can check the current size of "Shared Sort Heap". Let me list some of them below. 1. database snapshot 2. db2mtrk 3. sysibmadm.snapdb 4. MON_GET_DATABASE table function   When you check the data for each, however, you will find out that #1, #2 and #3, #4 have the different value. Let me show actual data from a test machine.   -------------------------------- 1. database snapshot $ db2 get snapshot for database on tstv105 | gnugrep -A3 "Shared Sort Heap"     Memory... [More]

A couple of db2 purescale customers have recently observed that the db2diag.log in a purescale environment might have some SEVERE messages logged with no operational problems in database associated with it. The severe messages logged in db2diag.log are as follows :   2017-07-10-11.40.16 .000086+540 I202891A5897         LEVEL: Severe  PID     : 23068794             TID :... [More]

When you drop database partitions from your DPF instance, you should not edit the db2nodes.cfg file manually but should use db2stop drop partitionnum command.   If you edit the db2nodes.cfg file manually to drop database partitions and there is a database partition group using the dropped partitions, it will cause a problem.  Here is an example when editing the db2nodes.cfg file manually(bad case):   $ cat ~/sqllib/db2nodes.cfg 0 alexx 0 1 alexx 1 2 alexx 2 3 alexx 3   $ db2start $ db2 create db test on $PWD $ db2 connect to... [More]

Tags:  db2

QUESTION: ========= Here is an example, V10.5 vs V11.1. * IBM DB2 10.5 for Linux, Unix and Windows documentation * IBM DB2 11.1 for Linux, Unix and Windows documentation Browsing pages between V11.1 and V10.5 above.  We may find V11.1 page has newer information than V10.5.  Here is one. * V11.1, fcm_parallelism - Internode communication parallelism configuration parameter ... Default [range]... [More]

Tags:  db2luw db2 db2support

When oracle mode is used in db2, you might see the approximation error when you convert a value to decimal data type while original DB2 does not make this error. This is because the oracle mode follows the decflt_rounding from database cfg which would have an approximation error.   Please check the following example which shows difference between original db2 and oracle mode.   ------------------------------------------- SQL: db2 -x "values decimal(double(0.1),31,20)" oracle mode output: 0.10000000000000001000 db2 mode... [More]

Webinar! How to Configure DSM User Authentication Using LDAP or Repository   Please join Jason Sizto, InfoSphere Optim Tools Development Senior Engineer, for a demo on How to Configure DSM User Authentication Using LDAP or Repository Date: Wednesday, September 20 Time: 12:00pm - 1:00pm EDT Register: https://ibm.co/DSMAugWebinar In this talk, you will learn how to:   setup DSM to use LDAP for authentication   setup DSM user privilege when using LDAP authentication setup DSM to use repository for authentication setup DSM user... [More]

The subject of this edition is "DB2 pureScale". Please check the link below to find more http://content.emm.ibmmail.com/frontend/dynamicAssets?e=tC42635C995AD9A0CDC8CB7BEFD638B2B44F8F925ECFB43291AEBAF3F869DB04C5591957300630E4900A467C15C2F9679F345BD9330928CC7E7679FB64C8432374ADEA7E888AF3EF5DA087CC57C7087C5F4C13C563393ACD51AEFBFF9B0229DB3502FDA80BA565411

Tags:  db2 purescale

In DB2LUW there are many reasons why loads might be slower. It might be a config issue at Db2 or, even OS level.  Or, might be a tuning need for the load command itself.   But, one thing commonly overlooked is what kind of diagnostic dumps are enabled when loads are running.   It’s observed when multiple Db2 partitions are sharing  a same physical host and sharing same  db2diag.log  file  there might be severe  contentions around db2diag.log file if large amount of messages are dumped into the... [More]

Tags:  load db2luw db2diag.log slow diaglevel

In DB2LUW for some reason we faced some issues with the archive mechanism and we want to restart the archive mechanism ONLY and not the whole database or instance. So, how to restart the archiving mechanism without restarting a database.   There is a way   to restart the archiving mechanism when it uses vendor code.   It’s,  db2pd -fvp   It’s documented in the Knowledge Center, https://www.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0011729.html  ... [More]

Tags:  db2pd restart db2luw -fvp archiving

This question comes many times. So, trying to clarify a bit.   We have a Db2  application snapshot and it’s not showing the statement the application is running.  Instead it’s showing package details.   Example, --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------             Application Snapshot   Application... [More]

Tags:  static section db2luw sql number

There was a situation faced lately by a customer where a hard crash happened in one physical hosts of a DPF setup.   There were some hardware issues. They brought back the DPF instance in all the partitions. But, trying to activate the database was continuously getting SQL1229 from one of the members. SQL1229N  The current transaction has been rolled back because of a       system error.   The database was restarted with, db2_all "db2 restart database DW_AUDIT"   Sill problem was... [More]

Tags:  deactivate -1229 activate db2luw sql1229

When you convert a value to decimal data type in DB2 ORACLE mode, you will see that the conversion follows different rule from ORACLE. 1. DB2 ORACLE  mode : decflt_rounding in database cfg 2. ORACLE  : ROUND_HALF_UP And default value for decflt_rounding is ROUND_HALF_EVEN in DB2. So you will see different results if you just set DB2_COMPATIBILITY_VECTOR to ORA in DB2.     For better understanding, let me compare the same examples between two. 1. DB2 ORACLE mode DB2 ORACLE mode will follow... [More]

In a purescale environment TSA is used to monitor the various resource that need to be running to ensure a healthy purescale system.   It might happen that some of these resource fail. If that is the case you want to find out which one it is and take proper actions. Sometimes it's not easy to navigate the various files to find out what happened.   This small document will use a live example to show you how to do it.   When a problem occurs it will be reported in the system log files that can be viewed using 'errpt... [More]

Tags:  timeout tsa db2