In this demo, I have considered the following to demonstrate  DB2 connectivity using type 2 Universal JDBC type 2 driver with 32-bit and 64 application:   - Downloaded IBM 32-bit JDK for Windows from the web:  http://www.ibm.com/developerworks/java/jdk/ - Installed DB2 V9.7 FP5 64-bit Client on Windows 7 - DB2 V10.1 FP4 database server on Linux.   Used the following sample code: import java.sql.Connection;  import java.sql.DriverManager;  import java.sql.*;  import java.sql.SQLException;    public... [More]

Tags:  jdbc db2;db2_advice type2

Hello, To troubleshoot an issue with complex CLI application, DB2 CLI script with similar functionality can be used. In many cases, customers usually have a complex CLI application that run into issues. To simplify the issue and to quickly gather diagnostics, we often ask customers to try with a simple DB2 CLI script. Here are some Windows based examples: 1. To test the CLI connectivity to the remote database from the DB2 Client where the application... [More]

Tags:  cli db2_techtip db2cli

1. The below command will help us identify which application is consuming the maximum LOG space: db2 "SELECT SUBSTR(AI.PRIMARY_AUTH_ID,1,10) AS AUTHID, SUBSTR(AI.APPL_NAME,1,10) AS APPLNAME, SUBSTR(AI.APPL_STATUS,1,10) AS STATUS, INT(A.UOW_LOG_SPACE_USED) AS LOG_SPACE, A.UOW_START_TIME FROM SYSIBMADM.SNAPAPPL A, SYSIBMADM.SNAPAPPL_INFO AI WHERE A.AGENT_ID = AI.AGENT_ID AND A.UOW_LOG_SPACE_USED > 0 ORDER BY A.UOW_LOG_SPACE_USED DESC" Example: AUTHID     APPLNAME     STATUS      LOG_SPACE... [More]

Tags:  spacereserved db2_techtip log_space

  We have many customers wondering how to fine tune their dynamic SQL queries . The following snapshots can be run based on a particular environment: Single partition: db2 get snapshot for dynamic sql on <dbname> DPF: db2 get snapshot for dynamic sql on <dbname> global Example: Number of executions               = 2  Number of compilations             = 0  Worst preparation time... [More]

Tags:  db2_techtip perf long_running_query dynamic_sql

  Want to improve your experience when contacting IBM Support? Would you like to know how to enhance your IBM Support with additional services that suit your needs? Check out IBM Software Support Handbook and its companion the IBM Appliance Support Handbook. Software Support Handbook. http://www14.software.ibm.com/webapp/set2/sas/f/handbook/home.html Appliance Support Handbook. http://www-304.ibm.com/support/customercare/sas/f/applhandbook/home.html  

Tags:  handbooks support

For every problem, collecting data can aid in problem determination and save time resolving Problem Management Records (PMRs). Collecting this data before calling IBM support will help you understand the problem and save time analyzing the data. Collecting data before opening a PMR helps IBM Support determine if: symptoms match known problems (rediscovery). there is a non-defect problem that can be identified and resolved. there is a defect that identifies with an immediately available fix. there is a defect that identifies a workaround to... [More]

We have seen many customers having problems with the db2iupgrade command. Some are very common and can be resolved in seconds. To save your time, here is the most common problem while upgrading and some tried and tested solutions to overcome it.  Problem Description : When you try to upgrade a db2 database using db2iupgrade command sometimes it may fail with following error message : DBI1264E Errors were encountered in running db2iupgrade. Please refer to the installation log file /tmp/db2iupgrade.log.xxxxxxx In the db2iupgrade.log file it... [More]

Tags:  dbi1250e upgrade_db2 db2iupgrade dbi1264e db2_techtip

Linux is an operating system that becomes very popular over the last several years. The growing popularity of Linux influenced business to port their Informix databases on this platform. If you are a Linux user, is your Linux system optimally configured for Informix? In this presentation you will see what needs to consider to run Informix optimally on Linux platform. Please find attached a presentation that provides guidelines for how to install and manage Informix on Linux platform. The Presentation is broken down in to... [More]

Insight 2014 is only 37 days away. While the Smarter Support team gets ready for the event of the year, we connected with the Smarter Support leadership team to get their take on the event and what Smarter Support is all about. The Smarter Support leadership team includes: Al Martin (AM) , Vice President, Information Management Worldwide Client Support Andrew Lee (AL) , Vice President, Business Analytics Customer Support & Success David Churchill (DC) , Director, Global Enterprise Content Management Client Support John Dewey (JD) ,... [More]

Tags:  ibminsight smartersupport

You're invited to our September Support Technical Exchange!   Topic: IBM PureData for Analytics (Netezza) Connectivity for Information Server DataStage Speaker: Scott Brokaw, Information Server Support Engineer, Team Lead Date: Tuesday, September 30, 2014 Time: 11:00am - 12:00pm EDT Description: Extend data integration and governance in IBM PureData for Analytics by fully leveraging InfoSphere Information Server. This presentation will provide a connectivity and quick start guide for Netezza Connectivity within Information Server... [More]

Tags:  netezza puredata datastage

We are very happy to announce that we have completed 50 DB2 Nuggets goal - 50 exclusive DB2 Blogs in Information Management support for 2014! Readers - thank you for your interest. We hope that you find our information relevant and helpful. Authors - thank you for your dedication, effort, expertise and help in promoting client self-assist. Here are the names of the authors who have contributed towards the goal. Adam Koile - USA Christopher Rose - USA Gord Owens - Canada John Gera - USA Jun Su Lee - Australia Mary Kassey - USA Matthew Choi -... [More]

Tags:  50_db2_nuggets db2_resourceinfo

Hello, Recently I worked on another interesting case where an ODBC/CLI application using SUBSTRING(..., CODEUNITS32) and LOCATE(..., CODEUNITS32) functions in case when first argument is a parameter and the function is used in WHERE or HAVING clause expression resulted in error: [IBM][CLI Driver][DB2/NT] SQL0245N The invocation of routine "SUBSTRING" is ambiguous. The argument in position "1" does not have a best fit. SQLSTATE=428F5. This error is returned when an invocation of a function is ambiguous. This occurs when there... [More]

Tags:  cli error sql0245n 50_db2_nuggets

In a DB2 HA environment using TSAMP,  here is what goes on in the background when certain DB2 commands are run. db2start/db2stop: Running db2stop will lock the Instance resource group where the stop is issued against. Consequently the HADR Database will fall out of peer state and the DB2 engine will request that the HADR resource group gets locked, preventing the resources from being restarted automatically by TSA. Running db2start will unlock the instance resrouce group, once the DB automatically reintegrates, the lock will be removed... [More]

Tags:  tsamp db2_tsamp_interaction db2_advice 50_db2_nuggets interaction db2

Hi, Ever wondered what the TSAMP control flags stand for in a DB2 HA environment? Here are some of the most common ones: " StartInhibited " - Start of dependent resource is not satisfactory (only displayed if OpState is Offline and DesiredState is Online) " StopInhibited " - Stop of dependent resource is not satisfactory  (only displayed if OpState is Online and DesiredState is Offline) " SuspendedPropagated " - A lock request is propagated to this resource " StartInhibitedBecauseSuspended " - Start... [More]

Tags:  50_db2_nuggets db2_advice db2 ha control tsamp flags