×
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/
midrange.com
