Skip to main content


developerWorks  >  Information Management  >

Best Practices: Frequently Asked Questions from Problem Management Reports

developerWorks


Introduction
Outline for Best Practices paper
Download
Get involved



Get answers to the most common questions that DB2 customers have about the DB2 data server.


Introduction

This paper provides answers to the most common questions that DB2 customers have about the DB2 data server.

The questions and answers cover the following products:

  • IBM DB2 Universal Database™ (UDB) for Linux, UNIX, and Windows, Version 8
  • IBM DB2 UDB for Linux, UNIX, and Windows, Version 8.2
  • IBM DB2 Version 9.1 for Linux, UNIX, and Windows (DB2 9)
  • IBM DB2 Version 9.5 for Linux, UNIX, and Windows (DB2 9.5)

This paper is organized as follows:

  • The first section of this paper answers questions that you might have when installing or upgrading the DB2 data server.
  • The second section of this paper answers questions that you might have when running the backup or load utilities.
  • The third section of this paper answers common operational questions.

This paper is intended for all customers.


Back to top



Outline for Best Practices paper

  • Introduction
  • Installation and upgrade questions
    • Can I install different DB2 versions on one server?
    • Can I use my DB2 UDB Version 8.2 instance on DB2 9.5?
    • Where can I find DB2 fix packs and client code?
    • I recently applied a DB2 fix pack on my system. Now, I can’t start the instance. What’s the problem?
    • Where can I find a list of APARs?
    • I recently installed the DB2 data server on the AIX® platform. Are there any known issues that I need to be aware of? Also, we are planning to upgrade our AIX installation. Does the DB2 data server support the new AIX version?
    • On a Windows platform, I uninstalled DB2 UDB Version 8.2, and then installed DB2 9. When I try to restore a database from a backup, I get SQL1005N. Why?
    • I upgraded to the latest fix pack from an earlier fix pack. How do I go back to the earlier fix pack?
    • How do I verify which DB2 product I have? How do I find out which DB2 version I am running?
    • How long are DB2 fix packs supported? Can I get a specific fix added to an old fix pack?
    • My license for DB2 9 expired 90 days from the date of the product installation. Where can I find the license key?
    • What is the end of service date for DB2 UDB Version 8?
    • Are there any general recommendations on AIX ulimit settings for the DB2 data server?
    • Why do I receive a “License not found” exception when I try to connect from my Java application to a DB2 on z/OS® database using the Universal JCC driver?
    • Are DB2 products supported on the Microsoft® Windows Vista® platform?
  • Backup and load questions
    • I have an online backup that sometimes ends with SQL0911N, reason code 68. How can I prevent this?
    • Can I back up an SMS table space and restore it to a DMS table space, or vice versa?
    • Can I restore a database backup image on a UNIX or Linux platform to a Windows platform, or vice versa?
    • Can I copy an instance (database directories and files) from one computer to another as a backup strategy?
    • Can I restore a database from a backup image taken on a 32-bit system to a 64-bit system or vice versa?
    • Can I restore a backup image for a database to a different path?
    • How can I load data into a table and have the table accessible after the load?
    • Can I include logs while taking a backup? Also, if I have an online database backup image that includes logs, can I restore and apply only the logs in that backup image?
  • Miscellaneous questions
    • Can I change the code page of an existing database?
    • How does the database manager calculate the CPU speed of the system (the value of the CPUSPEED database manager configuration parameter)?
    • If I drop an instance, do I lose my database and its data?
    • I have a table in table space A and its index in table space B. Can I drop one of the table spaces and then rebuild it?
    • I added a database partition to a database partition group. Can I redistribute only one table in the database partition group?
    • Is DB2 striping or disk striping preferred?
    • Is there a command that I can use to calculate the size of my database?
    • Does the DB2 data server provide functionality similar to that of the Oracle® truncate command?
    • Which .NET Framework versions do I need for DB2 .Net Data Provider?
    • I receive a TCP/IP communication error (SQL30081) when I try to connect from my client. Why?
    • Why don’t I see the Development Center in DB2 9?
    • Why, after installing DB2 9, can’t I find DB2 data sources when trying to add a new data connection in Visual Studio 2005?
    • Can I retrieve the current time and date by using a DB2 command?
  • Further Reading
    • Contributors
  • Notices
    • Trademarks


Back to top



Download

" Best Practices: Frequently Asked Questions from Problem Management Reports " (May 2008)
Get answers to the most common questions that DB2 customers have about the DB2 data server. (pdf; 505KB; 21 pages)



Back to top



Get involved

Check out all the other Best Practices papers and see how you can improve your experience with DB2 for Linux, UNIX, and Windows.

Comment, edit, or add your own insights to the Best Practices papers on the IBM Database Wiki.




Back to top


 logo

Document options

Document options requiring JavaScript are not displayed


My developerWorks needs you!

Connect to your technical community


Special offers
Dynamic  infrastructure for software delivery
Automate processes to the Web with Lotus Forms
Learn to design an ESB Gateway

More offers