Install the DBM Data Service for DB2 product over several LPARs
Article ID: 277654
Updated On:
Products
Issue/Introduction
In the MTCDSC02 Job to install the DBM Data Service for DB2 product there is the following text:
>>>
PREREQUISITE:
Before running this job, ensure that the runtime file system for
the DBM Data Service home directory is mounted. We recommend
that you add the USS path for the home directory to BPXPRMxx
members in SYS1.PARMLIB to ensure that the file system is
automatically mounted after future IPLs.
<<<
How the DBM Data Service home directory has to be created and mounted in the LPAR?.
Normally there is only one SMP/E install in the LPAR and the SMP/E datasets are deployed to the other LPARs from there.
Is there any sample Job to deploy the USS files needed for the DBM Data Service for DB2 product over the other LPARs?.
Resolution
The next steps can be run to deploy the USS files needed to start the DBM Data Service for DB2 product in the other LPARs.
The user running the Job should have sufficient USS permissions and understanding to complete the following.
Every site has different standards for these activities.
1. Copy the Db2 Tools HLQ.CDBAZFS dataset from the SMP/E LPAR to the LPAR where DBM Data Service for DB2 product needs to be hosted.
One DBM Data Service for DB2 instance is sufficient as long as ESM are configured to work the same way.
2. Mount the HLQ.CDBAZFS dataset using something like below.
//MOUNTJCL JOB 123450000,'DBM DS MOUNT',MSGLEVEL=(1,1),
// MSGCLASS=A,CLASS=A,REGION=0M
/*JOBPARM SYSAFF=LPAR
//*-------------------------------------------------------------------
//* 1) Create Mount Point 2)Mount and 3) Set permissions
//*-------------------------------------------------------------------
//MKDIR EXEC PGM=BPXBATCH,REGION=0M
//STDOUT DD SYSOUT=*
//STDPARM DD *
sh set -x;
umask 0002;
mkdir -p /cai/dbmgmt/;
//*-------------------------------------------------------------------
//MOUNT EXEC PGM=IKJEFT01,REGION=0M,DYNAMNBR=50
//SYSTSPRT DD SYSOUT=*
//SYSTSOUT DD SYSOUT=*
//SYSTSIN DD *
MOUNT FILESYSTEM('HLQ.CDBAZFS') +
TYPE(ZFS) MODE(RDWR) +
PARM('AGGRGROW') +
MOUNTPOINT('/cai/dbmgmt/')
//*-------------------------------------------------------------------
//CHMOD EXEC PGM=BPXBATCH,REGION=0M
//STDOUT DD SYSOUT=*
//STDPARM DD *
sh set -x;
chmod -R 775 /cai/dbmgmt/;
If mount is successful the /cai/dbmgmt/ directory in USS should look something like (contents may vary slight based on maintenance level).
Filename
---------------
CA
DBT_hold.sh
DBT_hold.txt
DBT_Hold.jar
IDB2
PDT
PXM
SQ2_hold.sh
3. Open the Post-Install Task Config Utility from the LPAR where DBM Data Service for DB2 product is expected to be started.
4. Use DBM DS home directory as /cai/dbmgmt/PXM/ds and MTC DBM home directory to /cai/dbmgmt/PXM/ui while configuring.
If the MVS datasets are being shared across LPARs, it is recommended to copy the HLQ.CDBAZFS dataset instead of trying to mount same SMP/E HLQ.CDBAZFS dataset on multiple LPARs. The same SMP/E HLQ.CDBAZFS dataset on multiple LPARs will give you unexpected results.
After the USS files have been deployed there are two choices for the MOUNT command.
1. The MOUNT command can be included at the start of the JCL that is used to start the DBM DS started task.
This will ensure that the ZFS file is mounted before execution.
2. The SYS1.PARMLIB(BPXPRMxx) can be updated with the MOUNT command to mount the ZFS file when the LPAR is IPLed.
Feedback
