"DSNHATTR FOR READ ONLY FETCH FIRST 50 ROWS ONLY WITH EXTENDED INDICATORS" on R/SQLTEXT of an active distributed DISTSERV thread.
Article ID: 279679
Updated On:
Products
SYSVIEW Performance Management Option for DB2 for z/OS
Issue/Introduction
Seeing the message "DSNHATTR FOR READ ONLY FETCH FIRST 50 ROWS ONLY WITH EXTENDED INDICATORS" on SQL TEXT screen (R/SQLTEXT) of an active distributed DISTSERV thread. The query does not have any fetch only clauses, what does this message mean and what is generating it? The captured query is displayed below this message on the screen.
Environment
DB2 for Z/OS
Cause
The Message DSNHATTR FOR READ ONLY comes from the PREPARE statement for the SQL query.
Resolution
The DSNHATTR FOR READ ONLY comes from the PREPARE statement for the SQL query, if the PREPARE statement uses the ATTRIBUTES clause.
The IFCID 124 record, which is formatted by the SQLTEXT screen, includes any attributes supplied during the PREPARE.
Additional Information
IFCID Records in Alphabetical Order
IQL Record Name IFCID Type Description
CURR-SQL 0124 Synchronous Current SQL statement data.
==========
(124) CURR-SQL
ATTRIBUTE-STRING
Specifies the PREPARE attributes string. This field varies in length and contains the complete name.
IBM Db2 Field Name: QW01248_D
Feedback
Yes
No
Powered by
