<ni******@bellsouth.net> wrote in message
news:3O****************@bignews4.bellsouth.net...
During install of UDB 8.1 on Windows XP, my name gets set to AUTH ID as
'MARTIN NIELSON'. Then, when I try to create a table DB2 complains about
the value of the ID. Where does DB2 get the name from so I might change it.
OR, what can I do to correct/circumvent this problem?
Your AuthID is your Windows username. DB2 does not allow AuthIDs to have
spaces in them, as well as most punctuation characters.
You can correct this by using a username on your Windows box that does not
have a space in it.
From the DB2 Information Center
(
http://publib.boulder.ibm.com/infoce...help/index.jsp)
SQL0567N authorization-ID is not a valid authorization ID.
Explanation:
The authorization ID specified by authorization-ID is not valid for one of
the following reasons:
a.. It begins with "SYS", "sys", "IBM", "ibm", "SQL", or "sql".
b.. It contains characters other than a through z, A through Z, 0 through
9, and the three special characters (#,@.$).
c.. It is delimited and contains lower case letters.
d.. It is GUESTS, ADMINS, USERS, or LOCAL.
e.. It is PUBLIC preceded by the keyword USER or GROUP in a GRANT or
REVOKE statement.
The statement cannot be processed.
User Response:
Correct the invalid authorization ID.