PGM=NSIGHTRW generated report with trailer on first line of new page
Article ID: 126305
Bind Analyzer for DB2 for z/OSSQL-Ease for DB2 for z/OSSYSVIEW Performance Management Option for DB2 for z/OSPlan Analyzer for DB2 for z/OSSubsystem Analyzer for DB2 for z/OS
The batch job(NSIGHTRW) generated a 200 pages report. The last page(page 200) has 56 lines. The job generated also new page(201) to output trailer record. which is only one line: <<<REQUEST NFACTPK2 ENDED 10518 LINES>>>" Page 201 doesn't have the heading like: 1 01/25/19 03:30:11 PAGE 200 REQUEST: NFACTPK2 DB2 SYS: D2PA FIRST RECORD 01/24/19 00:00:17 LAST RECORD 01/24/19 23:59:58 SHORT SUMMARY OF ACCOUNTING INFORMATION GROUPED BY PLAN v1.1 Is this a design flaw of PGM=NSIGHTRW? 1 01/25/19 03:30:11
Release: Component: CIDB
NSIGHTRW is working as designed. IDB2(Sysview Performance for DB2) is processing the records and printing a report. When the end of the input file is reached and there is no more records in the input file, IDB2 prints an information message -> "<<<REQUEST NFACTPK2 ENDED 10518 LINES>>>" If there is a space in the last page, the product(IDB2) prints the informational message at the bottom of that page. If there is no space in the last page, the product(IDB2) prints the informational message in the new page. When the product does that it does not print the header because the informational message is not part of the record.