Configuring Log Partitions 
To increase the speed with which the system writes log entries to the log area, you can divide the log area into several log partitions. The system can then write log entries to several log partitions in parallel.
A log partition consists of one or several log volumes and, if applicable, the respective mirrored log volumes (if you have enabled software-based mirroring of the log area).
When you create a log volume, you assign it to a log partition. If you do not assign the log volume to a partition, the system automatically assigns it to the first log partition.
Caution
After a log volume is in use, you can no longer change its assignment to a log partition.
Prerequisites
You are logged on to the database as the database system administrator or as a DBM operator with server authorization for accessing database parameters (read and write) (see Glossary, Server Permission).
To configure the maximum number of log partitions, use the special database parameter MaxLogWriterTasks (see Changing Database Parameters).
Overwrite mode for the log area is off (see Activating or Deactivating Overwrite Mode for the Log Area).
During log partitioning you have to carry out a log backup. Note that a log backup requires that you have carried out a complete data backup before (see Backing up Data).
The database is in the OFFLINE operational state.
Procedure
Configuring Log Partitions and Activating Log Partitioning
Select the database in the explorer tree.
In the context menu of the database, choose
Administration Tasks 
Change Log Settings... 
Select Configure Log Partitioning.
Choose Next.
If no complete data backup is found, activating log partitioning is not possible. Choose Backup to perform a complete backup if necessary.
Activate Log Partitioning: Activating log partitioning involves carrying out a log backup and restarting database.
Specify the number of log partitions. Select Restart database after configure log partitioning.
To configure log partitioning the database must be in operational state OFFLINE. Select OFFLINE if necessary. After changing the operational state choose Next.
Assign at least one log volume to each of your log partitions.
To add a log partition, choose New... in the context menu of the log volume.
To change the log partition that a volume is assigned to, choose Edit... in the context menu of the log volume.
RecommendationAll log partitions have the same size and the same number of assigned log volumes.
End of the recommendation.Create a log backup (Backing Up Log Entries) and choose Next.
To apply your settings, choose Activate.
Changing the Number of Log Partitions
Select the database in the explorer tree.
In the context menu of the database, choose
Administration Tasks Change Log Settings... Select Configure Log Partitioning.
Select Change the number of log partitions.
Specify the number of log partitions.
Assign at least one log volume to each of your log partitions.
To change the log partition that a volume is assigned to, click on the partition number and use the arrow buttons.
RecommendationAll log partitions have the same size and the same number of assigned log volumes.
End of the recommendation.To apply your settings, choose Activate.
Deactivating Log Partitioning
Select the database in the explorer tree.
In the context menu of the database, choose
Administration Tasks Change Log Settings... Select Configure Log Partitioning.
Select Deactivate log partitioning.
Specify the number of log queues that you want to use.
Transfer the database to the OFFLINE operational state.
Create a log backup.
To apply your settings, choose Activate.