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]
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.
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]
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]
Hello! Last week, I ran into a customer problem where the 32-bit ODBC User DSN test from 32-bit ODBC Data Source Administrator (C:\Windows\sysWow64\odbcad32.exe) for a remote database running on AIX was failing with below error with 32-bit DB2 Data Server Driver Package 9.7 FP0 on Windows 7 64-bit: We tried to create a new User DSN from 32-bit ODBC Data Source Administrator, but we could not, since it failed with the same error. On their Windows XP, machine they have the same setup, the DSN test connection works fine, only on... [More]
Hi All! I had opportunity to implement AES encryption from a Java program using a DB2 JDBC driver with ORACLE Java. Here are all the steps I took: 1> On client machine, installed ORACLE Java 7: http://www.oracle.com/technetwork/java/javase/archive-139210.html C:\Program Files\Java\jdk1.7.0_45\jre\bin>java -version java version "1.7.0_45" Java(TM) SE Runtime Environment (build 1.7.0_45-b18) Java HotSpot(TM) Client VM (build 24.45-b08, mixed mode, sharing) 2> On server, I changed the configuration as below to support AES... [More]