According to Bruno Friess:
>
With the command:
> SELECT * FROM actlog WHERE msgno=8352
> you will get the same as a QUERY REQUEST.
>
> With:
> SELECT * FROM actlog WHERE msgno=8323
> you will get a more detailed version, including the Request number.
>

  Thanks, but that's not the solution I'm looking for (searching
  the activity log for message xxx).

  I want a select-command which gives the same information as the
  query request command:
  like: SELECT volume,tape_device,tape_drive,request_waiting_time,...
               FROM tape_request_table

  I think there must be a table in the database which contains the
  information of pending requests.
  May be this table-name isn't documented?


Mit freundlichen Gruessen
Heinz Flemming

-----------------------------------------------------------------------
Heinz Flemming                             flemming AT rz.uni-karlsruhe DOT de
Heinz Flemming                             flemming AT rz.uni-karlsruhe DOT de
Computing Center, University of Karlsruhe
Zirkel 2, P.O.Box 6980
D-76128 Karlsruhe
Germany

phone 0721 - 608 6427                                  fax 0721 - 37550
-----------------------------------------------------------------------
=========================================================================