Start of change

Optimizing ADMIN_INFO_SYSPARM and DSNZPARM settings for GEN and DDL

The Db2 Admin Tool Reverse Engineering (GEN) function uses the ADMIN_INFO_SYSPARM stored procedure to read Db2 subsystem parameter values from the Db2 DSNZPARM module.

About this task

If ADMIN_INFO_SYSPARM does not complete normally, the Reverse Engineering function waits until ADMIN_INFO_SYSPARM times out. In this case, the GEN or DDL commands might run longer than necessary as a result of Db2 waiting for the timeout value for stored procedures to be reached.

Procedure

To optimize the performance of the GEN and DDL commands, optimize ADMIN_INFO_SYSPARM and the DSNZPARM settings as follows:

  • Verify that the ADMIN_INFO_SYSPARM stored procedure is operational.
  • Verify that the STORTIME subsystem parameter (in macro DSN6SYSP) is set to a reasonable waiting time. You might want to specify a lower value for STORTIME.
End of change