Thread: CICS

CICS/DB2 SQLCODE -923 - what did I forget to define?

Started by Anita • user3 replies190 viewsLast activity 1 month ago

Post #1

0 votes

Anita

Reputation118

Posts: 23

Joined: 05/29/2025, 12:45 PM

Posted: 08/02/2026, 12:54 PM

Program, map, and transaction are installed. Hit Enter to hit DB2 and get SQLCODE -923 / SQLSTATE 57015.

Been away from mainframe a while. Is this a DB2CONN / DB2ENTRY thing, or is DB2 itself down?

Post #2

1 votes

Dave

Reputation356

Posts: 25

Joined: 07/21/2024, 02:55 PM

Posted: 08/02/2026, 02:54 PM

Read the reason code hanging off the -923. Common ones: DB2 not up, CICS-DB2 attachment not up, ENTRY disabled.

If you never did CEDA DEFINE for DB2CONN and DB2ENTRY (and maybe DB2TRAN), CICS has no idea which DB2 subsystem to talk to. Install those, then retry.

Post #3

0 votes

Anita

Reputation118

Posts: 23

Joined: 05/29/2025, 12:45 PM

Posted: 08/03/2026, 04:54 PM

Missing DB2CONN. Defined and installed it. SQL runs now.

You must be signed in to reply to this thread

Back to Forums

CICS/DB2 SQLCODE -923 - what did I forget to define? | MainframeMaster Forum