10 November,2011 by Tom Collins
How to set a DB2 LUW database cfg value to an empty value use NULL.
note : It’s case sensitive. Using “null” will not work.
An example of setting NULL:
update db cfg for MYDB using HADR_LOCAL_HOST NULL
Not all DB2 db cfg items can be set to NULL. Every parameter has a set of valid values from docs "USING config-keyword valueconfig-keyword specifies the database configuration parameter to be updated. value specifies the value to be assigned to the parameter"
Check the documentation for the individual configurable
This is only a preview. Your comment has not yet been posted.
As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.
Having trouble reading this image? View an alternate.
Posted by: |