Creating and populating the database for DB2 for z/OS for the Dynamic Workload Console

Instructions for creating and populating the database for DB2 for z/OS for Dynamic Workload Console

Ensure a DB2 for z/OS database is installed.

Creating and populating the Dynamic Workload Console database

You can perform a typical database procedure, as described in the following scenarios, or you can customize the database parameters, as described in FAQ - Database customizations.

DB2 for z/OS requires a specific procedure in which you first create the database and then create and populate the database tables. To simplify the database creation, a sample JCL named EQQINDWC is provided with APAR PH22448 containing the specifics for creating the Dynamic Workload Console database. The database administrator can use this file to create the database. After the database has been created, you can proceed to create and populate the database tables.

Note: If you use Db2 for z/OS with Dynamic Workload Console version 10.2.4 or later, transfer the drivers in binary mode from your Db2 for z/OS installation to a directory of your choice. Specify this directory using the dbdriverspath parameter when running the configuredb or dwcinst scripts.

You can run the configureDb command specifying a typical set of parameters. In this case, default values are used for all remaining parameters.

For more information about all parameters and supported values of the configureDb command, see Database configuration - configureDb script.

If you need to modify any of the default values, edit the configureDb<database_vendor>.properties file, but do not modify the configureDb<database_vendor>.template file located in the same path.

To create and populate the Dynamic Workload Console database and schema for DB2 for z/OS, perform the following steps:

From the SEQQSAMP library, edit the EQQINDWC sample JCL as required.

Note: The EQQINDWC sample JCL is provided with the APAR PH22448. If you did not install this APAR, create a JCL named EQQINDWC that looks like the following example:

//JOBCARD                                                                
//********************************************************************/  
//*                                                                  */  
//*  SECURITY CLASSIFICATION:                                        */  
//*  Licensed Materials - Property of HCL 5698-T08                   */  
//*  Copyright HCL Technologies Ltd. 2020 All rights reserved.       */  
//*  US Government Users Restricted Rights - Use, duplication        */  
//*  or disclosure restricted by GSA ADP Schedule Contract           */  
//*                                                                  */  
//* CREATES DB2 STORAGE GROUP AND DATABASE for DWC                   */  
//* NOTE1:You must tailor this JCL sample to conform to              */  
//*       installation standards defined at your location.           */  
//*       - Add a JOB card                                           */  
//*       - Change following DB/2 values according to your           */  
//*         current environment:                                     */  
//*         - DSN.V11R1M0.SDSNLOAD      DB/2 library                 */  
//*         - DSN111.RUNLIB.LOAD        DB/2 run library             */  
//*         - DBB1                      DB/2 system name             */  
//*         - DSNTIA11                  DB/2 DSNTIAD plan name       */  
//*         - volname                   volume name                  */  
//*         - catname                   catalog name                 */  
//*       - Change all the occurrences of                            */  
//*         TWSSDWC if you need a storage group with a different name*/  
//*                                                                  */  
//* Flag Reason   Rlse   Date   Origin Flag Description              */    
//* ---- -------- ------ ------ ------ ----------------------------  */    
//* $EGE=PH22448  950    200121 ZLIB: DB2 on zLiberty                */    
//* $ETA=PH53936  101 220418 MR: EQQINDWC MEMBER OF SEQQSAMP FOR     */    
//*                              CREATION OF DB2 DATABASE FOR        */    
//*                              DWCFAILS FOR DB2 V12R1M504 OR       */    
//*                              higher levels                       */    
//********************************************************************/    
//EQQINDWC EXEC PGM=IKJEFT01,DYNAMNBR=20                                   
//STEPLIB  DD  DISP=SHR,DSN=DSN.V11R1M0.SDSNLOAD                           
//SYSTSPRT DD  SYSOUT=*                                                    
//SYSTSIN  DD  *                                                           
  DSN SYSTEM(DBB1)                                                         
  RUN PROGRAM(DSNTIAD) PLAN(DSNTIA11) LIB('DSN111.RUNLIB.LOAD')            
//SYSPRINT DD  SYSOUT=*                                                    
//SYSUDUMP DD  SYSOUT=*                                                    
//SYSIN    DD *                                                            
SET CURRENT APPLICATION COMPATIBILITY = 'V10R1';                           
CREATE STOGROUP TWSSDWC VOLUMES(volname) VCAT catname;                     
CREATE DATABASE DWC                                                        
BUFFERPOOL BP0                                                             
INDEXBP BP16K0                                                             
STOGROUP TWSSDWC                                                           
CCSID UNICODE;  
COMMIT;

Instruct the DB2 for z/OS administrator to create the DB2 for z/OS user on the server hosting the DB2 for z/OS database. You will then specify this user with the dbuser parameter when creating and populating the database with the configureDb command on the Dynamic Workload Console. When you run the configureDb command, this user is automatically granted access to the Dynamic Workload Console tables on the database server.
On the server where you plan to install the Dynamic Workload Console, browse to the directory where you extracted the Dynamic Workload Console image.
Type the following command to create and populate the Dynamic Workload Console database tables with typical settings:
On Windows operating systems
```
cscript configureDb.vbs --rdbmstype DB2Z --dbhostname DB_hostname
--dbport db_port --dbname db_name --dbuser db_user
--dbadminuser DB_admin_user --dbadminuserpw DB_admin_pwd
--zlocationname zOS_location_containing_db --zbufferpoolname buffer_pool_in_zOS_location
```
On UNIX operating systems
```
./configureDb.sh --rdbmstype DB2Z --dbhostname DB_hostname
--dbport db_port --dbname db_name --dbuser db_user
--dbadminuser DB_admin_user --dbadminuserpw DB_admin_pwd
--zlocationname zOS_location_containing_db --zbufferpoolname buffer_pool_in_zOS_location
```
On z/OS operating systems
```
./configureDb.sh --rdbmstype DB2Z --dbhostname DB_hostname
--dbport db_port --dbname db_name --dbuser db_user
--dbadminuser DB_admin_user --dbadminuserpw DB_admin_pwd
--zlocationname zOS_location_containing_db --zbufferpoolname buffer_pool_in_zOS_location
```
where:

--rdbmstype

The database vendor.

--dbhostname db_hostname

The host name or IP address of database server.

--dbport db_port

The port of the database server.

--dbname db_name

The name of the Dynamic Workload Console database.

--dbuser db_user

The database user you must create before running the configureDb command. When you run the configureDb command, this user is automatically granted access to the Dynamic Workload Console tables on the database server.

--dbadminuser db_admin_user

The database administrator user that creates the Dynamic Workload Console schema objects on the database server.

--dbadminuserpw db_admin_password

The password of the DB administrator user that creates the Dynamic Workload Console schema objects on the database server. Special characters are not supported.

--zlocationname zos_location_containing_db

The name of an already existing location in the z/OS environment that will contain the new database. The default value is LOC1.

--zbufferpoolname buffer_pool_in zos_location

The name of an already existing buffer pool created in the location specified by -zlocationname. The default value is BP32K.
Note: The following parameters specified with the configureDb command are also required when installing the Dynamic Workload Console and their values must be the same:
- --rdbmstype
- --dbhostname
- --dbport
- --dbname
- --dbuser
- --zlocationname

You have now successfully created and populated the Dynamic Workload Console database.

For more information about all parameters and supported values of the configureDb command, see Database configuration - configureDb script.

You can now proceed to Installing the Dynamic Workload Console.