Preparing the Db2 Warehouse on IBM Cloud Pak For Data database

Prepare your IBM® Db2® Warehouse on IBM Cloud Pak® For Data database by using the provided the database preparation scripts to help you streamline the process.

Before you begin

Download the database preparation scripts.

Procedure

Create a IBM 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
Credentials	Generate a Kubernetes secret
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.
```
cd /<path_to_scripts>
```
Run the following command to prepare the database:
```
sh prepareDB.sh `c-db2wh-xxxxxxxxxxx-db2u-0` <DB_NAME> <DB_USERNAME> <DEPLOYMENT_SIZE>
```
Where:
- c-db2wh-xxxxxxxxxxx-db2u-0 is the name of the pod that runs the Db2 Warehouse instance.
- <DEPLOYMENT_SIZE> is the intended deployment size of SMALL, MEDIUM, or LARGE.