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.
My friends contact me to ask db2 issues. Most of them are known issues or not difficult (at least I think) enough to be resolved by themselves. The main reason is that they don't have enough information where the documents are. I'm writing a document for db2 troubleshooting before you are prompted to open DB2 ticket for defect. DIY and save time with the following URL addressing Frequently Asked Questions and known issue on OS. 1) If you use Linux or Oracle Solaris, check whether your OS is supported. - DB2 Support on CentOS... [More]
Are you considering ‘Admin move table’ for reorganization work of your tables ? And are you finding the way to reduce time of last ‘SWAP’ of admin move table work ? Nowadays, our database systems have so many number of tables and the tables are getting bigger. And as a database administrator, we are facing the reality that we need to do the time consuming work for maintaining huge tables and business departments usually do not permit enough time to work on those on weekends offline maintenance work time windows.... [More]
The IBM Internet of Things and Informix 2014 Spring / Summer Roadshows are coming to a city near you!! Registration is now open for two new FREE technical Roadshow events being held through North America. The first is for anyone interested in the next wave in data processing. Generally referred to as "The Internet of Things", it represents a massive change currently occurring throughout the IT landscape. Unstructured data is flooding into the enterprise and everyone is struggling with how to manage it. While NoSQL... [More]
The Heartbleed bug is a worldwide security vulnerability affecting services with SSL/TLS encryption using the OpenSSL library. IBM is analyzing its products to determine which ones are affected by this vulnerability. Affected IBM products will be issuing fixes as soon as possible. Please actively monitor both the IBM Support Portal available fixes and the IBM Product Security Incident Response Blog for additional information.
Hello! 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: /home/abc>db2licm -l Product name: "DB2 Enterprise Server Edition"... [More]
Hey there! Traditional BIND command is not part of the IBM Data Server Driver Package. You can use the DB2BINDER utility to bind packages from the IBM Data Server Driver Package. You can follow the below steps: Open the DOS command window. Change the directory to your IBM Data Server Driver Package's bnd directory. e.g. C:\Program Files\IBM\IBM DATA SERVER DRIVER\bnd Run the DB2Binder command from that directory. e.g. C:\Program Files\IBM\IBM DATA SERVER DRIVER\bnd>java com.ibm.db2.jcc.DB2Binder - url... [More]
To ensure you are ready for the Optim products reaching EOS in April, here is a summary. You can view the original EOS announcement here . Product Name Version Policy Type Product ID End Of Support Optim Solution for Application Retirement** 7.3.0 S 5724-U39 30-Apr-14 InfoSphere Optim Solution for Application Retirement** 7.3.1 S 5724-U39 30-Apr-14 InfoSphere Optim Solution for Application Retirement - Open Data Manager** 7.3.1 S 5725-C58 30-Apr-14 Optim Data Growth Solution** 7.3.X S 5724-U38 30-Apr-14 Optim Data Growth Solution... [More]
The Primary Contact should designate Secondary Contacts in IBM Passport Advantage to assist with adding new users and determining access privileges. Once nominated, Secondary Contacts have all the same management access rights as the Primary Contact except for creating new Secondary Contacts. It is essential that the Primary Contact shares the Passport Advantage Site Number with all named Secondary Contacts. If a customer site has no nominated Secondary Contacts, the Primary Contact will be solely responsible for managing access rights.... [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 - This refers to archiving... [More]
Today, we're please to share three newly published support newsletters for three of our top Information Platform & Solutions products: InfoSphere Information Server, InfoSphere Master Data Management, and InfoSphere Data Replication ! In each newsletter, you'll find three sections: In the spotlight , featuring support news and important product updates Plan , featuring top technotes and fixes Education , featuring videos, modules, and other resources available to help you increase your skills You can subscribe to any of the... [More]
Where is online information for my product? Where can I go to ask a question? How do I know what versions and fixes are available for my product? Where can I find documentation for my products? How do I connect to the online community for my product? Check out our newest all-in-one list: IBM Information Management Support Online Resources and Subscriptions all technical support downloads, content, tools / updates about product news, fixes, technical articles / d... [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 virtual ... [More]
When you download IBM Data server driver for JDBC and SQLJ, the tar or zip file (For Example, DB2 V10.1 FP3 driver download is v10.5fp3_jdbc_sqlj.tar.gz file) contains following files: db2jcc4.jar db2jcc.jar sqlj4.zip sqlj.zip Wondering which file to use in your application? Let me explain what those files are and you can decide on which file to use for your application. db2jcc4.jar and db2jcc.jar, both of them are DB2 JDBC driver jar files and are Type 4 JDBC drivers. db2jcc.jar includes functions in the JDBC 3.0 and... [More]
Hello everyone and happy April! Rather than an April Fools' joke, we'd like to share the new Request for Enhancement (RFE) Process available for IBM Support Assistant! Through the RFE Community, you can collaborate directly with the IBM Support Assistant development teams and other users to influence the development of this tool. To make a Request for Enhancement: Visit the RFE Community Select the brand WebSphere Select the product IBM Support Assistant Note that even though you need to select the brand WebSphere, you can include... [More]