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.
Please join us for our upcoming Support Technical Exchange! Our speaker, Scott Brokaw, will guide us through Configuring SSL/HTTPS in InfoSphere Information Server versions 8.5 - 11.3. Date: Tuesday April 21, 2015 Time: 11:00 am ET Registration: https://events.na.collabserv.com/register.php?id=a7de9277eb&l=en-US Abstract: This presentation will discuss how to leverage and configure SSL (Secure Sockets Layer) authentication. SSL authentication is configurable at version 8.5 and later. Beginning at version 11.3 SSL authentication is mandatory... [More]
Abstract: In some circumstances, there is a requirement to recover multiple dropped tables. DB2 provides a function in rollforward command which can help to recover a single dropped table in one command. In this article we present a hands-on exercise to illustrate how to achieve this goal. Here is the scenario: Suppose the tables( t1,t2 ) are dropped at time T1< T2 . In rollforward command, using rollfoward to PIT without the complete option to T1+1 for t1 and T2+1 for t2. There is a backup image before dropping the tables t1... [More]
Hello DB2 mates, Hope all is going well for you. In a multiple databases environment, we sometimes configure remote catalogue information for target databases like followings. $ db2 catalog tcpip node <nodename> remote <IP or hostname> server <Port number> $ db2 catalog db <dbname> as <db alias> at node <nodename> And in some cases, we need to reconfigure this information. For example, if you regularly change the port number of target system DB2 instance, the client catalog information should be... [More]
Today, I came across an interesting issue and I would like to walk through the problem and the details taken to resolve the issue. Problem: db2icrt fails with, ERROR: DBI1281E The database manager configuration file could not be initialized. I have a repro to illustrate this. [root@hobbits instance]# ./db2icrt -d -u instedi instedi DBI1446I The db2icrt command is running. DB2 installation is being initialized. Total number of tasks to be performed: 4 Total estimated time for all tasks to be... [More]
Looking for some help on how to resolve the error DBA7908E .
Then you're in luck because we have put together the following tech doc
to help you with that: DBA7908E error upon connection to a new DB2 for z/OS system. Still seeing the error or have questions about it, then please feel free to comment below.
We have seen many customers having problems with the db2iupgrade command. Some are very common and can be resolved in seconds. To save your time, here is the most common problem while upgrading and some tried and tested solutions to overcome it. Problem Description : When you try to upgrade a db2 database using db2iupgrade command sometimes it may fail with following error message : DBI1264E Errors were encountered in running db2iupgrade. Please refer to the installation log file /tmp/db2iupgrade.log.xxxxxxx In the db2iupgrade.log file it... [More]
When creating a new instance. DB2 requires the group ID to fall into the range of 100-65535. If the group ID doesn't fall in that range the instance creation will fail. You will see an error similar to below. This means special care is needed for those systems with a large number of users and groups. Such as those who utilize LDAP, or Microsoft Active Directory. Special care should be taken to ensure that users and groups should be given ID's greater than the 65535 limit, so that this issue will not be hit. Reproduction: root@test #... [More]
To more quickly and accurately address your issues, we are making an important change to our IBM Software Appliance Service Request process. These changes will take effect between now and July 2014. What you need to know: When you open a Service Request using the Service Request Tool for your IBM Pure Data for Analytics Appliance, you may be asked for the serial number of your appliance in addition to your IBM Customer Number. Find out more about why we are making this change here. ... [More]
IBM InfoSphere Information Analyzer evaluates the content and structure of your data for consistency and quality. The following links contain answers to the frequently asked questions about installing, configuring, and running InfoSphere Information Analyzer. 1. Installing Find the answers to frequently asked questions about installing IBM® InfoSphere® Information Analyzer such as how to correct an error about insufficient space and how to access the log files. Where are the installation log files? What should I name the IBM... [More]
Did you know? IBM product experts respond to every single piece of feedback received on our IBM Support content Help us serve you better by providing feedback. Contact us through email with any comments or suggestions Click "[+] Feedback" on IBM.com Selecting a 5 star rating and/or leaving comments on our technical content - Click on the 5 star ratings on our content - Let us know if the document helped you solve your problem - Leave specific comments about... [More]
Did you know that IBM software has a lifecycle? IBM has a commitment with its customers to provide the product and technical support on software products for a designated amount of time, depending on the product. Once a product reaches 'End of Support' (EOS - also known as end of life), the support is no longer available for purchase or technical support without an extended support agreement. The lifecycle policy indicator determines how long IBM will continue to support the product once it has reached this date. The product lifecycle... [More]
100 Tech Tips: #73 If a non-default console port is chosen during InfoSphere BigInsights V1.3.0 Fix Pack 1 installation, it can cause problems while building dynamic collections in BigSheets During InfoSphere BigInsights V1.3.0 Fix Pack 1 installation, if you change the BigInsights console HTTP port to a non-default port (e.g. 8081), the BigSheets back-end server port and PigServer port will also change from their default values, This, in turn, might create a port conflict that can cause problems while building dynamic collections in... [More]
With the increasing use of autonomic technologies, DB2 servers can produce large message logging files, administrative notification log files, and event log files. This is especially true in large warehouse environments with many logical and physical partitions. When a fault occurs, the database manager can produce vast amounts of diagnostic data for first failure data capture (FODC) purposes. This increase in logging activity can lead to increased file system space consumption and manageability issues. Allowing the db2diag.logfile to grow... [More]