When I use XCV2ODBC or migrate history records, I receive a connection error:
SQLAllocHandle(DBC) rc = -1
SQLAllocHandle failed, 0, {DB2 FOR OS/390}{ODBC DRIVER} SQLSTATE=58004 ERRLOC=2:165:9
CAF "CONNECT" failed using DB2 system:DSN
RC=0c and REASON=00f30006
IBM DB2
CA XCOM Data Transport
XCMVS
This is the explanation from the IBM DB2 doc for reason code x'00F30006' from the IBM Knowledge Center:
00F30006
Explanation
A failure occurred while processing the 'Subsystem Name' during connection processing. In the abend case, connection processing failed when accessing the 'Subsystem Name' in the caller's PSW key. In the nonabend case, MVS™ was unable to locate a DB2® subsystem with the specified name.
In other words - the DB2 subsystem you are trying to connect to cannot be found in your z/OS system. This is a database configuration problem
Link to the XCOM documentation on our docops site: XCV2ODBC - Migrate VSAM History Databases