title: Special character (!, exclamation mark) in DB2 user password gives error when starting i2 Analyze or connecting from DB2 command console
body: <p>The following error occurs when starting i2 Analyze with example deployment 
  (some parts of error messages are in Finnish because of the Windows localization settings, sorry about that)</p>
  
  <pre><code>setup -t startLiberty
  
  java.sql.SQLInvalidAuthorizationSpecException: [jcc][t4][2013][11249][4.17.29] On ilmennyt yhteyden käyttöoikeusvirhe.  Syy: Käyttäjätunnus tai tunnussana ei kelpaa. ERRORCODE=-4214, SQLSTATE=28000 DSRA0010E: SQL State = 28000, Error Code = -4 214
  </code></pre>
  
  <p>I believe the error is more closely related to DB2(10.5 FP7) &amp; Windows(W12R2) than i2 Analyze itself because when connecting from DB2 command console (db2cmd) and giving both username and password (with !) within a single line:</p>
  
  <pre><code>connect to WRITESTORE user db2admin using &lt;SomePasswordWith!&gt;
  </code></pre>
  
  <p>The error shown in console is as follows:</p>
  
  <pre><code>SQL0104N  Järjestelmä on löytänyt merkkijonoa "&lt;tunnus&gt;" seuraavan
  tunnistamattoman sanakkeen "!".  Odotettuja sanakkeita ovat esimerkiksi
  seuraavat: "NEW".  SQLSTATE=42601
  </code></pre>
  
  <p>Anyhow, if password (with character !) is given only when prompted eg:</p>
  
  <pre><code>connect to WRITESTORE user db2admin
  </code></pre>
  
  <p>and giving password when asked, user is logged in without an error.
  Also when connecting to DB2 with IBM DataStudio gives no error.</p>
  
  <p>So, using passwords without special characters is a workaround for the issue.</p>