14.2.3 Other data You should also consider index files used by DB2 UDB when determining a data placement strategy, as shown in Table 14-2. Table 14-2 Naming convention for objects with DB2 UDB File name SQLxxxxxxx.LOG File contents DB2 transaction logs 14.2.4 Sample SAN File System policy rules Example 14-1 is a sample of SAN File System rules that could be used for DB2 configured with SMS tablespaces. This will separate the different types of DB2 data to different User Pools based on the file extension. Example 14-1 Sample rules for DB2 RULE RULE RULE RULE RULE RULE RULE 'stgRule1' 'stgRule2' 'stgRule3' 'stgRule4' 'stgRule6' 'stgRule7' 'stgRule8' SET SET SET SET SET SET SET STGPOOL STGPOOL STGPOOL STGPOOL STGPOOL STGPOOL STGPOOL 'log' WHERE NAME LIKE '%.LOG' 'data' WHERE NAME LIKE '%.DAT' 'index' WHERE NAME LIKE '%.INX' 'lob' WHERE NAME LIKE '%.LB' 'lob' WHERE NAME LIKE '%.LBA' 'lob' WHERE NAME LIKE '%.LFA' 'temp' WHERE NAME LIKE '%.TDA' Note: If no matching rule is found for a particular file, it will be placed in the default storage pool.