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.
When restoring you must use the restore-options in the order shown in the InfoCenter If you don't you will see error SQL0104N Example: db2 "restore database sample from /tmp/backups to newdb without prompting without rolling forward" SQL0104N An unexpected token "without" was found following "PROMPTING". Expected tokens may include: "END-OF-STATEMENT". SQLSTATE=42601 Per InfoCenter without rolling forward is listed before without prompting. So it should look like... [More]
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]
Interim fix 7356 for InfoSphere Optim Performance Manager Version 5.3 includes the APAR IC99420 which corrects the issue of "WEB CONSOLE DOES NOT OPEN ANY DASHBOARDS, SHOWS BLANK PAGE" Download the fix 24X7 from Fix Central - http://bit.ly/opmfc7356 View the full lists of APARs and other key customer issues that are fixed in different interim fixes for IBM® InfoSphere® Optim™ Performance Manager V5.3, V5.2 and V188.8.131.52 http://bit.ly/opmlist Learn more Fix... [More]
End of Support i s a natural stage in the IBM Software Support Lifecycle. End of Support marks the 'official' withdrawal of technical support for specific versions and releases of software products. Learn more in this new video about the Product Lifecycle available in the IBM eSupport channel on YouTube: Other Product Lifecycle resources: The Support Lifecycle page Lifecycle information for IM products only The complete Lifecycle Policy
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]
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 Server Date: Tuesday May 27,... [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 ~/sqllib/samples/c to local... [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. Netezza Appliance General Availability End of Support Product ID Netezza 5200 May 24, 2006 September 30, 2014 5725-F17 Netezza 10050 L, S and XL models November 11, 2006 September 30, 2014 5725-F01 Netezza 10100 L, S and XL models July 15, 2005 September 30, 2014 5725-F02 Netezza 10200 L, S and XL models December 29, 2006 September 30, 2014... [More]
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 find... [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 completed processing. "2" rows... [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 logs for... [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 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]