Re: QHIST LOG FILE

[Rob Berendt <robertowenberendt@xxxxxxxxx>]

Use the sql services instead.  Using spool files is rough, especially when
the string you may be looking for may be continued on another line.
When I am looking for SQL services I look in 1 of two places
https://www.ibm.com/support/pages/ibm-i-services-sql
https://www.ibm.com/docs/en/i/7.5?topic=optimization-i-services

On Wed, Sep 18, 2024 at 5:40 PM David Jefferson via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

> I printed the qhst file then saved it to a file called usrloginpf with on
> field called usrloginpf I am trying run a sql using strsql to print a list
> of the records containing a specific word and having difficulty
>
> Or how can I check and select in using query function on iSeries
>
> Sent from my iPhone
> Thanks
>
> D Jefferson
>
> > On Sep 18, 2024, at 12:24 PM, stefan@xxxxxxxxxx wrote:
> >
> > Go Cleanup
> > Option 1.
> >
> > Best regards
> >
> > Stefan
> >
> > --
> > No trees were killed in the sending of this message, but a large number
> of electrons were terribly upset.
> > Stefan Tageson
> > +46 732 369934
> > stefan@xxxxxxxxxx
> >
> > -----Original Message-----
> > From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
> David Jefferson via MIDRANGE-L
> > Sent: Wednesday, September 18, 2024 5:27 PM
> > To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx
> >
> > Cc: David Jefferson <djeffer32@xxxxxxxxx>
> > Subject: QHIST LOG FILE
> >
> > Where is the setting on iSeries that determines how long QHIST logs are
> kept and what clears the logs from there Sent from my iPhone Thanks
> > D Jefferson
> >
> > > On Sep 17, 2024, at 6:41 AM, Patrik Schindler <poc@xxxxxxxxxx> wrote:
> > >
> > > Hello Rob,
> > >
> > > > > Am 16.09.2024 um 20:23 schrieb Rob Berendt <
> robertowenberendt@xxxxxxxxx>:
> > > > I read the overview and it seems to have a real problem with the
> concept of using a library list.  Their fear is that someone could put a
> version of the program higher in a library list which, while it has the
> same name, does something completely different.
> > > This is an almost 1:1 transfer of an attack vector on UNIX systems,
> where the current directory is automatically first to be searched for
> launchable objects (binaries, scripts with the x flag set).
> > > Usually, the global /tmp directory, writable by anyone, has been abused
> for that purpose. Place a rogue "ls" there, wait until someone does a cd
> /tmp and ls. It's not applicable 1:1 to IBM i because there is no global
> QTEMP, but it's job specific.
> > > > Their cure is to hardcode all program calls.  So, instead of CALL
> MYPGM you use CALL MYLIB/MYPGM.  This would play havoc with rolling out
> changes and test libraries.
> > > Security often contradicts the necessities of daily work. Security
> research shows weak spots and the responsible sysadmin tries to implement a
> good middle ground between security and pragmatic approach so people can
> actually do their jobs.
> > > To show case an extreme measure: If you want to be 100% secure, take
> all of the storage and servers, disconnect them from power and network and
> put them into a large safe. No work can be done, though.
> > > > Well, if I can stick this in a library higher in the library list,
> what's to stop me from sticking it into the original library?
> > > That the original library or the original object has authorization
> settings which prevent a simple replacement.
> > > :wq! PoC
> > >
> > >
> > >
> > > --
> > > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> > > list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To
> > > subscribe, unsubscribe, or change list options,
> > > visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> > > or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> > > Before posting, please take a moment to review the archives at
> > > https://archive.midrange.com/midrange-l.
> > >
> > > Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
> related questions.
> > >
> >
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
> unsubscribe, or change list options,
> > visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> > Before posting, please take a moment to review the archives at
> https://archive.midrange.com/midrange-l.
> > Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
> related questions.
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at https://archive.midrange.com/midrange-l.
> >
> > Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
> related questions.
> >
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.