February 2009
M T W T F S S
« Jan   May »
 1
2345678
9101112131415
16171819202122
232425262728  

DB2 and usernames with spaces

17:23 on Wed 2009-02-04 by Leons Petrazickis DB2

DB2 v9.5 uses the Windows username as the default schema. Unfortunately, it does not support spaces in schema names. Accordingly, usernames – e.g. “Jane Smith” — that have a space can make DB2 unhappy. I recently helped someone resolve an issue with this command: db2sampl -force -name SAMPLE   Which brought up this error:   [...]