The DB2 extenders use the DB2MMDATAPATH environment variable to resolve locations for various operations in a partitioned database environment. For example, the DB2 Image Extender uses the value of DB2MMDATAPATH to store QBIC data in a partitioned database environment.
You set DB2MMDATAPATH when you create a DB2 extenders instance, as described in DMBICRT and in the following installation "readme" files:
One example of how DB2MMDATAPATH is used is in storing QBIC feature and index data. In UNIX, the DB2 Image Extender stores this QBIC data in the following directory:
db2mmdatapath /NODEnode_num/QBIC/database_name
where db2mmdatapath is the value of the DB2MMDATAPATH environment variable, node_num is the node number, and database_name is the database name.
Consider the following AIX example. Suppose DB2MMDATAPATH is set to /localfs/dmbdata. Suppose too that a database named sample is partitioned in nodes 0, 2, and 5. QBIC data will be stored for the sample database in the following directories:
Node 0: /localfs/dmbdata/NODE0000/QBIC/sample
Node 2: /localfs/dmbdata/NODE0002/QBIC/sample
Node 5: /localfs/dmbdata/NODE0005/QBIC/sample