Prepare your DB2 Warehouse on
IBM Cloud Pak For Data database by using the provided the database
preparation scripts to help you streamline the process.
Procedure
- Create a DB2
Warehouse instance using the IBM Cloud Pak For
Data 4.0 Web
Console with the following settings:
| Parameter |
Selection |
| Database Name |
TASDB |
| CPU per node for Db2 Warehouse |
12 |
| Memory per node for Db2 Warehouse |
48 |
| Deploy database on dedicated nodes |
Unchecked |
| Storage Structure |
Single location for all data |
| 4K Sector Size |
Checked |
| Oracle compatibility |
Checked |
| Workload |
Operational Analytics |
| Storage class |
ibmc-file-gold-gid
ocs-storagecluster-ceph-rbd
ocs-storagecluster-cephfs |
| Size |
1000 GiB (for ibmc-file-gold-gid) |
Note: If the c-db2wh-xxxxxxxxxxx-db2u-0 pod gets stuck in Readiness Probe in Pod
Events, modify the Stateful set YAML file with tty: False.
- Create a IBM Cloud Pak For
Data user with the same name as the DB2
Warehouse
database and give the user access to the database using Manage
Access.
- Go to the local scripts directory that has command line access to your database
server.
- Find the
c-db2wh-xxxxxxxxxxx-db2u-0 pod running the DB2
Warehouse instance and the intended deployment size of SMALL, MEDIUM, or LARGE ,and run the
following command:
sh prepareDB.sh `c-db2wh-xxxxxxxxxxx-db2u-0` <DB_NAME> <DB_USERNAME> <DEPLOYMENT_SIZE>