Hello db2 DBAs I recently had an interesting situation, which seemed on the face of it highly unusual. So I wanted to share with this group. PROBLEM: Cust called in indicating he has inserted 32 rows into a table. Then he runs the command db2 "select count (*) from <tabname>" returned correct 32 value. Then he ran the command db2 "select * from <tabname>" However this returned just one row!!! WHY ? db2 has encountered a bug or what? My thought processes in debugging this was as follows: 1. Are... [More]
Hi there! Recently I had an opportunity to implement SSL connection from DB2 client's CLP. DB2 Server was already setup with SSL. Just wanted to share the steps I followed to implement SSL connectivity successfully from the client side: 1> Set LD_LIBRARY_PATH, PATH and LIBPATH to point to GSKit libraries (present at $INSTHOME/sqllib/lib64/gskit) and tools needed to add SSL certificate (present at $INSTHOME/sqllib/gskit/bin) [db2v10@ts-jkgera new]$ echo $LD_LIBRARY_PATH... [More]
In the beginning of May, IBM significantly updated the IBM Support Portal support site, with improvements to make this worldwide one-stop site for technical resources for all IBM products even more effective and useful for our clients. Some are adjustments our clients have requested, others are redesigns to improve our clients' efficiency finding the information they need. Here's a quick rundown of new capabilities to look for.
Several enhancements have been made to the product selection function. In the “Choose your products” module, users... [More]
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]
Information on Demand 2011 is in full swing! Here are a few key observations from our team on-site at the event and our team watching the event from our IBM offices! The Support, Services, and Education Hub has been busy throughout the event and is in a great location right behind the IBM Watson pedestal! Attached are photos of the Support part of the Hub as they got ready for today's rush! If you are at the event, visit the Hub in the EXPO, pedestal 625. Demos, demos, demos ! The Support Hub has been showing tons of demos of all of our... [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.
When a table is dropped and recreated the triggers are marked inoperative, when you do an insert operation afterwards or call SYSPROC.ADMIN_REVALIDATE_DB_OBJECT the trigger remains inoperative, invalid triggers get revalidated with these operations but inoperative triggers remain inoperative until you recreate the trigger. CREATE TRIGGER statement http://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.sql.ref.doc/doc/r0000931.html Modifying and dropping triggers... [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]
When restoring you must use the restore-options in the order shown in the InfoCenter If you don't you will see error SQL0104N Example: db2 "restore database sample from /tmp/backups to newdb without prompting without rolling forward" SQL0104N An unexpected token "without" was found following "PROMPTING". Expected tokens may include: "END-OF-STATEMENT". SQLSTATE=42601 Per InfoCenter without rolling forward is listed before without prompting. So it should look like... [More]
Working for IBM, I have access to experts who can advise me how to best
use IBM products. Now you have this access too, through IBM's Proven
Practices documents. A Proven Practices document provides rich technical information that is
tried, tested, and proven to help you succeed with IBM products in a
specific technology environment. It can be about any topic: problem
solution or problem preventative. Proven Practice documents are usually
written by senior support staff, based on real customer experiences. To find... [More]
To continue our series covering the most popular technical documents, today we're bringing you a list of the top 10 documents for IBM Optim !
20 Sep 2011: Detailed System Requirements for components of IBM Optim 7.2 03 Nov 2011: Detailed System Requirements for components of IBM Optim 7.3 03 Jun 2011: Detailed system requirements for components of IBM Optim Data Privacy Solution v2.1 28 Jul 2011: Installing your Optim solution in Windows Vista and succeeding Windows platforms 15 Nov 2010: Detailed System Requirements for components of IBM... [More]
IBM InfoSphere Data Explorer, Version 8.2-2 is available to download. InfoSphere Data Explorer Version 8.2-2 includes the following updates: • Data Explorer Engine uses Installation Manager 1.6.1, which provides a 64-bit version of Data Explorer Engine. It is therefore no longer necessary to install 32-bit libraries to use Installation manager on Linux systems. • Data Explorer Engine now supports optionally displaying query results in original document formats, known as rich preview. Displaying rich preview results in a browser is not... [More]
Nowadays, DB2 is running on many hypervisors based on various cloud and virtualized environment. And virtualised environment has various types including bare metal or operating system(O/S) hosted architecture. So sometimes there can be a confusion when we interpret a compatibility document in terms of Virtualisation technology experts. The point is that hypervisor itself is also a kind of O/S technology basis. For example, PowerVM is actually working on AIX O/S and we should be able to differentiate this from the target O/S where DB2 will be... [More]
Need help with common DB2 security issues, than your in luck because we have put together the following links to help you with that: DB2 LDAP Crash On Linux SQL30082N Security processing failed with reason "19" ("USERID DISABLED or RESTRICTED"). SQLSTATE=08001 Error SQL30082N Reason Code 15 or 24 Receiving error SQL30082N reason code 42 when attaching to an instance. DB2Look command returns error SQL30082 rc=26. Receiving SQL30082 RC 3 when connecting from a remote client SQL30082 rc=24 connecting to a... [More]