TAA Tools
CVTQHST       CONVERT QHST FILE TO NORMAL DATA BASE FILE    TAAHSTA

The Convert QHST to a  file command converts one or more  QHST files to
a  normal  data  base file.    You  must  have  *USE authority  to  the
TAACVTQHST Authorization List.

The  system  maintains  a log  named  QHST for  all  important messages
which have occurred.   All messages  sent to QSYSOPR are  automatically
logged to  QHST as  well as other  significant events such  as security
violations.  A user application can also send a message to QHST.

When  the log becomes  full (based  on the QHSTLOGSIZ  system value), a
data base  file is  automatically created  in QSYS.   Each  file has  a
unique name beginning with  QHST followed by a 5  digit julian date and
a  one character letter  (A-Z) to denote  separate logs created  on the
same day.

The system does not delete the files.   You must delete each file  when
no longer needed.   See the TAA Tool  DLTQHST.  You can  write programs
to analyze the messages in a QHST data base file.

Each QHST  file is a series  of 142 byte records which  is described in
the  Message  Handling  chapter  of the  CL  Programmers  Guide.   Each
record is  distinguished by  a binary  record count  in positions  9-10
which starts  with 1  for each  message and continues  for as  many 142
byte  records  as are  required.   The  first record  contains standard
information.   The  second  record contains  up  to 132  bytes  of  the
message text (message  text greater than 132 bytes is  truncated).  The
second record  may also contain part of the  message data.  The message
data may overflow onto the following records.

The file  is difficult  to process  with a  HLL program.   The  CVTQHST
command converts the file  into an externally described data  base file
(QHSTP)  which can  be  more easily  processed.   QHSTP  is  created as
SIZE(5000000 10000 10).

The  message  data field  in  QHSTP is  defined  as 264  bytes  and the
information varies based  on the message ID.   If message data  exceeds
264  bytes, it  is  truncated and  no  error occurs.    To process  the
message  data  for a  specific message  ID, you  must  be aware  of the
format of the message data.   The TAA command DSPMSGDTA can be used  to
display the format such as:

       DSPMSGDTA  MSGID(CPF1164)

A typical command would be:

       CVTQHST    QHSTFILE(QHST05240A) QHSTPLIB(xxx) REPLACE(*NO)

Selection criteria exists for:

   JOB           All  jobs,  a  generic  job   ,  or  a  specific  job.
                 Defaults to *ALL.

   USER          All  users,  a  generic  name,  or  a  specific  user.
                 Defaults to *ALL.

   MSGID         All messages  or a  list  of up  to 40  specific  IDs.
                 Defaults to *ALL.

   FROMDATE      The From Date.   Only those QHST records in  the range
                 of  the From Date/Time  and the  To Date/Time  will be
                 output.    The  default is  *BEGIN  meaning  the first
                 QHST file is considered.

   TODATE        The To  Date.   The  default  is *TODAY  meaning  that
                 every record  within the  range of the  From Date/Time
                 and current date/To Time will be output.

   FROMTIME      The  From Time.  Only those  QHST records in the range
                 of the From  Date/Time and  the To  Date/Time will  be
                 output.   The  default  is  *BEGIN meaning  the  first
                 QHST file is considered.

   TOTIME        The  To Time.   The default  is *END meaning  the last
                 time on the To date.

If no records are converted, the TAA9894 escape message is sent.

The CVTQHST  command  adopts  the Security  Officer  profile  (See  the
Security Considerations  section).   To  use the  command  you must  be
authorized  to  the  TAACVTQHST  authorization  list (or  have  *ALLOBJ
authority).

CVTQHST escape messages you can monitor for
-------------------------------------------

      TAA9893    From Date cannot be greater than the current date.
      TAA9894    No records written to QHSTP.  Check selection parms.

Command parameters                                    *CMD
------------------

   QHSTFILE      The  qualified file name to be  converted.  A name may
                 be specified,  or  *ALL  (all QHST  files),  or  *LAST
                 (the  last QHST  file)  The library  name defaults  to
                 *LIBL  and  would  normally be  used  (the  QHST files
                 exist in  QSYS).    The  intent of  using  a  specific
                 library  name   allows  for   simplified  testing   of
                 smaller files.

   QHSTPLIB      The library  containing the QHSTP file.   *LIBL is the
                 default.  If the file  does not exist, a library  must
                 be  specified.   If  a library  is  specified and  the
                 QHSTP   file   does   not   exist,   it   is   created
                 automatically.

   QHSTPMBR      The  member  for  the  QHSTP  file  to  be  use.   The
                 default is *FIRST.

   REPLACE       A  *YES/*NO value  which  controls whether  the  QHSTP
                 file is replaced.

   JOB           Whether  to select  records for  all jobs,  a specific
                 job,  or a generic job  name.  The default  is *ALL to
                 select all job names.

   USER          Whether to select  records for  all users, a  specific
                 user, or  a generic  user name.   The default  is *ALL
                 to select all user names.

   MSGID         Whether to  convert all or a  list of specific message
                 IDs.  The default is *ALL for all message IDs.

                 A list of up to 40  message IDs (such as CPF1164)  may
                 be entered to convert only those message IDs.

   FROMDATE      The From  Date of the  QHSTn data to  be output.   The
                 default  is  *BEGIN meaning  the  first  QHST file  is
                 considered.

                 Only  those  QHST records  in  the range  of  the From
                 Date/Time and To Date/Time will be output.

                 *TODAY may be entered for the current date.

                 If a date  (not a special  value) is entered, it  must
                 be in job format.

                 The  From  Date/Time must  be  greater  than or  equal
                 than the To Date/Time.

                 The  From  Date must  be equal  or  less than  the the
                 current date.

   TODATE        The To  Date of  the QHSTn  data to  be  output.   The
                 default  is *TODAY  meaning that  every record  within
                 the  range  of  the  From  Date/Time  and the  current
                 date/time will be output.

                 If a date (not  a special value)  is entered, it  must
                 be in job format.

   FROMTIME      The From  Time of the  QHSTn data to  be output.   The
                 default  is *BEGIN meaning  the beginning time  of the
                 FROMDATE.    A time  may be  entered in  HHMMSS format
                 with our without time separators.

   TOTIME        The To  Time of  the  QHSTn data  to be  output.   The
                 default is  *END meaning the last time  of the TODATE.
                 A  time  may  be entered  in  HHMMSS  format  with our
                 without time separators.

File format
-----------

The file name that is output is QHSTP.

The model file used is TAAHSTAP with a format name of QHSTR.

To see the field names used:

       DSPFMT    TAAHSTAP

Security considerations
-----------------------

The command CVTQHST  and the TAAHSTAC  CL program are  created so  they
may only  be executed  by a user  who is  authorized to  the TAACVTQHST
authorization list.

Prerequisites
-------------

The following TAA Tools must be on your system:

           CHKOBJ3      Check object 3
           DUPFILFMT    Duplicate file format
           EDTVAR       Edit variable
           EXTLST2      Extract list 2
           CHKGENERC    Check generic
           RTVDAT       Retrieve date
           SNDESCMSG    Send escape message
           SNDCOMPMSG   Send completion message

Implementation
--------------

The  tool  is ready  to  use, but  a  user must  be  authorized  to the
TAACVTQHST authorization list.   To  authorize a user,  use EDTAUTL  or
specify:

      ADDAUTLE     AUTL(TAACVTQHST) USER(xxx) AUT(*USE)

Objects used by the tool
------------------------

   Object        Type       Attribute      Src member     Src file
   ------        -----      ---------      ----------     -----------

   CVTQHST       *CMD                      TAAHSTA        QATTCMD
   TAAHSTAP      *FILE         PF          TAAHSTAP       QATTDDS
   TAAHSTAC      *PGM          CLP         TAAHSTAC       QATTCL
   TAAHSTAR      *PGM          RPG         TAAHSTAR       QATTRPG
					

Added to TAA Productivity tools April 1, 1995


Home Page Up to Top