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.
The db2ReadLog API is used to read log records from the DB2® database logs, or queries the Log Manager for current log state information.
Before a Embedded SQLC program can be used it has to be precompiled, bound, compiled and linked. Here is an example on how to use the db2ReadLog API using the dblogconn.sqc sample SQLC program that is provide with the DB2 sample scripts. This program reads the database log files asynchronously with a database connection using the db2ReadLog API.
Copy the sample c scripts from... [More]
Netezza 5200 and Netezza 10000 series appliances will reach End of Support (EOS) on September 30, 2014.
Service Extensions are not available for this product.
End of Support
May 24, 2006
September 30, 2014
Netezza 10050 L, S and XL models
November 11, 2006
We're pleased to share a new blog now available for our IBM Support Providing Partners for the IBM PureData System for Analytics Appliance. This blog already contains a ton of useful information, including technical workshops, videos, FAQs, and more.
Check out the blog: http://www.ibm.com/connections/blogs/pda
IBM PureData System for Analytics is excited to announce the publication of APARs as part of the problem reporting process!
An APAR - Authorized Program Analysis Report - is a formal report to IBM development of a problem caused by a suspected defect, published so that it is visible to supported customers. If IBM development is able to confirm the defect, they will update the APAR with any known workarounds and perhaps an indication of which future release they intend to target for a formal fix to the defect.
APARs are easy to... [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]
The following new IBM Education Assistant videos are in production. These videos will assist you in resolving certain issues without the need for contacting a Technical Support Professional!
Social Media Aggregator in Support Portal
Introduction to IBM Platform MPI
Standard LSF installation on Linux
Tune logical and physical log automatically
Starting with version 12.10.xC3 Informix can automatically tune the logical and physical log as needed.
You can set the AUTO_LLOG configuration parameter to enable Informix to dynamically add logical logs when lack of logical logs causes frequent checkpoints, blocking checkpoints, long checkpoints etc. In addition, with AUTO_LLOG configuration parameter you can specify a dbspace in which to create new logical log files and the size of all logical log files at which the server stops adding... [More]
We welcome you to the new Workload Replay Community! Click here to join today !!!!
This community provides a central location for users and business partners to find and share information about using IBM® InfoSphere® Workload Replay. Please help us make the community more valuable by providing your input and contributing information.
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... [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... [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... [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.
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]