ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

How to get 6 month history log?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to get 6 month history log?

    Hi All,

    I would like to know how can I display last 6 month's history log?
    DSPLOG PERIOD((070000 01012008)) JOB(QSYSOPR) gives me for only one month log.

    Thanks in advance.

    BPandya

  • #2
    Re: How to get 6 month history log?

    History is saved off into QHSTxxx tables. Usually, the date/time is built into the QHSTxxxx name.

    Look for the table you need to research and query it.

    These are usually in the QSYS library.

    -R

    Comment


    • #3
      Re: How to get 6 month history log?

      Well,

      I already try this B4 the post and as I mentioned it is giving me for last one month log only.

      I list all with WRKOBJ OBJ(QSYS/QHST*) and checked all the tables.

      Thanks for your quick reply.

      Please let me know

      Regards,

      Comment


      • #4
        Re: How to get 6 month history log?

        Hi BPandya:

        Do you have automatic cleanup running?

        Go cleanup
        option 1: change cleanup options

        System and workstation messages will remove qsysopr messages.


        If cleanup deleted the files the only way to get 6 months of data is to restore the qhstXXX from backup.

        BTW The format of the qhst file name is qhstYYDDDA where yy is the year ddd is the day of the year and a is the sequence if more than one log filled up on that day (A,B,C etc)

        Best of Luck
        GLS
        The problem with quotes on the internet is that it is hard to verify their authenticity.....Abraham Lincoln

        Comment


        • #5
          Re: How to get 6 month history log?

          Thanks GLS

          U R an Expert (GURU)

          I will follow your guidline and let you know if I need more help.

          Thanks again and have a good weekend.

          BPandya

          Comment

          Working...
          X