Skip to Content

PCTFREE FOR UPDATE

(BMC.DB2.SPE2307)

Use the PCTFREE FOR UPDATE parameter to specify the default value of of CREATE TABLESPACE or ALTER TABLESPACE statements. It specifies the default amount of free space to reserve on each page for use by subsequent UPDATE operations when data is added to the table by INSERT operations or utilities.

Related topic

Basic LOADPLUS processing options

PCTFREE for UPDATE.png

Specifying the default

You can specify the default for the PCTFREE FOR UPDATE command option in your installation module by using ZPARM PCTFREE_UPD. The command option overrides the default that is in the installation options module. If you do not specify a value for FOR UPDATE parameter it will take the value from ZPARM PCTFREE_UPD.

The default value is specified at installation time.

Value

Description

-1

if -1 is specified for PCTFREE FOR UPDATE, processing skips this value and uses the original PCTFREE value.   

smallint

A value from 0 through 99 representing the new PCTFREE value

 

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

LOADPLUS for DB2 13.1