Results 1 to 5 of 5

Thread: SQL code -923

  1. #1
    Join Date
    Aug 2002
    Location
    Denver,co
    Posts
    8

    Cool Unanswered: SQL code -923

    When running a COBOL program, I am getting the SQLCODE -923 and reason code 00E30302 and TYPE 00000800.

    Help says that DB2 may be down. But that is not the case in here. I rebound the plan just incase, still that doesnt seem to work.

    Can anyone help me resolve the problem please....!! This is veri urgent.


    Thanks,
    Anil

  2. #2
    Join Date
    Aug 2002
    Location
    Texas, USA
    Posts
    11
    Hi Anilc,
    try looking at the output (SFSF, IOF, ???) of the DB2 Master job's JESMSGLG. Jobname is usually db2subsystemidMSTR,, ie: DB2PMSTR. Also check the same output DD in the DB2xDBM1. The reason is that I suspect an unavailable resource is getting you and you might be able to find the resource in one of those two spots.
    ALSO.. think about doing:
    -DISPLAY DATABASE(dbname) SPACENAM(*) RESTRICT
    to see if there are any flags up.
    Hope this helps!
    DB2 Rules.

  3. #3
    Join Date
    Aug 2002
    Location
    Denver,co
    Posts
    8
    That didnt work though. any more ideas?

  4. #4
    Join Date
    Aug 2002
    Location
    Texas, USA
    Posts
    11
    hmmmm,
    The TYPE 800 is a PLAN,
    do:
    SELECT * FROM SYSIBM.SYSPLAN WHERE NAME = 'planname' ;

    Check the VALID column, I suspect you'll find an 'N' there.

    If so, there has to be something in the plan you're using that is unavailable, like a table, index etc...
    You're sure you found nothing on your RESTRICT command?
    Try trimming the plan down to just include the DBRM's you need for what you're doing. This is easy for batch, not as easy for CICS. This might help in determining what's unavailable.

  5. #5
    Join Date
    Aug 2002
    Location
    Denver,co
    Posts
    8
    I created the plan again and it worked. Thanks anyways.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •