Exctract Abends With SQLCODE = -950 ERROR: THE LOCATION NAME SPECIFIED IN THE CONNECT MANY DB2/MVS ON THE SAME PARTITION (Doc ID 2240576.1)

Last updated on APRIL 12, 2017

Applies to:

Oracle GoldenGate - Version 12.2.0.1.0 and later
Information in this document applies to any platform.

Symptoms

Configure  MVS  partition to have another extract with another DB2

Extract Abends with below error:

ERROR: Database operation failed: Couldn't connect to dbq1. ODBC error: SQLSTATE
42705 native database error -950. éDB2 FOR OS/390èéODBC DRIVERè
DATABASE SQLCODE = -950, ERROR: THE LOCATION NAME SPECIFIED IN THE CONNECT
STATEMENT IS INVALID OR NOT LISTED IN THE COMMUNICATIONS DATABASE
X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION
ERRLOC=1:13:2Failed to open data source dbq1 for user .

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms