DBG73110E and BG73117E in the IDB2UIFI utility
search cancel

DBG73110E and BG73117E in the IDB2UIFI utility

book

Article ID: 127901

calendar_today

Updated On: 10-05-2023

Products

SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

Unloading Sysview Performance Management Option for Db2 for z/OS (IDB2) history data
from the history files by using the IDB2UIFI utility.  The unload job failed with the following error messages.
The job failed with RC=8.

DBG73110E ssid 16:13:06 UNABLE TO COMMUNICATE WITH DATA COLLECTOR. DBSUB=ssid
DBG73117E ssid 16:13:06 FAILING REQUEST CODE: POSTHIST AND TYPE: TCLOSE


The execution JCL: 

//IDB2UNLD PROC DBSUB=ssid, DB2 subsystem name.
//*
// DBLOC='ssid', Used w/DBSUB and TESTVER to identify
//* the data collector owning the
//* history files.
// REMEMBR=YES, Keep track of last data unloaded
//* for subsequent UNLOAD=NEW option.
//* REMEMBR=NO, Do not keep track of last data
//* unloaded.
// TESTVER=R180, Option used W/DBSUB and DBLOC to
//* uniquely identify data collector.
//*
// UNLOAD=NEW, Unload only the records added since
//* the last unload using REMEMBER=YES
//* was executed.
//* UNLOAD=ALL, Unload all records in the file(s).
//*
//* UNLDTYP=ALL, Unload both accounting and
//* statistics files.
// UNLDTYP=ACCTG, Unload accounting file only.
//* UNLDTYP=STAT Unload statistics file only.
//*
// UNLDCHD=YES Unload DB2 parent and child records
//* for parallelism threads. NO causes
//* the utility to unload CA SYSVIEW for
//* parallelism summary records only and
//* not the individual parent and child
//* records.
//*-------------------------------------------------------------------
//S01 EXEC PGM=IDB2UIFI,REGION=5M,
// PARM=('/REQ=UNLDHIST,DBSUB=&DBSUB,DBLOC=&DBLOC,',
// 'REMPOS=&REMEMBR,TESTV=&TESTVER,',
// 'UNLD=&UNLOAD,UNLTYP=&UNLDTYP,UNLCHD=&UNLDCHD')
//*
//STEPLIB DD DISP=SHR,
// DSN=hlq.CDBALOAD
//*
//SMFOUT DD DISP=(,CATLG,DELETE), ONLINE HISTORY ARCHIVE
// DSN=hlq.IDB2.HSTACCTG,
// SPACE=(CYL,(200,200),RLSE),
// UNIT=DASD,
// VOL=SER=xxxxxx,
// DCB=(RECFM=VBS,LRECL=32760,BLKSIZE=4096)
//*
//SYSPARMS DD DUMMY
//DBGPRINT DD SYSOUT=9
//SYSUDUMP DD SYSOUT=9
//PTIPARM DD DISP=SHR,
// DSN=hlq.CDBAPARM
//PTILIB DD DISP=SHR,
// DSN=hlq.CDBALOAD
// PEND
//UNLOADS EXEC IDB2UNLD 

Resolution

The TESTVER parameter in the IDB2UIFI job was specified as the following.
TESTVER=R180  (Ssite uses R18.0, it should be specified as R180. If R19.0 is used, it should be specified as R190.)

However, the TESTVER parameter in the IDDCPARMS member was commented out as follows.
(The IDDCPARMS is usually specified in the SYSPARMS DD in the Data Collector.)
* TESTVER=R180

Please see the explanation of the TESTVER parameter in the Reference Guide.
TESTVER=xxxx
Specifies a 1-4 character identifier for a separate unique data collector, which can be started on the same DB2 subsystem as another data collector.
Default: Rxxy, where xx is the version number and y is the release number or space if the release number is zero.
For example, r12.0 has a default TESTVER of R12 , r12.1 has a default TESTVER of R121.

Therefore, "R18" was set for the TESTVER value of your data collector as the default. (because the TESTVER parameter in their IDDCPRMS was commented out.)

You should do one of the following.
1. Specify the TESTVER=R18 in the IDB2UIFI job and rerun the job.
2. Remove the asterisk(*) for the TESTVER=R180 line in the IDDCPARMS and recycle the data collector and rerun the IDB2UIFI job.

Additional info;
The following parameter values should be synchronized between a data collector and the IDB2UIFI job.
DBSUB, DBLOC, TESTVER