Information on Demand... IOD... the largest IBM EXPO... that place where comfortable shoes are ESSENTIAL... the best education you'll get all year.... whatever you call it, the conference is ALMOST HERE ! Experts from Subscription & Support can hardly contain our excitement about IOD 2013! Since last year's conference wrapped up, we've been brainstorming ways to make this year the absolute best one yet. Here's how we're going to do it: We're all together in a single space in the EXPO -- the IBM Software... [More]
New Video - How IBM uses Knowledge-Centered Support (KCS) In Information Management Technical Support, we've invested a lot of time, training, and effort improving our Knowledge Base by implementing Knowledge-Centered Support (KCS). I'm excited that a new video has been posted which helps explain the KCS process in IBM: Together, we are making support better!
There are two approaches to table reorganization: classic reorganization (offline) and inplace reorganization (online). During offline reorganization as the name suggests, you do not have access to the table where as an inplace table reorganization enables you to reorganize a table while you have full access to its data. To specify an online reorganization operation, use the INPLACE option on the REORG TABLE command. Classic table reorganization uses a shadow copy approach, building a full copy of the... [More]
IBM Infosphere Guardium is gaining momentum. More and more customers are using it to implement a robust monitoring and security solution for their environments. If you want to learn more about IBM InfoSphere Guardium you can start here: http...s://www-304.ibm.com/support/docview.wss?uid=swg27020137&aid=1 IBM InfoSphere Guardium 8.0 Quick Start Guide If you have questions and/or need assistance with this product, IBM's Technical Support can help. Check out the link below for a summarized guide on how to contact IBM Infosphere Guardium... [More]
Continuous availibility is the concept that enables 24/7 access to IT-enabled business functions, processes and applications. And minimizing planned downtime is what business and IT departments consider seriously nowadays. Especially, minimizing and setting the appropriate downtime is a bit challenging decision in case of DB2 version upgrade or migration to another system, because we also need to consider the time for getting back to original system in preparation for any unexpected problem after the planned change works. ... [More]
-1213 A character to numeric conversion process failed. A character value is being converted to numeric form for storage in a numeric column or variable. However, the character string cannot be interpreted as a number. It contains some characters other than white space, digits, a sign, a decimal, or the letter e; or the parts are in the wrong order, so the number cannot be deciphered. Cause Your query is causing Informix to attempt to explicitly or implicitly cast non-numeric data in a character column to a number. Example: You have a table... [More]
Yesterday, we shared the top Informix technical docs and, of course, we don't want our DB2 LUW friends to feel left out! So, without further ado, here are the most popular technical documents for DB2 for Linux, Unix, and Windows:
27 Oct 2011: DB2 Fix Packs by version for DB2 for Linux, UNIX, and Windows 16 Apr 2011: DB2 UDB Version 8 - End of Support date 30 Apr 2012: DB2 UDB Version 9 - End of Support date 15 Jun 2011: DB2 database product documentation 30 May 2011: DB2 UDB Version 8 Product Manuals 30 May 2011: DB2 Version 9.1 for Linux,... [More]
It amazes me some times how innovative DBAs can be. Truly out of the box solutions and that I want to have on my DO list. Also amazed with unpleasant surprise on what silly things some DBAs Do or fail to do and I want to have on my Don’ts list. As you run into any of the Do's or Don’ts please share them with us. Here is one. Always take a back up then periodically verify that the backup is valid (DO). Don' wait until you have to restore to validate your backup (Don’ts).
Hi there! SQL0428N error is easy to resolve provided you have actual SQL statement causing the error. Here is more information about actual error message link SQL0428N The SQL statement is only allowed as the first statement in a unit of work. User response Issue a COMMIT or ROLLBACK prior to processing the SQL statement. If there are any WITH HOLD cursors, these will need to be closed. If the statement is SET INTEGRITY, remove the COMMIT THRESHOLD clause. Adding a COMMIT or ROLLBACK prior to SQL statement generally resolves the issue. But what... [More]
Today's Technical Tip comes from a guest blogger, Angela Yang . Angela is an Advanced Technical Support Analyst for DB2. She has been working with DB2 for the past 8 years. Angela works out of IBM's Toronto Lab. Look for more blogs from Angela on other hot DB2 topics! Section explain and section actuals are new Explain features that are useful for query performance problem determination. This blog introduced these two features and the usage of them through exercises.
Section explain Section explain is a new feature added in DB2 9.7. Using... [More]
Are you interested in helping to shape future enhancements to IBM Support Portal, Fix Central, My notifications,
Service Request, and other online tools? The IBM Electronic Support user experience team is currently recruiting
clients to participate in design reviews and usability testing. You can choose from several different opportunities to participate: Drive requirements for the future What: Join the 2013 IBM Electronic Support Client Advisory Panel Who: Ideal for clients who support
or use at least one IBM product and who... [More]
Hello All, When DB2 crashes or hangs of it usually causes DB2 to create a trap that leads up to the failure, in this case the trap usually happens out side of DB2 and shows the following: If the call stack shows the following: 0x00002AAACE1F49CF _nss_ldap_ent_context_release + 0x002f (/lib64/libnss_ldap.so.2) 0x00002AAACE1F6A75 _nss_ldap_endgrent + 0x0015 (/lib64/libnss_ldap.so.2) Or if your OS logs found /var/log/messages show: May 7 08:23:33 db2test db2sysc 0: nss_ldap: could not get LDAP result - Can't contact LDAP server May 7... [More]
Hello All, Need help navigating through Passport Advantage to find your DB2 license key. Then you're in luck because we have put together the following to help you with that: Purchasing a License for DB2 LUW V9 How do I download my DB2 license from Passport Advantage Passport Advantage and Passport Advantage ExpressPerform more complex management of your product list Still have trouble or just have a question about your DB2 License key, then comment below.
Getting "SQL0407N Assignment of a NULL value to a NOT NULL column" error when inserting an empty string. An empty string is not a NULL value in DB2. The root cause of the issue is due to the following db cfg parameter. Varchar2 compatibility = ON The VARCHAR2 and NVARCHAR2 data types are introduced to support applications that use the Oracle VARCHAR2 and NVARCHAR2 data type. If DB2_COMPATIBILITY_VECTOR=ORA set in your instance environment and then when you create a database, the value of the Varchar2 compatibility will be set... [More]
To our friends at IOD: Hope you are having a great time! Just wanted to take a minute to send a special note to our friends attending IOD - hope you are enjoying yourself and learning a lot. There are some really good representatives from Information Management there - we hope you are able to hear them, meet them, and speak with them. Check out the Information Management Services, Education & Support Activities: http://www-01.ibm.com/software/data/2010-conference/im-services-activities.html Remember, what happens at IOD........ [More]