ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

PGM=NSIGHTRW generated report with trailer on first line of new page


Article ID: 126305


Updated On:


Bind Analyzer for DB2 for z/OS SQL-Ease for DB2 for z/OS SYSVIEW Performance Management Option for DB2 for z/OS Plan Analyzer for DB2 for z/OS Subsystem 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



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.