When I go to Tools | DB2 Command Window menu option, I get the error:
Exception: System.ArgumentException
Message : Item has already been added. Key in dictionary: 'db2codepage' Key being added: 'db2codepage'
Stack Trace:
at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add)
at System.Collections.Hashtable.Add(Object key, Object value)
at System.Collections.Specialized.StringDictionary.Add(String key, String value)
at Quest.Toad.DB2.LaunchEXE.Run(String exeName, String argsLine, Int32 timeoutMilliSeconds)
at Quest.Toad.DB2.DB2CommandWindow.OpenDB2CommandWindow()
WORKAROUND 1:
Change the DB2CODEPAGE value to i.e. 1208. Per the development team, the value of 437,850 does not seem to be a valid value. The right way to set DB2CODEPAGE is to use the db2set command which is a DB2 Variable.
Db2set DB2CODEPAGE=1208
WORKAROUND 2:
Delete the DB2CODEPAGE setting (i.e. DB2CODEPAGE=437,850) from the User / System variable by the following:
- Go to Control Panel | System | Advanced | Environment Variables
- Look under User Variables or System Variables and delete the DB2CODEPAGE setting
STATUS:
Waiting for fix in a future release of Toad for DB2.
