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]

Tags:  monitor inplace reorg db2 im_techtip offline

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]

You have setup a HADR database and it is in peer state, if your primary server goes down how does the client connect to the standby server ?    You can use automatic client reroute with HADR to make client applications connect to the new primary database after a takeover operation. If automatic client reroute is not enabled, client applications will receive error message SQL30081. Automatic Client Reroute (ACR) enables a DB2 client application to recover from a loss of communications so that the application can continue its work with minimal... [More]

Tags:  db2 im_advice automatic im_techtip acr reroute hadr client

Did you know that IBM has extended software support agreements? Depending on the product, IBM has a commitment with its customers to provide product and technical support on software products for a designated amount of time, after the product has reached end of support (EOS) also known as end of life. Once a product reaches EOS, the support is no longer available for purchase or technical support without an extended support agreement. The lifecycle policy indicator determines how long IBM will continue to support the product once it has reached... [More]

Tags:  support tco extended se

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]

Tags:  windows db2level sql1022c db2 db21018e

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!

Tags:  db2 im esupport kcs

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]

Tags:  server 50_db2_nuggets replication db2 infosphere upgrade migration irs db2_advice

 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]

Tags:  security protect guardium

  An ODBC driver manager is not supplied on UNIX platforms as part of the operating system. Using ODBC on UNIX systems, therefore, requires a separate commercial or open source ODBC driver manager. The unixODBC Driver Manager is an open source ODBC driver manager for use on UNIX platforms. This driver manager is supported for ODBC applications on supported DB2® platforms. To run ODBC applications on Linux or UNIX operating systems, you must configure the UnixODBC Driver Manager.  Here are the steps to install and configure UnixODBC for... [More]

Tags:  db2 unixodbc

  Here is a simple DB2 command which will display the DB2 products that are installed on the system: db2ls  - it displays the Install path, product level, fix pack details, Special Install Number, Installation date , Installer UID. The db2ls command is the only method to list all DB2 product at Version 9 or later. However you cannot use the db2ls command on Windows operating systems. $ db2ls Install... [More]

Tags:  products db2_techtip path db2level db2

  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]

Tags:  request service feedback support portal

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).

Tags:  informix dba

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]

Tags:  db2

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]