Create zFS transient data filesystem - connect_cdc_sqdata - Latest

Connect CDC (SQData) Change Data Capture

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (SQData)
Version
Latest
Language
English
Product name
Connect CDC (SQData)
Title
Connect CDC (SQData) Change Data Capture
Copyright
2024
First publish date
2000
Last edition
2024-09-13
Last publish date
2024-09-13T19:10:49.846957

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/db2cdc/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/db2cdc/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.