ADMIN_REFRESH_CONFIG stored procedure

Use the ADMIN_REFRESH_CONFIG stored procedure to explicitly initiate a refresh a given instance configuration. It takes one VARCHAR(255) parameter to specify the type of configuration to refresh. Currently, the value TOKEN is supported.

ADMIN_REFRESH_CONFIG stored procedure

The schema is SYSIBMADM.

Authorization

The following authorization is required:
  • EXECUTE privilege on the routine. EXECUTE privilege on this routine can be granted only by the security administrator (SECADM)

Default PUBLIC privilege

In a nonrestrictive database, SELECT privilege is granted to PUBLIC when the view is automatically created.

Syntax

Read syntax diagramSkip visual syntax diagramADMIN_REFRESH_CONFIG(type )

Procedure Parameters

type

A required input parameter of type VARCHAR(255) that specifies the type of configuration to be refreshed.

Currently, only the value TOKEN is supported.

Usage Notes

Calling ADMIN_REFRESH_CONFIG will refresh the token configuration of the instance. On DPF or Db2® pureScale® instances, the configuration of the local instance will be refreshed first. If the refresh of the local instance is successful, an RPC will be sent to other nodes and they will process the configuration update.

Example

db2 "call sysproc.admin_refresh_config('token')"

  Return Status = 0