|
Problem IC70222
|
Status: Closed |
ERROR SQL30020N REPORTED WHEN STORED PROCEDURE ON Z/OS REFERENCI NG A INSENSTIVE SCROLLABLE CURSOR IN A SELECT QUERY IS CALLED |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problem description: |
When the SP referencing a insensitive scrollable cursor on z/os
is called , the o/p may be incomplete and clp client might
report SQL30020N error. The problem is seen when the size of
rows is large and z/os server returns the partial rowset in the
first buffer. When csm drives a fecth request for fetching the
remaining rows on the continue query(CNTQRY), it sends a request
for 1 row fetch. But accroding to DRDA rules, server expects the
number to be equal to pending rows that are unfetched on the
server.
A previous CNTQRY command specified a QRYROWSET parameter, which
indicated the number of rows to be returned as a rowset. Because
of the blocking limits in effect with the requester, only a
partial rowset was returned to the requester. Some rows in the
requested rowset are still unfetched and are pending. The DRDA
rules require that this subsequent CNTQRY command must either:
Specify a QRYROWSET value that is equal to the number of pending
rows in the rowset. Reset the query blocks from the pending
rowset.
The CNTQRY command did not specify the QRYRSTBLK parameter to
reset the query blocks, so this command is assumed to completes
the pending rowset. Because the requested QRYROWSET value does
not equal the number of pending rows in the rowset that was
requested by the previous CNTQRY, a DRDA exception occured. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All users *
****************************************************************
* PROBLEM DESCRIPTION: *
* ERROR SQL30020N REPORTED WHEN STORED PROCEDURE ON Z/OS *
* REFERENCING A INSENSTIVE SCROLLABLE CURSOR IN A SELECT QUERY *
* IS CALLED *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 v9.5 FP7. *
**************************************************************** |
| Local Fix: |
N/A |
| available fix packs: |
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Fixed in DB2 v9.5 FP7. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 27.07.2010
18.10.2010
18.10.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.FP7
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.1.0.7
|
 |
| 9.5.0.7
|
|
