If you have a .NET application utilizing DB2 drivers on Windows 64-bit that is crashing in the following stack (in MS dumps), what would you do to fix the problem?
44 Id: 1350.b98 Suspend: 1 Teb: 000007ff`ffeb0000 Unfrozen
Child-SP RetAddr : Args to Child
: Call Site
00000000`0a31acc8 000007fe`fd3a10dc : 00000000`00000000
00000000`07eb3eab 00000000`00000000 00000000`00000000 :
00000000`0a31acd0 00000000`07d457bd : 00000000`00000000... [More]
As you have likely noticed, our IM Support team has been hard at work publishing technical tips since the IBM Centennial Celebration on June 16 2011. We're going to bring you 100 tips before June 16, 2012 as our little way of saying "Happy 100th, IBM!"
In this post, you can find links to all of our technical tips broken down by product/interest area. We hope that you find these tips useful and will keep watching for more in 2012!
#7: DB2 License key #8: DB2 on LUW Problem Determination Guides #10: Common DB2 Security Issues... [More]
Only the named callers can see PMRs for their company; basic callers can only see PMRs they have opened. Nobody else can see their PMRs and they cannot see anything else. If you are the named caller, to find all of your Service Requests (PMRs) for your company, please follow these steps: 1. Log into SR - http://www.ibm.com/support/servicerequest 2. Select the "Search service requests" link from the left nav menu. 3. Choose the radio button for "Search all service requests", (select customer number if applicable). ... [More]
Do you have an IBM ID? If your answer is no, you will want to register for one today because you will now need to log-in to Fix Central using your IBM ID to download fixes. It only takes a few minutes to register for an IBM ID by clicking here . Not only will registering give you access to fixes on Fix Central, your IBM Registration ID is your single point of access to IBM web
applications that use IBM Registration. The benefits of having an IBM Registration ID will
increase over time as more and more IBM applications migrate to IBM... [More]
you have questions about InfoSphere
DataStage? Do you need help with a trace or connection issues? I am happy to share with you new resources to answer some of those questions! Let IBM
Education Assistant modules help. Let's begin troubleshooting InfoSphere
The following IBM
Education Assistant modules will help you troubleshoot IBM InfoSphere
DataStage issues for versions 7.5, 8.0.1, and 8.1. If you want to... Check out this module Learn about ODBC tracing for
troubleshooting IBM InfoSphere DataStage ODBC... [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 2 weeks or 4... [More]
Does DB2 Replication center GUI tool use db2dsdriver.cfg file? The answer is No. db2dsdriver.cfg does not work with Replication Center, it uses command line catalog entries, you would need to catalog the node/db manually to be able to work with Replication Center. Here is a quick demo: C:\Program Files\IBM\SQLLIB_01\BIN>db2level DB21085I This instance or install (instance name, where applicable: "DB2_01") uses "64" bits and DB2 code release "SQL10013" with level identifier... [More]
NEW - Download Fix Central fix pack images using FTP Fix Central now supports downloading fix pack images using anonymous FTP. Use your browser, favorite FTP client, ftp command, or even the wget command. A significant number of users have asked for this functionality, so we're glad to make it available and hope that it helps you! The following document is a step by step demonstration how to use the bulk FTP download service in Fix Central to download a fix pack: How to download Fix Central fix packs images using... [More]
If you have a typo when you run the preprpnode command, and would like to reverse the changes that the preprpnode command made, you can either remove (read NOTE below) or rename the following files: /var/ct/cfg/ctrmc.acls /var/ct/cfg/ct_has.thl NOTE: We do not recommend removing/deleting the above files as there are other applications that use RSCT's security infrastructure. If you are not 100% sure about which applications are using CTRMC then you should rename the file to something that makes sense to you just in case you need to restore it... [More]
Looking for some ideas to troubleshoot problems with DB2 on LUW? Check out our available self-help problem determination guides. Each guide has 4 different sections to help you troubleshoot the issue: Learning more Troubleshooting Collecting Data Analyzing the data DB2 LUW Crash: http://www.ibm.com/support/docview.wss?uid=swg21426669 DB2 Security Model on Windows http://www.ibm.com/support/docview.wss?uid=swg21423923 DB2 Unable to start DAS issue SQL4401C http://www.ibm.com/support/docview.wss?uid=swg21441648
Problem(Abstract) Initializing InstallShield Wizard........ Launching InstallShield Wizard........ The wizard cannot continue because of the following error: could not load wizard specified in /wizard.inf (104) Cause Install can't locate java path Resolving the problem ./ids_install -javahome your_JRE_path This forces the installation script to use the bundled IBM Java Runtime Environment.
DB2 LUW provides two ways of
determining if you are using the product according to the licenses
you have installed. One is the dblicm tool the other is the
ENV_FEATURE_INFO administrative view. The db2licm -l command lists
the product and feature licenses installed for each DB2 product at
the same build level as the instance the command was run under. For
example the following is db2licm -l output from a DB2 version 9.7 ESE
name: "DB2 Enterprise Server Edition"... [More]
If you need regular database backup during night or weekends, use DB2 automatic maintenance feature. Here is DB2 V9.7 Information Center URL: http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=%2Fcom.ibm.db2.luw.admin.ha.doc%2Fdoc%2Ft0051357.html 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. 2) Execution: Do the task Once... [More]
One way to find record length in a specific table in a specific schema is to run following query, $ db2 "select tabname, sum(length) from syscat.columns where tabschema='<schema>' and tabname='<table-name>' group by tabname" Example with a DB2 LUW sample database table : $ db2 describe table db2inst1.org... [More]
Hello All, We have put together the following two tech doc's on frequently asked DB2 questions: DB2 FAQ: Frequently Asked Questions about Application Development with DB2 LUW https://www-304.ibm.com/support/docview.wss?uid=swg21497134 DB2 FAQ - Frequently Asked Questions about DB2 LUW https://www-304.ibm.com/support/docview.wss?uid=swg21298716 Have a DB2 question you would like added to one of the above tech docs, then please comment below.