DSN1SMFP output
Use this DSN1SMFP utility output to aid in determining and correcting system security problems. When diagnosing Db2, you might need to refer to licensed documentation to interpret output from this utility.
DSN1SMFP generates up to nineteen types of reports, according to the input, plus an end-of-job summary report. Each type of report is triggered by a particular IFCID type. Each occurrence of a recognized IFCID type causes a new report to be appended to any earlier report that was generated in the same run. Each report begins with a standard report header. When all records have been processed, an end of job report summarizes the input that was received, which records were processed, and any error messages that were encountered along the way.
DSN1SMFP creates the following dedicated report DDs:
| DD name | Description | Record format | Record structure |
|---|---|---|---|
| IFCID003 DD | Extracted IFCID 003 (DDF Location) records | RECFM=FBA | See IFCID003: DDF Location |
| IFCID004 DD | Extracted IFCID 004 (Trace Start) records | RECFM=FBA | See IFCID004: Trace Start |
| IFCID005 DD | Extracted IFCID 005 (Trace Stop) records | RECFM=FBA | See IFCID005: Trace Stop |
| IFCID023 DD | Extracted IFCID 023 (Utility Start) records | RECFM=FBA | See IFCID023: Utility Start |
| IFCID024 DD | Extracted IFCID 024 (Utility Change) records | RECFM=FBA | See IFCID024: Utility Change |
| IFCID025 DD | Extracted IFCID 025 (Utility End) records | RECFM=FBA | See IFCID025: Utility End |
| IFCID083 DD | Extracted IFCID 083 (Identify End) records | RECFM=FBA | See IFCID083: Identify End |
| IFCID106 DD | Extracted IFCID 106 (System Parameters) records (security-relevant fields only) | RECFM=FBA | See IFCID106: System Parameters (security-relevant fields only) |
| IFCID140 DD | Extracted IFCID 140 (Audit Authorization Failures) records | RECFM=FBA | See IFCID140: Audit Authorization Failures |
| IFCID141 DD | Extracted IFCID 141 (Audit DDL Grant/Revoke) records | RECFM=FBA | See IFCID141: Audit DDL Grant/Revoke |
| IFCID142 DD | Extracted IFCID 142 (Audit DDL Create/Alter/Drop) records | RECFM=FBA | See IFCID142: Audit DDL Create/Alter/Drop |
| IFCID143 DD | Extracted IFCID 143 (Audit First Write) records | RECFM=FBA | See IFCID143: Audit First Write |
| IFCID144 DD | Extracted IFCID 144 (Audit First Read) records | RECFM=FBA | See IFCID144: Audit First Read |
| IFCID145 DD | Extracted IFCID 145 (Audit DML Statement) records | RECFM=FBA | See IFCID145: Audit DML Statement |
| IFCID269 DD | Extracted IFCID 269 (Trusted Connection) records | RECFM=FBA | See IFCID269: Trusted Connection |
| IFCID270 DD | Extracted IFCID 270 (Trusted Context) records | RECFM=FBA | See IFCID270: Trusted Context |
| IFCID350 DD | Extracted IFCID 350 (SQL Statement) records | RECFM=FBA | See IFCID350: SQL Statement |
| IFCID361 DD | Extracted IFCID 361 (Audit Administrative Authorities) records | RECFM=FBA | See IFCID361: Audit Administrative Authorities |
| IFCID362 DD | Extracted IFCID 362 (Trace Start and Stop with AUDITPOLICY) records | RECFM=FBA | See IFCID362: Trace Start with Audit Policy |
| SYSPRINT DD | Runtime messages and EOJ summary | RECFM=FBA | See SYSPRINT: Runtime messages and end-of-job summary |
For details about the record structure of the DSN1SMFP output, see DSN1SMFP output record structure.