View previous topic :: View next topic
|
Author |
Message |
suzeet
New User
Joined: 16 May 2005 Posts: 54
|
|
|
|
Hi
I am getting the following error while running query in Syncsort
[img]WER468A DB2 QUERY SUPPORT ERROR: CANNOT OPEN PLAN
[/img]
Thanks |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
what does the syncsort manual suggest |
|
Back to top |
|
|
CICS Guy
Senior Member
Joined: 18 Jul 2007 Posts: 2146 Location: At my coffee table
|
|
|
|
SyncSort for z/OS 1.3 Programmer’s Guide wrote: |
WER468A DB2 QUERY SUPPORT ERROR: text
EXPLANATION: The DB2 query operation failed and the sort or copy application will not execute. The message text indicates the condition that caused the failure or the DB2 query requirement that was violated.
•
•
•
• CANNOT OPEN PLAN Insufficient resources were available for DB2 to process the open request. |
|
|
Back to top |
|
|
Alissa Margulies
SYNCSORT Support
Joined: 25 Jul 2007 Posts: 496 Location: USA
|
|
|
|
suzeet wrote: |
Code: |
WER468A DB2 QUERY SUPPORT ERROR: CANNOT OPEN PLAN |
|
This typically means that the first query run was not by someone with BIND ADD authority. You will need to FREE the plan and then re-BIND it. (Your DBA should know how to do this - if not, contact SyncSort Support directly and an analyst will assist you). |
|
Back to top |
|
|
|