I use DB2 in these years.
sequence
First, declare that I am not writing self-pass; I am not a master, I don't want to buy a wind in front of the masters. From graduation to now, I have been dealing with DB2, there are some feelings, come out and share it with you.
First contact
The first time I contacted DB2, I dated back to 1999. At that time, I just graduated into a software company that had such a little relationship with IBM as a programmer. At that time, the DB2 version was 5.1, and the operating system used at this time was the plaid 98. In the trial period, the work I be assigned is a custom approval process implementation, a total of two people, I and another person (which seems to be a bit like nonsense, huh,!). At that time, my database is still an unclear. I only know the grammar of several simple SELECT statements learned in the school, and I don't know what the large database length is.
Next, it is desperately looking for a book. I still remember that there is a database theory. Delphi database program is developing; looking at the colleague written a string SQL Statement, I feel that he is God! Now think about it is a mentally wise. Later, I know how to use Erwin to design E-R map (entity relationship map) and generate a database of data entities. Since then, the real start is deal with DB2.
At that time, the first book about DB2 was the IBM training textbook; it was white color, and two books were collected. The content is very comprehensive, starting with the basis, gradually inserting the graphical interface, very suitable for beginners. Probab probably: How to install DB2 databases; how to configure it on the client to the database server connection; how to establish a database object on the control center; instance, mode, table space, container concept; some simple SQL statements Write and more. I have read it carefully. I combined with the use of DB2. I quickly mastered some basic operations. My work is basically related to these.
For the first time, install DB2, find a user named DB2ADMIN; I will wonder why it is necessary to create this user, and others also tell me that this user has created its password, it is best not to modify, this is why? ? After the installation is complete, there will be such a "Control Center, Client Configuration Program, Command Window, Command Center. Then start a first step similar to the wizard, according to the training textbook, use it to generate a sample database of DB2, some of the following operations are on this sample database. At this time, I want to modify the password of DB2Admin, I will try it again. But I found out that DB2Admin's password can be modified in the control center. Later, I accidentally discovered a button to change the password. Try - can be modified, OK! Datual, but unfortunately there is no double child ^ _ ^. I am stealing in my heart, do you see that I have modified the password and I don't think there is anything different! The joy is only for 5 minutes. After restarting the system, I will find that I can't connect the database, the system error DB2 management server does not start? !
What is the DB2 management server? Just tossing for a morning, there is no tossing, no way, reinstall it ~; Who let my surname "". depressed! After reinstalling, it will return to normal, and it is not dare to make this year from this year!
