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.
Connections being rejected on a V9.8 pureScale environment
Any connections being made to the database that is on a v9.8 pureScale instance is experiencing a connection hang and instance may experience a 'hang' like situation.
If we take a few iteration of stacks (db2pd -stacks all -rep 10 5), and the stack analysis may have the following output:
0x0900000000533990 _p_nsleep + 0x10
0x0900000000038BE4 nsleep + 0xE4
0x090000000015B290 nanosleep + 0x190
Please join us for our upcoming Support Technical Exchange!
Our speaker, Scott Brokaw, will guide us through Configuring SSL/HTTPS in InfoSphere Information Server versions 8.5 - 11.3.
Date: Tuesday April 21, 2015
Time: 11:00 am ET
This presentation will discuss how to leverage and configure SSL (Secure Sockets Layer) authentication. SSL authentication is configurable at version 8.5 and later. Beginning at version... [More]
Getting SQL10004C An I/O error occurred while accessing the database directory?
The reason for SQL10004C may vary. Possible reasons are:
- sqldbdir being corrupted
- incorrect permission or access issues to the sqldbdir file under database directory
Another possible cause is that the system may have been maxed out of available file handles. If you scan the /var/log/messages , you may see an error during the same time frame you got SQL10004C error.
kernel: VFS: file-max limit ###... [More]
Recently we are seeing lot of cases where applications using IBM DB2 JDBC drivers(db2jcc.jar/db2jcc4.jar)) start failing with SqlCode = -4700 after DB2/zOS server upgrade to V11 CM (Compatibility mode).
I wanted to clarify about the error and explain the background.
-4700 is a sqlcode returned by the DB2/Z server.
It means: "ATTEMPT TO USE NEW FUNCTION BEFORE NEW FUNCTION MODE"
The error is returned when the application queries the special register CLIENT_CORR_TOKEN . This special register is not available... [More]
We have just announced the new IBM InfoSphere Data Replication v 11.3.3 (IIDR).
InfoSphere® Data Replication V11.3.3 offers an easy-to-use, highly scalable, low-impact, and enterprise-ready data replication platform. This release includes the following:
InfoSphere Data Replication V11.3.3 (for IBM® i, Linux™, UNIX™, and Windows™)
InfoSphere Change Data Delivery V11.3.3
InfoSphere Data Replication for Apache Hadoop V11.3.3
InfoSphere Data Replication V11.3.3 is a... [More]
DB2 instance is up and running fine, but when issuing 'db2ilist' no output is being returned, what needs to be done?
Step 1: Dump out the registry and validate if you have the instance listed or not
db2greg -dump | grep <instance name>
Step 2: As an instance owner issue db2set and validate if you have the instance name outputted
Step 3: Once you validate the instance entry is in 'db2greg' output and not in 'db2set' ouput, as root, go to... [More]
Getting SQL0444N with Reason code: "6" ?
For example, when you do a query like: db2 "select count(*) from SYSIBMADM.DB_HISTORY"
You can get the following error.
SQL0444N Routine "*IST_HIST" (specific name "ADMIN_LIST_HIST") is implemented
with code in library or path "...e/db2adminListHist", function
"adminListHistTrusted" which cannot be accessed. Reason code: "6".
Recently came across this question about dropping members that reside in the same physical server.
Consider the db2instance -list output like this.
ID TYPE STATE HOME_HOST CURRENT_HOST ALERT PARTITION_NUMBER LOGICAL_PORT ETNAME
-- ---- ----- --------- ------------ ----- ---------------- ------------ ------
0 MEMBER STARTED host1 host1 NO 0 1 host1-en1.xxxx.com
1 MEMBER STARTED host1 host1 NO 0 0 host1-en1.xxxx.com
2 MEMBER STARTED host2 host2 NO 0 0 host2-en1.xxxx.com
During crash recovery, if many load operations have to be replayed, then it might take a long time to complete. The load operation will keep the pending operations in transaction logs no matter if it is recoverable load or non-recoverable. These pending operations will be kept in transaction log just before the table status is changed back from "load in progress" state to "normal" state. If the crash recovery starting point - min(lowtranlsn, minbufflsn) is before load pending operations then db2 will have to replay... [More]
As we shared at the beginning of March , the PureData for Analytics Support Team has started sharing support nuggets of wisdom in the IBM PureData Enzee Community.
Here are the first tips direct from the experts:
Collecting a Health Check Report , by Shelly Faith
Upgrade Tip - HPF 5.4 and Releases , by Dennis Clark
Finding CBTs , by Sanjit Chakraborty
Optimizing CBTs , by David Birmingham
As guardians of data we are constantly faced with the challenge of moving data from one platform to another for a multitude of reasons.
We faced such challenge at one of my favorite client location where most databases were being migrated to reside on private cloud environment.
A standard procedure in order migrate a few hundred database instance into a Linux cloud farm was built.
We are pleased to share a new video available on the IBM Electronic Support YouTube Channel: Keeping Service Requests to a Single Issue
Did you know that when you limit a Service Request to a single issue, IBM Support is better able to prioritize and update you on the issue's status? If you have more than one issue, you are welcome to open multiple requests (even for topics related to a single larger issue, such as an upgrade).
By signing in to Service Request, you will be able to see all of your... [More]
When using DB2 HADR the local service/port (HADR_LOCAL_SVC) and remote service/port (HADR_REMOTE_SVC) are defined. But, why netstat output shows that hadr is using other port numbers too ?
Both HADR_LOCAL_SVC and HADR_REMOTE_SVC are used as the lower level TCP server listener port numbers only. The client side of the TCP uses free ports available from OS from that side.
HADR uses TCP server and TCP client at the lower level. In this context, one HADR db side listens on its hadr_local_svc port as TCP... [More]
NullPointerException was thrown when one of our customers tried to load latest DB2 JCC driver (db2jcc.jar - V10.1 and above) using a custom class loader ( like open source module NestedJarClassLoader). The same worked while loading old DB2 V8.2 db2jcc.jar driver (2.11.24).
Here is the error stack:
Caused by: java.lang.NullPointerException
As of now, DB2 on Windows supports ActivestatePerl (both 32bit and 64 bit) and Strawberry Perl (32 bit ONLY).
To get the 32 bit DBD::DB2 binaries supported with 32 bit Strawberry Perl, you must email email@example.com or contact IBM support for the required binaries.
64 bit Strawberry Perl is not supported yet.