Hi Basav, can you share the  XA resource definition to understand what that is configured as (you can omit the open string and other sensitive information).

This page:
www.microfocus.com/.../GUID-FB11C86F-FD8D-4DE6-AABF-6F2D17A7F4A1.html

Explains that the DSN command will use SQLServerConnection, and that is the name of an established connection to a SQL Server database. In your screenshot you use "XA/ACB1", as a test can you test with "XA/ACB1" in your JCL, and confirm the result.

Also, why do you use the / character? Is there a specific reason for that in the XA name?

Hi KimH,

Though have used XA/ABC1 and ABC1(DSN name defined in my system) but no luck at all. its keep giving me the same issue.

Thanks,

Basav

Hi Basav,

I tested on my own ED 7.0 instance, region has a XA Resource ID/Name: XB0R, with following job:

//MFTEST JOB 'MFTK',CLASS=A,MSGCLASS=A
//STEP1 EXEC PGM=IKJEFT01,REGION=1024K
//INPUT1 DD DSN=ADDTODB.INPUT,DISP=SHR
//SYSUDUMP DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SYSREPT DD SYSOUT=*
//SYSTSPRT DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(XB0R)
RUN PROGRAM(PGM1) -
PARM(STRINGTOPASS)
//

And do not encounter an issue.
How does your job compare?

When i restart the server , i got below mentioned error in my windows environment. 

CASXO0001S XA Resource Manager initialization error. Resource ABC1 open failed, reason -00003
CASXO0023S Severe error detected in ABC1 XA interface, RM interface disabled

That indicates there is an issue with the connection, as a test can you connect to the database from a 3rd party tool , from the same machine , using the same credentials? That will help ensure you are using the correct details,e.g. in the XA resource's open string.

That indicates there is an issue with the connection, as a test can you connect to the database from a 3rd party tool , from the same machine , using the same credentials? That will help ensure you are using the correct details,e.g. in the XA resource's open string.

I am able to connect to database ABC1.

Does your  XA Resource use a ODBC DSN? Can you use Windows ODBC Administrator and test that DSN connection, result?

Thank you KimH for the expert inputs. Its worked for me after fixing the XA resource open string for the ODBC DSN. Thanks a lot KimH

That is good news, if resolved please consider to mark this post as answered.