DB2 enterprise edition is the standard software that is used by many companies. It has lot of nice features that you cannot get by using workgroup server edition, express edition. It comes with pureXML that can be used for XML applications. With the recent versions of DB2 you get the autonomic computing facilities.
Before version 9, all the memory setting at database level and instance level was manually given. But with the advent of version 9, this manual intervention is greatly reduced. You just need to set the autonomic configuration ON and DB2 does the entire memory management by itself. Another great feature with enterprise edition is high availability. HADR comes with the enterprise edition and it can be used for high availability. You have a primary and secondary node in HADR. Whenever the primary node fails, all the applications are routed to the standby server. Automatic client reroute can be used here to automate the application failover process.
ENTERPRISE
Another good feature that can be used with enterprise edition is compression. Compressing your data can help you in saving storage costs. Compression can happen at row level and if you have huge tables then you would compress them. Compression also decreases the backup time. Compression is good in I/O bound systems. DB2 workload manager can be used to allocate certain amount of resources to a process. For example, if you want to limit the CPU usage for some job then this can be achieved by using workload manager.
Enterprise edition also can be enabled for partitioning. If you have a huge database then it is not a bad idea to partition the database between several nodes. This would enhance the application performance as it does parallel processing.
DB2 Enterprise Server Edition
If you are looking for a good computer bag rolling computer bag [http://rollingcomputerbag.net]. Also if you are craving for a toiletry bag leather toiletry bag [http://leathertoiletrybag.org]
ENTERPRISE
0 comments:
Post a Comment