How to restore critical administrative files with onbar utility? It is already known to us that onbar backs up some critical administrative files during storage space backup. These critical files are as follows: The onconfig file UNIX: The sqlhosts file The ON-Bar emergency boot file: ixbar.servernum The server boot file: oncfg_servername.servernum There may be a situation when you need to restore one of these files, for example: replace disks, restore to a second computer system (imported restore) etc. However, previously there was no easy way... [More]
A common mistake many people make is, consider a query with parameter marker same as the query with the parameter marker replaced by literals. As soon as the parameter markers in a query is replaced by literals it's not the same query. Basically, during query compilation a query with parameter marker provides much lesser intelligence to the DB2 compiler. As a result the access plan chosen by DB2 optimizer might be sub-optimal compared to a query... [More]
It's possible some of the tables showing STATS_TIME "-" in syscat.tables catalog table even when the auto-runstats in the database is tunred ON. The main reason might be, if a table is never accessed, then auto-runstats will not action on that table, even if the table has never had runstats done. This is by-design. This could be applicable for system tables as well as user tables. Regarding system catalog tables there might be differences of observations from... [More]
While your business is growing, you might face some performance issues, that weren't there when you started using DataStage, or even worse, DataStage, has never been as fast as you thought it would be. As follows, I'm sharing with you some tips to check in general and specific environments, maybe it's matter of changing a parameter or maybe you have to install a product Fix, but remember, it's always useful to test in a controlled environment, stress your environment, and review if modifications helped or not. How to... [More]
Here is an example of the problem description: Create Workload: -- db2 "SET WORKLOAD TO SYSDEFAULTADMWORKLOAD" db2 "CREATE WORKLOAD WL_A SESSION_USER('DB2V10')" db2 "CREATE WORKLOAD WL_B SESSION_USER('JKGERA')" db2 "ALTER WORKLOAD WL_A COLLECT AGGREGATE ACTIVITY DATA BASE" db2 "ALTER WORKLOAD WL_B COLLECT AGGREGATE ACTIVITY DATA BASE" db2 "GRANT USAGE ON WORKLOAD WL_A TO PUBLIC" db2 "GRANT USAGE ON... [More]
Why is the level classified as Warning, where as the description say Sever/Error messages for the following STMM entries in the db2diag.log? 2016-03-14-04.28.31.397257-240 I19884922E702 LEVEL: Warning PID : 02028 TID : 140000802021983 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : SAMPLE APPHDL : 0-46194 ... [More]
The auto maintenance messages with evaluation of reorg, runstats are logged in the db2diag.log every two hours. These are part of auto maintenance setup in the database. Policy defined to run reorg or runstats during a certain maintenance window supposed to run reorg, runstats only during those time windows defined by the policies. The real reorg or, runstats will follow the guideline defined by the auto maintenance policies. But, the evaluation of the same are... [More]
Usually db2look ignores the DB2 internal objects as it can recreate back those objects on it's own. The user defined objects are more important to extract as DB2 don't have any knowledge about how to regenerate those back otherwise. SYSTOOLS schema have mostly system defined objects. So db2look will ignore all objects under SYSTOOLS schema except user-defined functions and stored procedures. Also, from source level to destination level the internal objects might have minor differences. ... [More]
Auto reorg is enabled. But, it's failing with SQL0284 messages in the db2diag.log similar to following, 2016-03-02-08.39.56.808159-360 I4469422E526 LEVEL: Error PID : 11111 TID : 46912895825555 PROC : db2acd 0 INSTANCE: db2inst1 NODE :... [More]
One reason why a tablespace might get marked offline after a db2 database restore might be due to issues with tablespace container filesystem or, anything related to access to filesystem containing containers of the tablespace. For this kind of reason it will show I/O messages in the db2diag.log. This can happen both during restore as well as during rollforward. But, another common reason why a tablesapce get marked offline during rollforward could be due to the... [More]
Recently we receive several customer issue of downloading InforSphere Data Explorer 8.2-3 from Fix Central. Sorry for any inconvenience. To resolve this kind of issue please contact them by calling 1-800-IBM-SERV or emailing them at UStsmail@us.ibm.com. InfoSphere Data Explorer Engine Support IBM Company IBM Support Portal at www.ibm.com/support .
When is a door not a door? When it's APAR??? In response to your feedback, we are changing our email notification process for APAR subscriptions. If you have a My Notifications subscription to the APAR category for a product, you will receive email notification ONLY FOR NEW APARs. You CAN also subscribe to all APARs for a specific product component. To follow the resolution of a specific APAR : click the APAR link, and then subscribe to that APAR. This "Subscribe or Unsubscribe" link will allow you to create or update your... [More]
What's new for you? Thanks to everyone who has been out there rating our documents on the web, we're now able to show you a list of the top rated documents in Support Portal. This is in addition to the "Most recent" and "Most viewed". So, if you are working in "browse" mode, trying to be proactive by visiting the Support Portal to keep an eye on - what's new, of course - then you need to check out the "Overview top ten" portlet! Enjoy!!!
Puppet is IT automation software that defines and enforces the state of your infrastructure throughout your software development cycle. From provisioning and configuration to orchestration and reporting, from initial code development through production release and updates, Puppet frees sysadmins from writing one-off, fragile scripts and other manual tasks. At the same time, Puppet ensures consistency and dependability across your infrastructure. With Puppet, repetitive tasks are automated away, so sysadmins can quickly deploy business... [More]
Have you heard about IBM InfoSphere Guardium or Guardium product as it is usually called? If not, read below a brief description of what this product can do to protect your database access with a powerful product. Or, if you have heard or have experience using the product, please share your experiences. What is IBM InfoSphere Guardium: It is a product that can be a combination of dedicated hardware (appliance) and software or just software (a virtual appliance plus additional software) . It provides a solution for
assuring the privacy and... [More]
Where is online information for my product? Where can I go to ask a question? How do I know what versions and fixes are available for my product? Where can I find documentation for my products? How do I connect to the online community for my product? Check out our newest all-in-one list: IBM Information Management Support Online Resources and Subscriptions all technical support downloads, content, tools / updates about product news, fixes, technical articles / d... [More]
End of Support i s a natural stage in the IBM Software Support Lifecycle. End of Support marks the 'official' withdrawal of technical support for specific versions and releases of software products. Learn more in this new video about the Product Lifecycle available in the IBM eSupport channel on YouTube: Other Product Lifecycle resources: The Support Lifecycle page Lifecycle information for IM products only The complete Lifecycle Policy
What are the Best Practices for Running Informix Instances in VMWare vSphere Virtual Environments The document provided in the following link: What is VMware Virtualization? Evolution of VMWare Virtualization Why Informix on VMWare Informix Scalability Tests Informix Scalability Test Results Best Practices for running Informix on VMWare General Considerations BIOS Considerations CPU Considerations Memory Considerations Network Considerations Storage Considerations NOTE: If you have issues trying to display this within IE but cut... [More]
When the database recovery happens DB2 retrieves the transaction log files and use those for rollforward. If the logs are compressed ones then it first DB2 uncompress those to same name except .EXP extension before using that. In-place uncompress also possible if logs are uncompressed manually using internal log uncompress tool. This is one reason, the DB2 cannot use a compressed log in a read-only filesystem as it cannot write the .EXP file there.
Welcome to the THUNDERDOME! Ok, it's the "Thoughts from Information Management Support" blog. Somehow "the Thunderdome " seemed more exciting... On the other hand, this blog will benefit you in working with your IBM Information Management products (unlike a steel cage match to the death - yikes!). In coming weeks, we'll deliver information to you regarding ways that we can help you, ways that you can help yourself, and hopefully in the process we'll help each other by getting to know each other better. The Magical Mystery... [More]