DSNADMSB

The DSNADMSB program collects information about a Db2 subsystem and its objects and applications. It calls the ADMIN_INFO_SQL stored procedure.

Tip: You can run the DSNTEJ6I sample job that is supplied with Db2 in the prefix.SDSNSAMP data set to run this program. For more information, see DSNTEJ6I.
IBM® Support can use the information that DSNADMSB gathers to duplicate a customer environment to diagnose and resolve problems. This capability is especially useful for re-creating performance problems.

Output

Output from the DSNADMSB program consists of files that contain one or more of the following items:

  • Data definition statements for re-creating user objects
  • Statistics from the Db2 catalog
  • INSERT statements for inserting rows into tables:
    • DSN_PROFILE_ATTRIBUTES
    • DSN_PROFILE_TABLE
    • PLAN_TABLE
    • SYSACCELERATEDTABLES
    • SYSACCELERATORS
  • Output from:
    • DSN_DETCOST_TABLE
    • DSN_PREDICAT_TABLE
    • DSN_PROFILE_TABLE
    • DSN_PROFILE_ATTRIBUTES
    • PLAN_TABLE
    • SYSACCELERATEDTABLES
    • SYSACCELERATORS
  • Subsystem parameter settings and module entry point list (MEPL) information
  • Module entry point list (MEPL) information that relates to query processing
  • Status information from stored procedure ADMIN_INFO_SQL

The output from ADMIN_INFO_SQL is intended primarily for the use of IBM Support. The format and content of the output might change at any time.

Authorization required

To execute DSNADMSB, you must have the following Db2 privileges or authorities:

  • EXECUTE authority on plan DSNADMSB
  • One of the following privileges or authorities:
    • The EXECUTE privilege on the ADMIN_INFO_SQL stored procedure
    • Ownership of the ADMIN_INFO_SQL stored procedure
    • SYSADM authority

In addition, if you direct DSNADMSB to write its output to data sets, you need to be authorized to perform either of the following tasks:

  • Create data sets
  • Write to already existing data sets