|
This thread has really caught my attention - due to a MAJOR problem we--
have had since the New Year We started having Mutex waits for users in
the warehouse using web service calls to an outside company that
would supply us with the correct courier, labels etc.
This was killing us
From a couple of seconds for a response - it went to 15 to 20 minutes
per response To cut a LOOOOOOOOOOOOOOOOOOOOOOOOOONG story short, the
immediate problem was that we were mimixing the ifs (when we don't
really need to) PLUS one ifs directory has over 7.5 million files,
accumulated in 8 months
When I looked at the results of our ifs purge job, I discovered that
this particular directory was NOT being purged We have since included
other directories into our ifs purge process, and we hope that because
the warehouse does not work from Friday night to Sunday morning, this
will give us time AND the necessary access to this large ifs directory
Now that I have explained the dilemma, does anyone know if these sql
services will have the capability of not only listing the contents,
but also being able to delete the contents with certain criteria (age
etc.) of a directory?
Does anyone have something for me to look at/read?
Alan Shore
E-mail : ASHORE@xxxxxxxx
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
'If you're going through hell, keep going.'
Winston Churchill
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
John Yeung
Sent: Thursday, January 21, 2016 5:02 PM
To: Midrange Systems Technical Discussion
Subject: List IFS files in a folder using SQL (was: Those new SQL
things on IBM i)
On Thu, Jan 21, 2016 at 3:09 PM, Jeff Crosby
<jlcrosby@xxxxxxxxxxxxxxxx>
wrote:
I have a project coming up in a month or so where I will want a list
of files in an IFS folder. I'm hoping I can get that file list this way.
I suppose it would be nice. I love the idea of exposing more things
via SQL (particularly when the easiest-to-use option thus far is a
system API), and it looks like IBM is on that path.
But while you wait for IFS handling to show up in the official DB2 for
i views and services (I'm guessing it will take longer than "a month or so"
for this to happen), you can do it yourself by wrapping up the
appropriate non-SQL code in UDFs or stored procedures.
If you don't want to wait, and you don't want to build your own
UDFs/SPs, you could stick solely to SQL by relying on QSYS2.QCMDEXC to
execute arbitrary CL commands (including the QSH command, to execute
arbitrary Qshell commands like ls with the > redirection operator).
You may also have to use QCMDEXC to do CPYFRMSTMF or CPYFRMIMPF.
It's the good ol' dump-and-read technique. Byzantine, especially in
this from-SQL incarnation, with probably tons of extra single-quotes
to keep track of, but doable.
John Y.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at http://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related
questions.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
http://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related
questions.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.