RANDOMIZE XML DOCID field (XML_RANDOMIZE_DOCID subsystem parameter)
Specifies whether DB2® is to sequentially or randomly generate the DOCID values for XML columns.
This parameter does not affect existing tables that have XML columns. Those tables continue to generate DOCIDs in the order that was specified by XML_RANDOMIZE_DOCID when the table was created or in sequential order if the parameter was not specified.
| Acceptable values: | NO, YES |
| Default: | NO |
| Update: | option 19 on panel DSNTIPB |
| DSNZPxxx: | DSN6SYSP XML_RANDOMIZE_DOCID |
- NO
- DB2 generates the DOCID values for XML columns sequentially.
- YES
- DB2 generates the DOCID values for XML columns randomly. Setting this parameter to YES can be beneficial for performance when concurrent inserts are expected.
Once a table starts to randomly generate DOCID values for XML columns, it cannot be changed to generate the value sequentially. Changing this parameter back to NO does not have any effect on tables that have had columns added with a randomized DOCID.
