to create a new user when i give the following statement
CREATE USER mudata WITH PASSWORD abcd
its showing error,error as follows
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0104N An unexpected token "USER" was found following "CREATE ". Expected
tokens may include: "TYPE". SQLSTATE=42601
provide me solution for creating a new user

Hi,

You cannot create a USER within DB2. You can create a USER at the Operating System level only (Windows or Aix etc). After the user is created you can associate that with the db2.

Thanks,

Thanks for ur reply.could you say me how to create user in operating system level.my operating system is windows2000/NT

Hi,
on Windows XP/2003 (sorry I don't have any older version of Windows):
1. Start
2. Settings
3. Control Panel
4. Administrative tools
5. Computer Management

Computer Management window opens:
6. System tools
7. Local Users and Groups
8. right click on Users folder and New user.

Follow the wizard.

It should be similar in win2000, but I am sure in NT is different, but I can't remember how. I haven't been using NT for ages...

Hope this helps,
Grofaty

Thank u grofaty.
I created a user in the way u said.It was sucessful.
actually i want to create user in script file.how is it possible?
Iam using Windows 2000/NT platform.
guide me and provide me solution as soon as possible.
hoping the help...

brindha,
this is DB2 forum. Sorry I don't know have to create user from script. Try using www.tek-tips.com forum and then select subforum "windows"
Grofaty