Default configuration keywords specific to DB2
Default configuration keywords specific to DB2
|
| Release 9.3 |
   |
Note:This topic was updated for 9.3.1.
In addition to the default DBTUNE keywords common to all DBMSs that were listed in the topic DBTUNE configuration keywords, there is one additional configuration keyword in DB2—IMS_GAZETTEER. Beginning with ArcSDE 9.3, the IMS_GAZETTEER keyword can be used to control the size of XML documents used with an ArcIMS Gazetteer Metadata Service. You can specify the size of an XML column's data using the parameters XML_DOC_LOB_SIZE and XML_DOC_VAL_LOB_STORAGE. Gazetteer XML documents are usually smaller than other XML documents, so you can generally set the value for these lower for this keyword.
The XML_DOC_LOB_SIZE parameter specifies the size of the XML document in the xml_doc_val column of the sde_xml_doc<n> table. XML_DOC_VAL_LOB_SIZE indicates the storage size for the XML document content in the xml_doc_val column of the sde_xml_doc<n> table.
The default values are as follows:
##IMS_GAZETTEER
XML_DOC_LOB_SIZE "1M"
XML_DOC_VAL_LOB_SIZE "1M"
END
You'll notice that these same parameters—XML_DOC_LOB_SIZE and XML_DOC_VAL_LOB_SIZE—are present under the DEFAULTS configuration keyword and are set to the same size. Set the size for these parameters under the DEFAULTS keyword to the size you want for your XML document storage the majority of the time. Set these parameters under the IMS_GAZETTEER keyword to another size; a size that you will only use for XML document storage used with an ArcIMS Gazetteer Metadata Service. See Configuring a DB2 database to support XML columns for examples and recommendations on how to set these.
NOTE: XML keywords and parameters do not affect geodatabases on DB2 for z/OS, since XML is not supported for these geodatabases at this time.
