Tech Tip: Changing DB2's query
behavior using the DB2_COMPATIBILITY_VECTOR. Starting in Version 9.5 DB2 LUW has
provided the ability to modify DB2's query behavior so that it alines
with other database platforms . This functionality is enabled
through a DB2 registry variable called the DB2_COMPATIBILITY_VECTOR.
This variable accepts several hexadecimal values. For example if you
would like to execute the truncate command so that the Immediate
keyword is no longer required (as in the case of DB2 for Z/OS) you
can set the... [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]
100 Tech Tips: #71: If a non-default console port of 8081 is chosen during InfoSphere BigInsights V1.3.0 Fix Pack 1 installation, the Web Console will fail to start due to a port conflict. During BigInsights V1.3.0 Fix Pack 1 installation, if you change the BigInsights console HTTP port to a non-default port value of 8081, the PortOffset value in WAS CE will be set to 1, resulting in a new value of 9999 (default +1) for JMXSecurePort. This will create a port conflict because the default port for Hive web interface is 9999. For more... [More]
The IBM Service Request Tool is the best way to report a problem or open a PMR with IBM. If you are already a user of the Service Request Tool, you are probably familiar with some of its benefits. If you haven't used it before, try it the next time you need to contact IBM Support. To see one of the many advantages of Service Request, watch our new video showing you how you can view and update PMRs quickly and easily on the web. To access the Service Request Tool, visit the IBM Support Portal and click the Service Requests & PMRs tab.... [More]
IBM InfoSphere Streams is a software platform that enables the development and execution of applications that process information in data streams. IBM InfoSphere DataStage is an ETL tool that integrates data across multiple systems using a high-performance parallel framework, and it supports extended metadata management and enterprise connectivity. Integration of InfoSphere DataStage and InfoSphere Streams applications involves flowing data streams between the applications and configuring them to use the data. This presentation provides... [More]
New IBM Education Assistant presentation - How to relocate an IBM InfoSphere Information Analyzer analysis database (IADB) to a new location . Related techdoc #7042099 . This presentation discusses both the restrictions and requirements for relocating the IADB database. It also walks you through the overall process and steps that are required to relocate IADB. This presentation is valid for Information Analyzer version 9.1.
This year's IIUG Conference is now only days away. Our Informix Support team is ready to go and is looking forward to speaking with you. Here is a quick overview of where you can find us at IIUG:
Sunday Tutorials Check out this blog post for our activities during the IIUG Sunday Tutorials. Support Kiosk Like last year, you'll find many of us at the Support Kiosk between the hours of 10am and 2pm daily. At the kiosk, you can:
Find out how your Informix Database can benefit from a FREE Health Check Lite
Talk to the experts about your... [More]
InfoSphere Information Analyzer provides capabilities to profile and analyze data to deliver trusted information to your organization We have gathered few interesting links and information about InfoSphere Information Analyzer that can be useful for you Visit the site for configuring IBM InfoSphere Information Analyzer (You must have Information Analyzer Data Administrator authority) This link takes you to the frequently asked questions about IBM InfoSphere Information Analyzer The log files are in the following directories:... [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.
100 Tech Tips, #55: InfoSphere Warehouse Operation System higher
level support technote is updated to be more generic
Installing InfoSphere Warehouse (ISW) 9.7.x on an Operation
System (OS) whose intermediate upgrade that was not available at the general availability
of an ISW 9.7.x release may cause the ISW installer’s OS check to fail. The “How to complete the installation of InfoSphere Warehouse V9.7x when the level of your operating system is higher than the levels that are recognized by the installation program.” technical... [More]
SQL4728W : A priority setting was assigned to a service class that is higher than the priority setting of the default system service class SYSDEFAULTSYSTEMCLASS and this might negatively impact performance. To ensure that system work can take precedence over user work, the priority settings of the default system service class SYSDEFAULTSYSTEMCLASS should always be higher than the priorities that were set for all other service classes. Failure to assign higher priority settings to the default system service class can result in a negative impact... [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]
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.
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]