Blogging to benefit Information Management Support customers worldwide. This blog is administered by Andrew McCarl (amccarl) and Kate Dawson Nichols (KateDawson), and follows the IBM Social Computing Guidelines.
Continuous availibility is the concept that enables 24/7 access to IT-enabled business functions, processes and applications.
And minimizing planned downtime is what business and IT departments consider seriously nowadays.
Especially, minimizing and setting the appropriate downtime is a bit challenging decision in case of DB2 version upgrade or migration to another system, because we also need to consider the time for getting back to original system in preparation for any unexpected problem after the planned change... [More]
When trying to convert your database to BLU. You may see that some tables fail. This can be seen like this.
In the progress of the convert utility. The below will be seen.
Table RowsNum RowsComm Status Progress (%)
--------------------------------------- --------------- --------------- --------------- ---------------
"TANJINXU"."ACT" 18 0 COPY Failed
This is caused by the utility heap size. The convert utility utilizes the admin move table function. If the utility heap size is not... [More]
I would like to share with our readers the license issue that one of our customers ran into.
Its straightforward and I'm sure you have seen this license problem before and know to resolve it but I would like to show the symptoms, what options we had, which one did we choose to fix the license error .
The product installed was DB2 10.1 Enterprise Server Edition (ESE) as seen here below:
Product name: "DB2... [More]
For most of us, we refer the word ' ARCHIVE ' in DB2 to DB2 Transactional Logs archiving.
There are other items that you can archive as well. Let's explore what all we can archive:
1. DB2 Transactional Logs - This refers to DB2 transactional log archiving. I assume you are familiar with this concept. Hence I won't discuss it in detail here. If you have any question, please feel free to ask us. You can add a comment to this article at the bottom.
2. DB2 Diagnostic Logs Archiving -... [More]
I am quite sure that most of you are using 'svmon' utility with various option to monitor the memory utilisation on AIX box. The most useful option I found is 'P'. It quickly shows you the approximate memory consumption at process level:
$ svmon -G
size inuse free pin ... [More]
100 Tech Tips: #86 What information is in the name of the db2fmp
The db2fmp or DB2 Fenced Mode Process
is used to run untrusted external routines. These routines can be
created in a variety of languages and can be thread-safe (meaning it
is safe to run them in a multi-threaded db2fmp process with other
unrelated routines), or not thread-safe (meaning they will be run in
a single db2fmp process). The name of the db2fmp in the ps output
can be used to determine the language and thread-safeness of the
db2fmp. The name also indicates... [More]
Today we are very excited to announce two new ways to get Support information specifically for DB2! A crack team of DB2 experts around the world will be sharing their expertise through Twitter and Facebook. Follow us: DB2_Support on Twitter Like us: IBM DB2 Support on Facebook These channels will cover DB2 Tools... JDBC CLI Security Stored Procedures ... and DB2 Engines Memory HADR Internal Architecture DB2 Blog posts will continue to be posted here on our Thoughts from Information Management Support blog. Follow DB2 Support on Twitter... [More]
STAR ME UP! Over the weekend, a pilot "Star Rating" program was deployed for several IBM products across the portfolio, including technical support documents for Informix Servers and DB2 for Linux, Unix, and Windows. In the future, you will be able to see these ratings in the IBM Support Portal. This rating system is in addition to our current feedback mechanism, so please continue to let us know if our support documents help you achieve your goal and how we can improve them. Star me up! I'll take you places that you've never, never... [More]
The pureScale client affinity feature allows client specification of a single primary server and failover
sequence to alternate servers and all rerouting is controlled by the client driver.
That means all you have to do is basically configuring the right DB2 JCC JDBC properties in your WAS(Web Application Server) side.
However the reality is many people has difficulty about how to have right setting about pureScale client affinity during configuration and failover test.
For having right configuration for them, some people take over... [More]
Inoperative DB2 Package:
Packages in DB2, can be dependent on certain types of database objects such as tables, views, aliases, indexes, triggers, referential constraints and table check constraints. If a package is dependent on a database object (such as a table, view, trigger, and so on), and that object is dropped, the package is placed into an invalid state. If the object that is dropped is an UDF, the package is placed into an inoperative state.
For an inoperative package, in the SYSCAT.PACKAGES system catalog view, the VALID... [More]
When installing DB2 Universal Database for Linux, Unix, and Windows version 10.5, the installation script no longer lists the "ESE" (Enterprise Server Edition) and "AESE" (Advanced Enterprise Server Edition) options as it did with earlier versions. They have both been replaced with the option of "SERVER". The other options have remained the same.
The reason for this is that whether you have "ESE" or "AESE" depends solely on the license you install (EG the actual libraries that are... [More]
One of our clients has a JCC application going through a DB2 Connect gateway connecting to DB2/Z database, instead of direct connection to DB2/Z. They wanted to know how to setup the automatic client re-route(ACR) if the DB2 Connect goes down.
Here are the steps:
In the case of the DB2 Connect server, because there is no requirement for the synchronization of local databases, you only need to ensure that both the original and alternate DB2 Connect servers have the target IBM mainframe database cataloged in... [More]
From DB2 V9.7 Batched INSERT statements can return automatically generated keys.
If batch execution of a PreparedStatement object returns automatically generated keys, you can call the DB2PreparedStatement.getDBGeneratedKeys
method to retrieve an array of ResultSet objects that contains the automatically generated keys.
Recently I had a customer trying to use getDBGeneratedKeys method with Batch inserts in a JDBC application using JCC driver and was looking for an example.
Here is an example of how to use the... [More]
If you need regular database backup during night or weekends, use DB2 automatic maintenance feature.
Here is DB2 V9.7 Information Center URL:
1) How automatic maintenance job run?
The automatic maintenance feature has two phases. 1) Evaluation and 2) Execution.
1) Evaluation: Check whether we do task. Evaluation activity starts in every 2 hours since database is activated.... [More]
Using a simple test case. This can be easily observed. Document was exported using a utility that applies a byte order mark to text documents.
db2 "create table numbers (col1 char(10),col2 char(10),col3 char(10))"
DB20000I The SQL command completed successfully.
[db2v97@ts-carose2 ~]$ db2 import from numbers.csv of del insert into numbers
SQL3109N The utility is beginning to load data from file "numbers.csv".
SQL3110N The utility has... [More]