Have you heard about IBM InfoSphere Guardium or Guardium product as it is usually called? If not, read below a brief description of what this product can do to protect your database access with a powerful product. Or, if you have heard or have experience using the product, please share your experiences. What is IBM InfoSphere Guardium: It is a product that can be a combination of dedicated hardware (appliance) and software or just software (a virtual appliance plus additional software) . It provides a solution for
assuring the privacy and... [More]
This weekend, we'll be performing some
critical maintenance on our systems, and as such, our technical support
content will be unavailable for a period of time between 9:00 pm ET May 21 2011 and 5:20 am ET May 22 2011. What you can expect: The IBM Support Portal will be operational, and Site Availability and News portlet will contain information on the outage Search will provide results; but links will not reach content Our apologies for the temporary inconvenience.
Answer : What is the coolest thing from IBM right now? Question : Elementary - Watson! In February, Watson is going to be competing with two top champions to answers questions on America's tough game show, Jeopardy. How cool is that? And going forward, what questions could Watson help to answer for you?!? Check it out: http://ibmresearchnews.blogspot.com/2010/12/how-watson-sees-hears-and-speaks-to.html Navigate using a QR code scanner Open your prefered QR code scanner. Point your phone camera at the QR code below and scan it (click... [More]
First off, Happy New Year! I hope 2011 finds you and yours safe and well. Second, we want to share a compliment we are very proud of: In December, we posted a video to help explain how IM Support uses Knowledge-Centered Support (KCS) and some of the benefits: http://ow.ly/3yKEO David Kay, one of the leading voices in KM and KCS, just posted a "pat on the back" for the video in his blog: Communicating KM to Customers: IBM does it right We're still maturing as an organization using KCS, but hopefully you've seen... [More]
New Video - How IBM uses Knowledge-Centered Support (KCS) In Information Management Technical Support, we've invested a lot of time, training, and effort improving our Knowledge Base by implementing Knowledge-Centered Support (KCS). I'm excited that a new video has been posted which helps explain the KCS process in IBM: Together, we are making support better!
developerWorks Works! And Wins! developerWorks has been recognized by Forrester in the Busi ness -To- Busi ness (B2B) - " Supporting" category as an outstanding example among nearly 130 entrants... as the best use of B2B support. Having a user community skilled on IBM products and open standards
technologies who can quickly and easily find answers to their questions
using social media oriented search tools is critical to IBM success.
developerWorks supports IT professionals to become skilled on critical
technologies so... [More]
We have recently seen a couple of cases where user's were unable to run any db2 commands on Microsoft Windows operating system. They either got : "SQL1042C An unexpected system error occurred. SQLSTATE=58004" error in db2 or "DB21018E A system error occurred. The command line processor could not continue processing." error in application. First place to check for more information on the error we get is db2diag.log. In db2diag.log, we see an error as follows : 2017-10-02-22.214.171.1242003+420 E628778F498 LEVEL: Error... [More]
Firstly verify the table space is regular table space and it has reached its limit 512GB. You can check this by running “db2pd -tab -db <yourdb>” or connecting to database then run db2 list tablespaces show detail. Once it is confirmed that the table space size limit has been reached(512GB), convert the table space to large. Converting a regular DB2 DMS tablespace to LARGE http://www.ibm.com/support/docview.wss?uid=swg21408954 In addition, check the following notes. 1) Converting the tablepace from regular to large will... [More]
When you issued "db2fodc -hang", it might just finish without any data collection. In this execution, if you find out -1879048166 error in db2diag.log, it's worth checking the nofile(AIX) or open files(Linux) in "ulimit -Hn" output. These values should be larger than MAXFILOP database configuration parameter. For detail, please check the following link. https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.qb.server.doc/doc/r0052441.html Let me show an example for this issue. 1.... [More]
Problem : When executing db2ckupgrade on DB2 10.5 or above, you might get a warning - DBT5534W, reporting a dependency/reference to a discontinued routine in current version : DBT5534W The db2ckupgrade command found a database object which has a dependency on system built-in routines that are discontinued. Object name: "". Object type: "". Discontinued routine upon which the object depends: "". For example : DBT5534W The db2ckupgrade command found a database object which has... [More]
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]
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]