Please enable JavaScript to view this site.

Once you have estimated the potential size of the transient data storage pool you must create a dedicated filesystem. That filesystem will then be assigned a mount point that will be referenced in the CDCStore configuration (.cab) file. As discussed previously this filesystem need not be large but it is critical that it be dedicated for this purpose because the Storage agent will create and remove files as needed based on the definition of the storage pool. It will expect the space it has been told it can use to be available when needed and will terminate the capture if it is not. Double the amount of space you have estimated will be required. That will allow you to adjust the number of blocks and files in your configuration without having to add an additional mount point and filesystem.

 

JCL similar to the following sample member ALLOCZFS included in the distribution should be used to create the Transient Data Filesystem for the Db2 z/OS Capture Agent and mount it at the directory created previously, /home/sqdata/db2cdc1/data. The JCL should be edited to conform to the operating environment.

//ALLOCZFS JOB 1,MSGLEVEL=(1,1),MSGCLASS=H,NOTIFY=&SYSUID

//*

//*--------------------------------------------------------------------

//*  Allocate Transient Storage Filesystem for DB2 z/OS Capture Agent

//*--------------------------------------------------------------------

//*   Required parameters (set below):

//*       ZFS - the name of the VSAM cluster aggregate

//*       MB  - the number of megabytes to allocate to the cluster

//*       DIR - the directory name of the ZFS mountpoint

//*             which was previously created using member ALLOCZDR

//*       SMS - the SMS class to be assigned to the cluster

//*       VOL - the DASD volume(s) used for cluster allocation

//*

//*   Notes:

//*     1) You must be a UID(0) User to Run this Job

//*

//*     2) This job contains six (6) steps as follows:

//*         - Unmount the existing file system - optional

//*         - Define the ZFS filesystem VSAM cluster aggregate

//*         - Format the ZFS filesystem aggregate

//*         - Format the ZFS filesystem aggregate

//*         - Create the mountpoint directory

//*         - Mount the ZFS filesystem

//*--------------------------------------------------------------------

//*

// EXPORT SYMLIST=(ZFS,MB,DIR,SMS,VOL)

//     SET ZFS=SQDATA.TESTZFS

//     SET MB=2049

//     SET DIR='/home/sqdata/db2cdc1/data'

//     SET SMS=DBCLASS

//     SET VOL=WRK101

//*

//*------------------------------------------------------------------

//*   Optional - Unmount the Existing File System

//*------------------------------------------------------------------

//*UNMOUNT  EXEC PGM=IKJEFT01,DYNAMNBR=75,REGION=8M

//*SYSPRINT DD SYSOUT=*

//*SYSTSPRT DD SYSOUT=*

//*SYSTERM  DD DUMMY

//*SYSUADS  DD DSN=SYS1.UADS,DISP=SHR

//*SYSLBC   DD DSN=SYS1.BRODCAST,DISP=SHR

//*SYSTSIN  DD *,SYMBOLS=JCLONLY

//*   UNMOUNT FILESYSTEM('&ZFS')

/*

//*------------------------------------------------------------------

//*        Define the ZFS filesystem VSAM cluster aggregate

//*------------------------------------------------------------------

//DEFINE   EXEC PGM=IDCAMS

//SYSPRINT DD SYSOUT=*

//SYSOUT   DD SYSOUT=*

//SYSIN    DD *,SYMBOLS=JCLONLY

DELETE &ZFS CLUSTER

SET MAXCC=0

DEFINE CLUSTER (NAME(&ZFS)                       -

                VOLUME(&VOL)                     -

                STORCLAS(&SMS)                   -

                LINEAR                           -

                MB(&MB 0)                        -

                SHAREOPTIONS(3))

/*

//*------------------------------------------------------------------

//*        Format the ZFS Filesystem Aggregate

//*------------------------------------------------------------------

//FORMAT   EXEC PGM=IOEAGFMT,REGION=0M,PARM=('-aggregate &ZFS -compat')

//SYSPRINT DD SYSOUT=*

//STDOUT   DD SYSOUT=*

//STDERR   DD SYSOUT=*

/*

//*--------------------------------------------------------------------

//*       Create the Mountpoint Directory

//*--------------------------------------------------------------------

//CREATDIR EXEC PGM=IKJEFT01,REGION=64M,DYNAMNBR=99,COND=(0,LT)

//SYSTSPRT DD SYSOUT=*

//SYSTSIN  DD *,SYMBOLS=JCLONLY

 PROFILE MSGID WTPMSG

 MKDIR '&DIR'  MODE(7,7,5)

/*

//*------------------------------------------------------------------

//*       Mount the ZFS Filesystem

//*------------------------------------------------------------------

//MOUNT    EXEC PGM=IKJEFT01,DYNAMNBR=75,REGION=8M,COND=(0,LT)

//SYSPRINT DD SYSOUT=*

//SYSTSPRT DD SYSOUT=*

//SYSTERM  DD DUMMY

//SYSUADS  DD DSN=SYS1.UADS,DISP=SHR

//SYSLBC   DD DSN=SYS1.BRODCAST,DISP=SHR

//SYSTSIN  DD *,SYMBOLS=JCLONLY

  MOUNT FILESYSTEM('&ZFS')              -

        MOUNTPOINT('&DIR')              -

        TYPE(ZFS)                       -

        MODE(RDWR)

/*

You can verify the space allocated, in use and available at the OMVS command prompt after first navigating to the directory above the Transient "Data" directory using the following commands:

Commands

$ cd /u/sqdata/db2cdc/

 

$ df -mP data <--- the directory for transient data with a dedicated mount point

 

Results

Filesystem           1M-blocks        Used  Available  Capacity Mounted on

WWCVCA.USER.ZFS           1455         758        697       53% /u/wwcvca

 

Note, Numbers above are in MB