-REFRESH DB2,EARLY command (Db2)

The Db2 command -REFRESH DB2,EARLY reloads the ERLY code modules that were loaded at IPL time, and rebuilds the ERLY control block.

Executing the -REFRESH DB2,EARLY command is an alternative to doing an IPL of z/OS® for activating maintenance to early (ERLY) code after you apply that maintenance to the prefix.SDSNLINK data set.

When -REFRESH DB2,EARLY is run, previous copies of the ERLY modules are deleted from the system the next time that Db2 is started. This command is only valid when Db2 is inactive.

Restriction: Start of change

The data set that contains the new ERLY code must have been in the link list concatenation since z/OS IPL time. -REFRESH DB2,EARLY does not search for ERLY code in data sets that were added to the link list after IPL time. End of change

Important: If prefix.SDSNLINK is LLA-managed, you must perform an LLA refresh after you apply ERLY code maintenance, and before you issue the -REFRESH DB2,EARLY command. You can perform an LLA refresh by issuing the Db2 for z/OS command MODIFY LLA,REFRESH.

Abbreviation: -REF DB2

Environment

This command can be issued only from a z/OS console. In a non-data-sharing environment, the command must be issued on individual subsystems. In a data sharing environment, the command must be issued on individual members of a data sharing group. The name of the Db2 subsystem is determined by the command prefix. For example, -START indicates that the Db2 subsystem to be started is the one with '-' as the command prefix.

The command is rejected if the Db2 subsystem is already active. The ERLY code can be properly updated only when Db2 is not active.

Applications that use documented Db2 interfaces do not need to be stopped before issuing the REFRESH DB2,EARLY command.

Data sharing scope: Member

Authorization

None is required. However, the command can be executed only from a z/OS console with the START command capability. This command is rejected when Db2 is active, so no other authorization is required.

Syntax

Option descriptions

The following option is required.

EARLY: Indicates that the ERLY block is to be rebuilt, and that all of the modules that are loaded at IPL time are reloaded.

Scope of the -REFRESH command

The -REFRESH command has member-only scope, and must be executed for every instance where a unique recognition character for the -START command is defined.

After you issue the command, Db2 displays the maintenance levels of the ERLY code modules that were loaded.

Examples

Example: Refreshing the Db2 ERLY code

Suppose that the command prefix for a subsystem is -VC1A. This command reloads the ERLY code modules that were loaded at IPL time, and rebuilds the ERLY control block.

-VC1A REFRESH DB2,EARLY

After you issue the command, Db2 displays output like the following output:

DSN3100I -VC1A DSN3UR00 - SUBSYSTEM VC1A READY FOR START COMMAND
DSN3117I VC1A MAINTENANCE LEVELS          
  CSECT     DATE      APAR        CSECT     DATE      APAR   
  DSN3UR00  01/27/05  09.35       DSN3EC0X  01/24/05  09.10  
  DSN3ECMS  01/13/05  11.16       DSN3RIB   12/13/04  10.46  
  DSN3RDMP  12/13/04  10.27       DSNAET03  11/30/04  15.42  
  DSNAET04  11/30/04  15.42       DSNAPRHO  11/30/04  15.42  
  DSNAPRHX  12/20/04  10.10       DSNVRMTR  11/30/04  19.53  
  DSNVRSRB  11/30/04  19.53       DSNZPARS  11/30/04  21.48  
  DSN3AC0X  11/30/04  21.50       DSN3CL0X  11/30/04  21.51  
  DSN3DEQ0  11/30/04  21.52       DSN3ENQ0  11/30/04  21.52  
  DSN3EST0  11/30/04  21.53       DSN3RRSX  11/30/04  21.53  
  DSN3RRXF  11/30/04  21.54       DSN3RS0X  11/30/04  21.54  
  DSN3RTR0  11/30/04  21.54       DSN3SPRX  11/30/04  21.54