Hi!
We are running DB2 V8 on z/OS in compatibility mode. There is one
specific query (embedded as static SQL in a COBOL program) that causes
the bind job to abend when we use the DEGREE(ANY) option. The bind
works fine with DEGREE(1). The bind job binds the DBRM into a plan.
The query uses parameter markers. If we replace the parameter markers
with literals in the query, the bind goes through without problems.
Also, if we change the definition of the view referenced by the query,
we find that the problem goes away for certain view definitions. After
playing with the view definition for some time, it looks to us that the
problem occurs whenever the access path chosen for the query includes
(CP) parallel access for one of the tables involved (ACCESS_DEGREE = 0
in the plan table entry).
If anyone came across a similar problem, please advise.
Thanks and Regards,
Venkata