SQLCODE -923

Manikandan Govindaraj

SQLCODE -923

Hi,

Has anyone faced sqlcode -923 issue.one of the job is abending with SOC1 and failing with sqlcode -923.

 

John Bucaria

SQLCODE -923
(in response to Manikandan Govindaraj)
Hi,

Is there a reason code along with that SQL code?

From: Manikandan Govindaraj <[login to unmask email]>
Sent: Monday, June 03, 2019 10:05 AM
To: [login to unmask email]
Subject: [DB2-L] - SQLCODE -923


Hi,

Has anyone faced sqlcode -923 issue.one of the job is abending with SOC1 and failing with sqlcode -923.



-----End Original Message-----

Manikandan Govindaraj

RE: SQLCODE -923
(in response to John Bucaria)

Hi John,

Please find below the information which I have

PROGRAM NAME -                                                 SQLCODE ------ -923                                                     SQLWARN0 -----                                                          DML SEQUENCE - 60000-1                                                  * * * *  D B 2   E R R O R   T E X T  * * * *                           SQL#60000-1  SQLERR=  -923, SQLSTATE =      , UNKNOWN SQLSTATE TYPE FROM
READY                                                                     DSN      ENDED DUE TO ERROR+                                          USER ABEND CODE 0923  REASON CODE 00000000  
Edited By:
Manikandan Govindaraj[Organization Members] @ Jun 03, 2019 - 08:33 PM (Asia/Calcutta)

John Bucaria

SQLCODE -923
(in response to Manikandan Govindaraj)
Hi,

This SQLcode indicates that one of the Db2 connection errors is present:

* Db2 not up
* Db2 not operational
* Db2shutdown in progress
* Db2 restricted access mode
* Allocation error
* Db2 - CICS attachment not up
* Db2 - CICS ENTRY disabled

Possible causes are:

* The application plan does not exist.
* A required database, table space, table, or index is unavailable.
* Data set allocation failed for a required data set.
* There is insufficient virtual storage.
* The application is trying to execute the plan from a system (environment)
that was restricted when the plan was bound or rebound. Check the
SYSPLSYSTEM table to determine from which systems (for example, IMS or
CICS) the plan can be executed.

* The object is dependent on facilities of a release of Db2 that
is newer than the release that you are currently running (fall
back).

* Db2restarted in light mode

From: Manikandan Govindaraj <[login to unmask email]>
Sent: Monday, June 03, 2019 11:01 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: SQLCODE -923


Hi John,

Please find below the information which I have
PROGRAM NAME - RSB500 SQLCODE ------ -923 SQLWARN0 ----- DML SEQUENCE - 60000-1 * * * * D B 2 E R R O R T E X T * * * * SQL#60000-1 SQLERR= -923, SQLSTATE = , UNKNOWN SQLSTATE TYPE FROM
READY DSN SYSTEM(DBT1) DSN RUN PROGRAM(RSB500) PLAN(TRSB500) PARM('DDRRRRRRRAAJAXR89') DSN ENDED DUE TO ERROR+ USER ABEND CODE 0923 REASON CODE 00000000

-----End Original Message-----

Ray Janes

SQLCODE -923
(in response to John Bucaria)
z/OS? Check the MVS node you connected to (SYSMSG). Make sure that is correct and that is where the DB2 that you wanted to connect to, exists.

From: Bucaria, John <[login to unmask email]>
Sent: Monday, June 3, 2019 10:35 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: SQLCODE -923

Hi,

This SQLcode indicates that one of the Db2 connection errors is present:

* Db2 not up
* Db2 not operational
* Db2shutdown in progress
* Db2 restricted access mode
* Allocation error
* Db2 - CICS attachment not up
* Db2 - CICS ENTRY disabled

Possible causes are:

* The application plan does not exist.
* A required database, table space, table, or index is unavailable.
* Data set allocation failed for a required data set.
* There is insufficient virtual storage.
* The application is trying to execute the plan from a system (environment)
that was restricted when the plan was bound or rebound. Check the
SYSPLSYSTEM table to determine from which systems (for example, IMS or
CICS) the plan can be executed.

* The object is dependent on facilities of a release of Db2 that
is newer than the release that you are currently running (fall
back).

* Db2restarted in light mode

From: Manikandan Govindaraj <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Monday, June 03, 2019 11:01 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: SQLCODE -923


Hi John,

Please find below the information which I have
PROGRAM NAME - RSB500 SQLCODE ------ -923 SQLWARN0 ----- DML SEQUENCE - 60000-1 * * * * D B 2 E R R O R T E X T * * * * SQL#60000-1 SQLERR= -923, SQLSTATE = , UNKNOWN SQLSTATE TYPE FROM
READY DSN SYSTEM(DBT1) DSN RUN PROGRAM(RSB500) PLAN(TRSB500) PARM('DDRRRRRRRAAJAXR89') DSN ENDED DUE TO ERROR+ USER ABEND CODE 0923 REASON CODE 00000000

-----End Original Message-----

-----End Original Message-----

Manikandan Govindaraj

RE: SQLCODE -923
(in response to Ray Janes)

Hi Ray,

Yes it is for DB2 Zos only..It is connected to the right node only.

Kirk Hampton

SQLCODE -923
(in response to Manikandan Govindaraj)
Good day,
I think we would need to know a few more things in order to even give an
educated guess...
1) is this an existing job which suddenly malfunctions, or a new job which
has not run before ?
2) you mentioned a S0C1 abend, does that happen before the -923 SQLCODE, or
after ?
3) check REGiON size of the job or step and tell us that
4) was the program re-compiled/re-linked recently, possibly missing the DB2
stub ?

Thanks,

Kirk Hampton



On Mon, Jun 3, 2019 at 10:00 AM Manikandan Govindaraj <[login to unmask email]>
wrote:

> Hi John,
>
> Please find below the information which I have
> PROGRAM NAME - RSB500
> SQLCODE ------ -923
> SQLWARN0 ----- DML
> SEQUENCE - 60000-1 * * * *
> D B 2 E R R O R T E X T * * * * SQL#60000-1
> SQLERR= -923, SQLSTATE = , UNKNOWN SQLSTATE TYPE FROM
> READY
> DSN SYSTEM(DBT1) DSN
> RUN
> PROGRAM(RSB500) PLAN(TRSB500) PARM('DDRRRRRRRAAJAXR89') DSN
> ENDED DUE TO ERROR+ USER
> ABEND CODE 0923 REASON CODE 00000000
>
> -----End Original Message-----
>