Db2 V9.0 table fragmentation

Source: Internet
Author: User

Recently, many operations have been performed on a table, including adding fields, modifying field lengths, deleting fields, importing data, deleting data, and searching through SQL statements, when I use it, I find that there is a problem with this table. When I write the select statement to retrieve the data of this table, an error message is displayed, indicating that the table has fragments and cannot be used normally, after searching, you need to use the reorg command to clear the fragments. After executing the reorg command, you can retrieve the data again. It is a bit incredible that Oracle will also produce fragments, but Oracle will not affect your continued use.
 
It is becoming increasingly difficult to use DB2 because it has many problems. For example:
1. Without a client tool such as a good tool, the control center of DB2 is not as good as that of mssql and oracle.
2. Restoration is troublesome. rollback and redirection are often required. Restoring with the restore command really took me a lot of time.
3. Some tables, such as T20090815_171657, are generated inexplicably. After searching for the tables, it is still unclear why. We need to schedule a special study.
4. sorting of the NULL value and the time type. The NULL value is listed first.
5. CRUD or adding or deleting fields to a table is too many, which may cause table problems. For example,-668 56018 does not allow you to add columns to a table defined by EDITPROC. In this case, you need to reorg table.
There may be other things that you cannot remember.
 
The list is related to the user experience. I believe that DB2 is very powerful. After all, it has been around for more than 20 years, but it does not make me feel easy to use. The current system has a strong relationship with another system, while the other system uses mssql. consider adjusting the system to support mssql. In this way, you have one more choice, it can also pave the way for future productization.
 

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.