PP0451I message display PPA SQL Statement Report Display

Products

• RC Compare for DB2 for z/OS
• Database Analyzer for DB2 for z/OS
• Fast Unload for DB2 for z/OS
• Fast Check for DB2 for z/OS
• Fast Index for DB2 for z/OS
• Rapid Reorg for DB2 for z/OS

Issue/Introduction

Question: 

In PPA SQL Statement Report display, how do you make the PP405I: message more visible than it is in this panel? 

LINE 1 OF 9933 > 

Option ===> ST Report ===> L Scope ===> B 

Plan/ 

Collid ===> PPADD18B Package ===> * Where ===> N 

----------------------------------------------------------------- NTUJE01 

Location ===> LOCAL DB2 SSID ===> D11B Version ===> V11CM 

 

CMD PLAN COLLID PACKAGE STMTNO 

 

____ PPADD18B 

____ PAAMD18B_ANL 

____ PAA$ATHD 

____ 984 

____ 

 

Valid CMDS: PLAN, PACKAGE, BIND, SQL COMMANDS, AND X, QE, RCA 

PP405I: More report data columns present. Use PF10/PF11 to view data. <=============================

Answer: 

 To Make the PP405I: more visible in PPA SQL Statement Report display, go to ISPF and select option 0 for ISPF Settings and remove the "/" from to select option Long message in pop-up as shown below 

ssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss 

ISPF Settings 

Command ===> 

 

Options Print Graphics 

Enter "/" to select option Family printer type 2 

Command line at bottom Device name . . . . 

/ Panel display CUA mode Aspect ratio . . . 0 

Long message in pop-up <============== 

/ Tab to action bar choices 

Tab to point-and-shoot fields General 

/ Restore TEST/TRACE options Input field pad . . N 

Session Manager mode Command delimiter . ; 

/ Jump from leader dots 

Edit PRINTDS Command 

/ Always show split line 

Enable EURO sign 

 

This is how the message PP405I displays now: 

 

18.0 ----------- PPA SQL Statement Report ----------- 2016/03/28 14:29 

LINE 1 OF 9922 > 

Option ===> ST Report ===> L Scope ===> B 

Plan/ DBRM/ 

Collid ===> PPADD18B Package ===> * Where ===> N 

----------------------------------------------------------------- NTUJE01 

Location ===> LOCAL DB2 SSID ===> D10B Version ===> V10CM09 

 

CMD PLAN COLLID DBRM/PKG STMTNO 

 

____ PPADD18B 

____ PAAMD18B_ANL 

____ (PK) PAA$ATHD 

____ 984 

____ 

____ 

 

_ EsssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssN 

V e PP405I: More report data columns present. Use PF10/PF11 to view data. e <=================== 

P Dssssssssssssssssssssssssssssssssss

Environment

Release:
Component: ANLDB2