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.
Run steps as instance owner : db2cluster -cfs -list -tiebreaker db2cluster -cm -list -tiebreaker Make sure the CFS and CM level tibreakers are type disk. Stop all the applications and deactive the databases. db2stop db2stop instance on <member-host> [repeat for all member hosts] db2stop instance on <cf-host> [repeat for all CF hosts] Run steps as cluster service admin (root) : db2cluster -cm -enter -maintenance -all db2cluster -cfs -enter -maintenance -all db2cluster -cfs -set -tiebreaker... [More]
Hi everyone, Our next Support Technical Exchange will take place on July 21 covering the topic: Performance Tuning with Information Server DataStage Parallel Jobs. We hope you will join us for this FREE education session. Abstract: During this Support Technical Exchange, you will learn how to improve performance tuning with DataStage parallel jobs. We will review best practices for developing parallel jobs and then discuss resources that will help with performance tuning, including how to read the APT_DUMP_SCORE report, using NMON to... [More]
There are many customers who have migrated applications from Oracle to DB2. So the expectations are to match or compare the behavior at many places. This blog explains one of the different behaviors which affect such wide range of users. DB2 throws an error SQL20496N if there is an attempt made to re-create package without re-creating its package body. In Oracle user don't have to worry about re-creating the package body. Unfortunately, this is the current DB2 limitation and re-creating Package Specification does drop the Package... [More]
The 4499 error message for the IBM Data Server for JDBC and SQLJ (JCC) driver is returned in 3 cases and is always a fatal error (the error cannot be recovered from without re-trying the failing operation). The most common case occurs when there has been a network or TCP/IP error. In this case the message description of the TCP/IP error will return. For example if the issue was a connection reset, the message would be “Connection reset by peer”. If the TCP/IP listener was not available on the target... [More]
Users can use the DB2 Trace Facility (db2trc) in DB2 BLU ( BLU aka CDE - Columnar Data Engine) environment to collect the critical performance diagnostics information using new component, CDE_PERF_TRACE. To collect performance diagnostics, one should run: db2trc on –m CDE_PERF_TRACE
... run workload ...
db2trc dmp perftrc.dmp
db2trc fmt perftrc.dmp perftrc.fmt
There were reports on "db2trc on –m CDE_PERF_TRACE" not working due to some yet unidentified environment problem.... [More]
A quick demo showing Driver Manager Connection to DB2 on windows, retrieving resultset using getString JDBC API from a table that has empty, valid data and NULL values. Environment: DB2 10.5 FP3 on Windows JCC driver: 3.67.27 db2 "create table t100 (col1 char(10))" db2 "insert into t100 values('','mary','NULL')" C:\Program Files\IBM\SQLLIB\java\jdk\bin>db2 "select * from t100" COL1 ---------- mary NULL 3 record(s) selected. import java.sql.Connection;... [More]
A CLI based application can get Idle Thread timeout error if that application takes time to process the huge amount of data returned by a select query. Until a COMMIT or ROLLBACK is being sent by the application after the query, the thread stays idle on the DB2/zOS server. When the thread stays idle while processing the result sets more than the IDLE THREAD TIMEOUT ( IDTHTOIN ) setting in DB2/zOS server, the timeout error is expected ( SQL1224N ) In order to prevent this issue, use commitOnEOF CLI Keyword. This... [More]
Problem: When trying to upgrade a V9.7 instance to V10.5 instance, upgrade fails with the following message: A minor error occurred during the execution. For more information see the DB2 installation log at "/tmp/db2iupgrade.log.30983". DBI1264E This program failed. Errors encountered during execution were written to the installation log file. Program name: db2iupgrade. Log file name: /tmp/db2iupgrade.log.30983. Checking /tmp/db2iupgrade.log.30983 , we... [More]
You are invited to join us for our next Support Technical Exchange session, covering the topic: Setting Up Basic DataStage Users . Date & Time: Tuesday June 16, 12:00pm - 1:00pm ET Abstract: During this Support Technical Exchange, you will learn how to set up basic DataStage users and understand a high level overview of the entire client server connection process. We will review each step of the process and what errors may be presented at each step. This will help you understand exactly where a connection may be failing... [More]
What do Kevin Spacey and Captain Phillips have in common? Among other things, IBM! See them and other highlights from the IBM Insight using InsightGO! InsightGO is an interactive digital platform, streaming live broadcasts straight to your laptop or mobile device. It's the next best thing to being in Vegas, but it doesn't stay in Vegas!
How to remove Duplicate Rows in a nonfragmented IBM Informix Dynamic Server (IDS) Table . Use the SQL in this article to remove duplicate rows from a nonfragmented table. Note: This method does not work on fragmented tables. Rowid's must exist on the table. STEPS Create and run this SQL to remove duplicate rows from a table: SELECT rowid FROM table_name WHERE rowid NOT IN ( SELECT MIN(rowid) FROM table_name GROUP BY column_name ) INTO TEMP temp_name; DELETE FROM table_name WHERE rowid = ( SELECT rowid FROM temp_name WHERE table_name.rowid =... [More]
After yesterday's blog announcing our May 14 Support Technical Exchange session , we're back with yet another opportunity for you to build your skills in May! Register for our May 21 Support Technical Exchange: Configuring the Complex Flat File Stage in InfoSphere Information Server Abstract: Access to data in mainframe files is on the rise and poses tricky challenges to extract this critical data. The Complex Flat File stage is a file stage designed to process complex EBCDIC and ASCII files and data... [More]
In an automated High Availability Disaster Recovery (HADR) environment, rolling upgrade procedure will not work when upgrading from an earlier to a later version of a DB2 database system. For example, you cannot use this procedure to upgrade from a DB2 Version 9.7 to Version 10.x. Use this procedure in an automated HADR environment when you upgrade your DB2 versions 10.1 and 10.5 from DB2 Version 9.7. The following steps must be completed: 1. From CLP, as the instance owner, stop HADR on both standby and primary servers by using db2 stop... [More]
Hello, Are you looking for sample response files to install DB2 using silent installation? A response file is a text file that contains setup and configuration values. The file is read by the DB2 Setup program and the installation is performed according to the values that have been specified. A response file installation is also referred to as a silent installation. 1) The sample response files are located in the DB2 Image downloaded: Under: ...<extracted... [More]