Converting a non-partitioned database to a multipartitioned database on MS Windows

The second method, besides creating a new multipartitioned database from scratch, is to convert an existent non-partitioned database to a multipartitioned one. In this recipe, we will convert the NAV database to multipartitioned, using a single server running the Windows 7 SP1 Enterprise Edition operating system, named node1. Also, we will cover some existent particularities of multipartitioned database systems available only on the MS Windows platforms.

Getting ready

In this recipe, we will add two new database partitions. In this way, we will have a total of three database partitions. A new database partition group, NAVDATAGRP, will be created and populated by using a particular method that involves data migration from the default IBMDEFAULTGROUP database partition group to NAVDATAGR database partition group.

How to do it...

In this recipe, we will use Control Center combined with the command line. For this...