By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,021 Members | 912 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,021 IT Pros & Developers. It's quick & easy.

SQL0567N

P: n/a
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?

Thanks
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a

<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.
Nov 12 '05 #2

P: n/a
In article <3O****************@bignews4.bellsouth.net>, (niel4596
@bellsouth.net) says...
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?

Thanks


If you install FP7 this ID will be allowed, check the wrapped link
below:
http://publib.boulder.ibm.com/infoce...com.ibm.db2.ud
b.doc/core/c0011593.htm

But you still run into troubles when creating tables with this ID.
I use the 'set current schema' command with a valid table prefix
before issuing any SQL statement to prevent this kind of problems.
You can also use fully qualified names in your SQL to get the same
results.
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.