Menu ▾ ▴

#170 db2ts/exclude_autoresize

todo_before_2.0
open
Ulrich Herbst
None
5
2013-03-18
2013-03-18
Ulrich Herbst
No

We have a configuration like this:
<TABLESPACE>
<DB2ALIAS>DB2INST1</DB2ALIAS>
<DB2PROFILE>/export/home/db2inst1/sqllib/db2profile</DB2PROFILE>
<TABLESPACENAME>SYSCATSPACE</TABLESPACENAME>
<EXCLUDE_AUTORESIZE>yes</EXCLUDE_AUTORESIZE>
<VALUE>92</VALUE>
<FORMULA>PERCENT</FORMULA>
<ERRORLEVEL>WARNING</ERRORLEVEL>
</TABLESPACE> <TABLESPACE>
<DB2ALIAS>DB2INST1</DB2ALIAS>
<DB2PROFILE>/export/home/db2inst1/sqllib/db2profile</DB2PROFILE>
<TABLESPACENAME>.*</TABLESPACENAME>
<EXCLUDE_AUTORESIZE>yes</EXCLUDE_AUTORESIZE>
<VALUE>92</VALUE>
<FORMULA>PERCENT</FORMULA>
<ERRORLEVEL>WARNING</ERRORLEVEL>
</TABLESPACE>

Then, _create_rules_for_autoresize does not replace the entry for syscatspace, but adds additional entries with threshold 101%. But that's wrong - we should replace existing entries, where tablespace is without wildcards.

To fix this, we should change line 271 in db2ts.pm to not just add an entry, but to check, if this entry is already existing.

Discussion