Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    1

    Question Unanswered: Strange DB2 error

    Has anyone seen this DB2 error and know how to fix it. Thanks in advance.
    DB2 version: DB2 for OS/390 V5
    Cause: A Cobol program DB2 Select clause.

    (1) I already tried to rebind the program to the plan and got the same results.

    READY
    DSN SYSTEM(DQ01)
    DSN
    RUN PROGRAM(ZVBSL003) PLAN (RSPLANX2)
    PLAN RSPLANX2 NOT AUTHORIZED FOR SUBSYSTEM DQ01 AND AUTH ID R262136
    FEEDBACK - REASON CODE X'00E3001B' TYPE X'00000800' RESOURCE NAME- RSPLANX2
    DSN
    END
    READY
    END

    DB2 SQLCODE ==> -923
    Last edited by DB2_fixer_upper; 04-13-04 at 23:01.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    00E3001B

    Explanation: A plan could not be executed because the system from which you are attempting to run is disabled or unknown. The system type might be unknown if the attach library that you are using is from a previous release of DB2 that does not support the ENABLE and DISABLE options of the bind operation. This abend reason code is issued by the following CSECT: DSNTAAL

    System Action: The plan is not allocated.

    System Programmer Response: Refer to the SYSIBM.SYSPLSYSTEM table to determine the systems from which the plan can be executed, or correct the attach library.

    ------------------------------------------
    Keep in mind that plans can be authorized to be executed by only specified sub-system attaches (TSO, CICS, IMS, etc.). A plan that is authorized only to be executed by the DB2-CICS attach, cannot be be run under DB2-TSO batch attach.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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