MVSFORUMS.com

[moyeenkhan]

When I issue
Address TSO "SUBCOM DSNREXX"
If RC Then nSfRc=RXSUBCOM('ADD','DSNREXX','DSNREXX')
Address DSNREXX "CONNECT" DB2T in a rexx program, I am unable to connect to the DB2 susbsystem DB2T and I am getting a SQL Code of
-923 for CONNECT.

What am I missing here?

[Ravi]

Try also capturing other reason-code and verify/check.

Type QW -923 on your command prompt and you can view the details if you have quick reference.
-923 CONNECTION NOT ESTABLISHED: DB2 condition REASON reason-code, TYPE resource-type, NAME resource-name

Explanation: The connection to DB2 failed for the reason indicated by
condition, which can be any of the following:

- DB2 not up
- DB2 not operational
- DB2 shutdown in progress
- DB2 restricted access mode
- Allocation error
- DB2 - CICS attachment not up
- The object is dependent on facilities of a release of DB2 that is
newer than the release that you are currently running (fall back).

Restricted access might be the most possible reason from REXX to connect. Because its most likely that DB2 is UP & Operational.

fyi
http://www.mvsforums.com/helpboards/viewtopic.php?t=172&highlight=rexx+db2

http://www.mvsforums.com/helpboards/viewtopic.php?t=159&highlight=rexx+db2

http://www.mvsforums.com/helpboards/viewtopic.php?t=797&highlight=rexx+db2

[ofer71]

Hi

Make sure that the DB2 REXX package is bind correctly. You can read more detailes in the manual.

O.
________
Ford HSC engine picture