I listened to IBM today for introduction of AIX and DB2. The main harvest has the following points:
1 First, the main bottleneck of large-scale software is on the IO storage device.
2 The development of technology can now do two things: bind the program to the specified CPU; monitor the changes of memory and generate a report.
3 If the virtual memory continues to increase, the software has a memory leak.
4 Design of Database Direction: Generally, a CPU is to bring 6 hard drives. The database should be distributed in different logical volumes, support synchronous concurrency operations. Note Table Space = BufferPool. DB2 and Orical are distinguished in the table lock, IBM is an actual lock, orical virtual lock. DB2 will be locked when the data is not submitted, so the query will wait in the lock.