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.
If you need regular database backup during night or weekends, use DB2 automatic maintenance feature.
Here is DB2 V9.7 Information Center URL:
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.... [More]
We are excited to announce a new Support Technical Exchange (STE) available for InfoSphere Information Server!
Support Technical Exchanges feature a technical expert sharing his/her knowledge on a specific support-related topic. Following the presentation, the expert is available for questions and discussion. Sessions are designed to address specific technical issues and provide in-depth but narrowly focused training and education.
Topic: Configuring LDAP/Active Directory filters for InfoSphere Information... [More]
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]