× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Is there a way to DSPLOG LOG(QHST) OUTPUT(*PRINT) MSGID(CPF3145) to an outifle or to a spoolfile that doesn't wrap.

I need an easy way to track access path rebuilds.
The below wraps, not easy to read.
I'd like to dump the output, sort descending by the time used field 00:00:01.

DSPLOG LOG(QHST) OUTPUT(*PRINT) MSGID(CPF3145)

5770SS1 V7R1M0 100423 History Log PENCOR06 2/17/17 8:39:39 Page 0001
MSGID SEV MSG TYPE
CPF3145 00 INFO Access path built for member CBG7REL0 file CBG7REL0 library CABLEFILES in 00:00:01.
QDBSRV04 QSYS 150219 QDBMAINT 0000 02/17/17 00:26:00.115878 QSYS
CPF3145 00 INFO Access path built for member CBBOREL0 file CBBOREL0 library CABLEFILES in 00:00:01.
QDBSRV05 QSYS 150220 QDBMAINT 0000 02/17/17 00:26:00.163651 QSYS
CPF3145 00 INFO Access path built for member CBIWREL0 file CBIWREL0 library CABLEFILES in 00:00:01.
QDBSRV04 QSYS 150219 QDBMAINT 0000 02/17/17 00:26:00.176451 QSYS
CPF3145 00 INFO Access path built for member CBJEREL0 file CBJEREL0 library CABLEFILES in 00:00:01.
QDBSRV04 QSYS 150219 QDBMAINT 0000 02/17/17 00:26:00.276308 QSYS
CPF3145 00 INFO Access path built for member TOLRSQ03 file TOLRSQ03 library BRFILES in 01:23:54.
QDBSRV05 QSYS 150220 QDBMAINT 0000 02/14/17 03:45:10.908309 QSYS
CPF3145 00 INFO Access path built for member TOLRSQ01 file TOLRSQ01 library BRFILES in 01:21:52.

Thank You
_____
Paul Steinmetz
IBM i Systems Administrator

Pencor Services, Inc.
462 Delaware Ave
Palmerton Pa 18071

610-826-9117 work
610-826-9188 fax
610-349-0913 cell
610-377-6012 home

psteinmetz@xxxxxxxxxx
http://www.pencor.com/


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.