Part of the IBM Analytics family, focused on Analytic Platform product support. This blog is administered by Andrew McCarl (amccarl) and Kate Nichols (KateDawson), and follows the IBM Social Computing Guidelines.
Today, we're pleased to share a new blog series running in the IBM PureData-Enzee Community. The series will cover 50 Nuggets of Wisdom from our experts in the PureData for Analytics support team!
You can see the blogs in the series by regularly visiting the Community and following the nuggets tag .
The first blog in the series covers step-by-step instructions to Collect a Health Check Report from your system. Find the blog by clicking the link above.
Looking forward to reading... [More]
One scenario you may have !!
You attend a monthly DB operation meeting.
Each DB administrator team from Oracle, DB2 and Sybase presents monthly events and various monitoring results.
On first turn, an Oracle guy indicates a performance issue on a specific day and says an SQL has triggered the issue.
And.......he shows the historical performance data for the SQL by keeping on track of the change day by day.
Actually the hash key value ' SQL_ID ' of Oracle enables this kind of analysis.
When performing a DB2 fixpack upgrade (rolling upgrade), for example from DB2 V9.7 FP8 to DB2 V9.7 FP9, in an HADR environment where HADR_SYNCMODE is set to SUPERASYNC as shown below :
HADR database role = PRIMARY
HADR local host... [More]
I-Spy returns an authentication error 951 when a user opens a database.
$ dbaccess sysmaster -
746: I-Spy: SQLERR -951 connecting to shadow server
These are some possible solutions for the 951 error:
Set INFORMIXSERVER to the shadowserver (database server name) in order to bypass I-Spy. If you are still seeing the 951 error, search other documents specific to the Informix server that addresses the 951 error.
Check if the... [More]
I am happy because I am going to get one more second to work on my PMRs! How? Leap Second!
So what is a leap second?
This is a definition from Wikipedia :
A leap second is a one-second adjustment that is occasionally applied to Coordinated Universal Time (UTC) in order to keep its time of day close to the mean solar time. Without such a correction, time reckoned by Earth's rotation drifts away from atomic time because of irregularities in the Earth's rate of rotation. Since this system of... [More]
Information Management Bootcamps are technical workshops in a classroom setting. They are held throughout the year in different regions worldwide. These bootcamps contain detailed lectures and labs for deep-dive learning of the concerned product:
Some of InfoSphere Informatiion Server specific bootcamps are listed also below :
InfoSphere Information Server Bootcamp
This technical workshop is for IBM Business Partners. It provides training on IBM InfoSphere Information Server, IBM InfoSphere Foundation Tools,... [More]
InfoSphere Information Server Pack for SAP Applications helps optimize time-to-value & lower total cost of ownership by automating integration efforts for SAP applications. IBM InfoSphere Information Server Pack for SAP BW helps enhance the openness of SAP NetWeaver Business Intelligence (BI) by rapidly integrating non-SAP data into SAP BW
Please find few links that are related to InfoSphere Information Server and SAP integration topics:
Installing IBM InfoSphere Information Server Pack for SAP Applications 7.1
I am sharing one small script to monitor the changes in HADR state. If you know better way to monitor it, please share it in comments section. Thank you!
# Monitor the change in HADR state
# How it works?
# This is a cron job that needs to be set at OS level as DB2 instance user.
# It needs to be run for every 10 minutes... [More]
We often deal with PMRs on "SQL0805N Package not found" error and get questions about DB2 Packages from customers.
We do have lot of technotes and white papers on DB2 packages. I just wanted to consolidate all the information and give you a quick overview of DB2 CLI packages and help you to solve SQL0805N errors.
Packages : Packages in DB2 are control-structure database objects that contain executable forms of SQL statements or placement holders for executable forms or access plans.
Section: A dynamic section... [More]
There are 6 new InfoSphere Information Server IEA modules in production and 2 existing InfoSphere Information Server IEA modules have been revised and deployed to production.
Configuring LDAP with Information Server 11.3 with WebSphere Liberty - This presentation discusses how to configure Information Server version 11.3 for LDAP authentication with WebSphereLiberty.
Have you ever wondered why during a DB2 fixpack upgrade on a DPF environment, db2iupdt fails with DBI1167E "DPF instance cannot be updated from non instance owning nodes."?
Beginning in DB2 V9.5, fixpack upgrade was enhanced on Unix and Linux platforms to only run db2iupdt on instance owning node. Prior to DB2 V9.5, db2iupdat didn't do a hostname check. This was first introduced in DB2 V9.5. This check was done to ensure that the instance update only happens on the node defined on the first line of db2nodes.cfg for DPF... [More]
In DB2 JDBC applications, when you execute INSERT or MERGE statements that use parameter markers in a batch, if the data server supports multi-row INSERT, the IBM Data Server Driver for JDBC and SQLJ can transform the batch INSERT or MERGE operations into multi-row INSERT statements by default.
If INSERT FROM SELECT statements are executed in a batch, the driver will throw a BatchUpdateException , by default and its a restriction.
To avoid the exception, JCC datasource property enableMultiRowInsertSupport must be set to false .
When you alter a table to drop a column, the table must be reorganized before an update, insert, or delete operation or an index scan can be performed on the table. After the column is successfully dropped, the table is placed in a reorg pending state. When you attempt to execute the REORG with INPLACE option, DB2 will through SQL2216N SQL error "-668". The error means :
SQL2216N SQL error "-668" occurred while reorganizing a database table or its indexes.
If a table is in a reorg... [More]
The following explains the "Truncated" state of a reorg and why applications might have a LOCK WAIT on reorg :
Online reorg holds an S lock on the table during the process of table truncation. While online reorg holds an S lock on the table, no insert/update/delete activity can occur on the table. During the online reorg process rows are moved to pages closest to the start of the table. While this is going on, rows inserted into the table may end up close to the end of the table and online reorg may not see these rows... [More]
Often DBAs asks us to how to find when the routine was run last time? This helps them in finding all the unused SPs, functions and take necessary action on them. Most of the routines create packages. It is easy to find last execution time of the routine by joining three catalog views:
You can use the below query:
db2 select rt.routineName as RoutineName, pkg.lastused LastUsed from syscat.routines rt,... [More]