If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Strange DB2 error

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 04-13-04, 21:38
DB2_fixer_upper DB2_fixer_upper is offline
Registered User
 
Join Date: Apr 2004
Posts: 1
Question 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 22:01.
Reply With Quote
  #2 (permalink)  
Old 04-13-04, 22:35
Marcus_A Marcus_A is offline
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,198
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
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On