Informix 11.70.xC8 is released (eGA) on 9 January 2014. GA date is 14 January 2014. Product Editions Informix Developer Edition Informix Innovator-C Edition Informix Express Edition Informix Growth Edition Informix Growth Warehouse Edition Informix Ultimate Edition Informix Ultimate Warehouse Edition Features: Information Center - http://pic.dhe.ibm.com/infocenter/idshelp/v117/index.jsp IBM Informix, Version 11.70.xC8 contains the following new functionality. For full... [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]
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]
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]
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]
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.
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]
Problem(Abstract) Initializing InstallShield Wizard........ Launching InstallShield Wizard........ The wizard cannot continue because of the following error: could not load wizard specified in /wizard.inf (104) Cause Install can't locate java path Resolving the problem ./ids_install -javahome your_JRE_path This forces the installation script to use the bundled IBM Java Runtime Environment.
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]
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]
In a Windows DB2 setup there are two kinds of Command Winodw - DB2 Command Window - Administrator - DB2 Command Window Sometimes running a simple command from ordinary Command Window can return various unexpected errors. Examples, C:\Program Files\IBM\SQLLIB\BIN>db2level SQL1022C There is not enough memory available to process the command. C:\Program Files\IBM\SQLLIB\BIN>db2 connect to sample DB21018E A system error occurred. The command line processor could not... [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.