IBM Support

Finding the Attributes of an Standard Data Queue

Question & Answer


Question

How do you find out the Attributes of a Standard Data Queue?

Cause

The DATA_QUEUE_INFO view SQL Service can be used to find the attributes of a data queue.
 
Authorization: Rows are returned for data queues when the caller has execute authority to the data queue library and read authority to the data queue.
 
 

Using the Run SQL Scripts tool, run the statement:  

SELECT DATA_QUEUE_LIBRARY,
       DATA_QUEUE_NAME,
       MAXIMUM_MESSAGE_LENGTH,
       SEQUENCE,
       KEY_LENGTH,
       INCLUDE_SENDER_ID,
       INITIAL_MESSAGE_ALLOCATION,
       SPECIFIED_MAXIMUM_MESSAGES,
       FORCE,
       AUTOMATIC_RECLAIM
    FROM QSYS2.DATA_QUEUE_INFO
    WHERE DATA_QUEUE_NAME = 'QSRVMON'
          AND DATA_QUEUE_LIBRARY = 'QSERVICE'
          AND DATA_QUEUE_TYPE = 'STANDARD'

 

Note:  

  • Modify the SQL statement to specify the name and library of the data queue by changing the Where portion of the SQL.  In the example above the queue name is in red 'QSRVMON' and the queue library is also in red 'QSERVICE'.  Replace with your data queue name and library and make sure it is in upper case.

 

Report produced by the sample SQL:

image 4297

 

The DATA_QUEUE_INFO view can also be used to display other data queue information including data for DDM data queues.

More information on the DATA_QUEUE_INFO view can be found:
 
 
 

[{"Type":"MASTER","Line of Business":{"code":"LOB68","label":"Power HW"},"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000000CHAAA2","label":"Operating System"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.3.0;7.4.0"}]

Document Information

Modified date:
02 December 2025

UID

ibm16233322

Page Feedback