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.
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]
PureData System for Analytics (PDA), Netezza Platform Software (NPS) will be ending patch support for the maintenance releases v7.0.2 and v7.0.4 on December 31, 2015. This means that no more fixpacks or patches will be created for 7.0.2 or 7.0.4 after December 31, 2015.
The last regularly scheduled quarterly Fixpack (22.214.171.124 & 126.96.36.199) will be posted to Fix Central on or before June 30, 2015 Additional patches or fixpacks will be created on an as needed basis for the... [More]
Do you see different results for same query from Websphere Application, even though the underlying data is not changed?
Consider a table with column of datatype decimal(5,2). If you are inserting "0.18999999999999995" into this table multiple times from Websphere applications using JCC drivers, you will see the results as follows:
0.19 < First Run
0.18 < Second Run
0.18 <... [More]
We are pleased to share a new way for you to get quick, effective product technical support assistance from IBM. Check it out by downloading it from Google Play ! An iOS version will be available soon.
You can use the app to:
Expedite troubleshooting by searching for, viewing, and bookmarking technical support content like documentation, APARs, technical articles, and Redbooks
View and update your software and hardware Service Request tickets whenever and wherever you need to
Discover the... [More]
The Advanced features of IBM Call Home Web beta IBM Education Assistant module went to production on 1/9/2015. It is a quick, 3 minute video that explains some additional features of Call Home Web including filtering and exporting data.