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]
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]