无法创建示例数据库 [英] Cannot create sample database
问题描述
大家好,所有
我是DB2世界的新手。
Win XP上的DB2 8.1企业版。安装(典型方法)很好。我以
登录''abc''用户(管理员用户)进行安装。现在我有'/ b $ b''db2admin''用户。
作为''abc''用户,我可以打开''控制中心''。但是当我尝试从''第一步'创建示例数据库时,我得到的错误是
''ABC是无效的授权ID。 SQLSTATE = 42602''。
问题:
1.我是否必须以''db2admin''用户身份登录才能创建数据库或者
额外的实例?
2.如果是这样,我需要配置什么才能完成全部DBA工作
作为''abc''用户?
非常感谢!
Hi, all
I''m new to DB2 world.
DB2 8.1 enterprise on Win XP. Installation (typical method) is fine. I
log in as ''abc'' user (admin user) to do the installation. Now I have
''db2admin'' user.
As ''abc'' user I am able to open ''control center''. But when I try to
create sample database from ''First Steps'', I get the error which is
''ABC is not valid authorization ID. SQLSTATE=42602''.
Questions:
1. Do I have to log in as ''db2admin'' user to create database or
additional instance?
2. If so, what do I have to configure in order to do the FULL DBA job
as ''abc'' user?
Thanks a lot!
推荐答案
< IB **** @ yahoo.com>在消息中写道
news:11 ********************* @ g44g2000cwa.googlegro ups.com ...
<ib****@yahoo.com> wrote in message
news:11*********************@g44g2000cwa.googlegro ups.com...
所有
我是DB2世界的新手。
Win XP上的DB2 8.1企业版。安装(典型方法)很好。我以''abc''用户(管理员用户)的身份登录进行安装。现在我有了''db2admin''用户。
作为''abc''用户,我可以打开''控制中心''。但是,当我尝试从第一步创建示例数据库时,我收到的错误是
''ABC是无效的授权ID。 SQLSTATE = 42602''。
问题:
1.我是否必须以''db2admin''用户身份登录才能创建数据库或
其他实例?
2.如果是这样,我需要配置什么来完成全部DBA工作
作为''abc''用户?
非常感谢!
Hi, all
I''m new to DB2 world.
DB2 8.1 enterprise on Win XP. Installation (typical method) is fine. I
log in as ''abc'' user (admin user) to do the installation. Now I have
''db2admin'' user.
As ''abc'' user I am able to open ''control center''. But when I try to
create sample database from ''First Steps'', I get the error which is
''ABC is not valid authorization ID. SQLSTATE=42602''.
Questions:
1. Do I have to log in as ''db2admin'' user to create database or
additional instance?
2. If so, what do I have to configure in order to do the FULL DBA job
as ''abc'' user?
Thanks a lot!
您可以在Windows中创建一个安全组,并为其创建用户ID(新的或
已存在),然后在
sysadm_group数据库管理器配置参数。
请参阅安装DB2通用数据库时的安全问题。在
管理:实施指南
You can create a security group in Windows, and user ids to it (new or
existing), and then define that group in the
sysadm_group database manager configuration parm.
See "Security issues when installing DB2 Universal Database" in the
Administration: Implementation Guide
非常感谢。
我知道这不是关于DB2,但我如何在Windows XP下创建一个安全组
?
再次获得Thnx。
Mark A写道:
Thanks a lot.
I know this is not about DB2, but how can I create a security group
under windows XP?
Thnx again.
Mark A wrote:
< ib **** @ yahoo.com>在消息中写道
新闻:11 ********************* @ g44g2000cwa.googlegro ups.com ...
<ib****@yahoo.com> wrote in message
news:11*********************@g44g2000cwa.googlegro ups.com...
你好,所有
我是DB2世界的新手。
Win XP上的DB2 8.1企业版。安装(典型方法)很好。我以''abc''用户(管理员用户)的身份登录进行安装。现在我有了''db2admin''用户。
作为''abc''用户,我可以打开''控制中心''。但是,当我尝试从第一步创建示例数据库时,我收到的错误是
''ABC是无效的授权ID。 SQLSTATE = 42602''。
问题:
1.我是否必须以''db2admin''用户身份登录才能创建数据库或
其他实例?
2.如果是这样,我需要配置什么来完成全部DBA工作
作为''abc''用户?
非常感谢!
Hi, all
I''m new to DB2 world.
DB2 8.1 enterprise on Win XP. Installation (typical method) is fine. I
log in as ''abc'' user (admin user) to do the installation. Now I have
''db2admin'' user.
As ''abc'' user I am able to open ''control center''. But when I try to
create sample database from ''First Steps'', I get the error which is
''ABC is not valid authorization ID. SQLSTATE=42602''.
Questions:
1. Do I have to log in as ''db2admin'' user to create database or
additional instance?
2. If so, what do I have to configure in order to do the FULL DBA job
as ''abc'' user?
Thanks a lot!
您可以在Windows中创建安全组,并在其中创建用户ID(新的或现有的),然后在
sysadm_group数据库管理器配置parm中定义该组。
请参阅安装DB2通用数据库时的安全问题。在
管理:实施指南
You can create a security group in Windows, and user ids to it (new or
existing), and then define that group in the
sysadm_group database manager configuration parm.
See "Security issues when installing DB2 Universal Database" in the
Administration: Implementation Guide
在XP中,得到开始=>控制面板=>用户重置= >选择你想要的用户
并修改它以使其成为管理员。
我不认为你可以在XP中创建用户组,因为这不是一个操作系统
具有服务器功能,因此群组的使用不会非常明智。
HTH,Pierre。
-
Pierre Saint-Jacques
SES顾问公司
514-737-4515
< ib **** @ yahoo.com> écritdansle message de news:
11 *********************@g49g2000cwa.googlegroups.c om ...
In XP, got to Start=>Control Panel=>User Acounts=> Select the user you want
and modify it to make it an Administrator.
I don''t think uou can create user groups in XP as this is not an OS that
has server capability so the usage of groups would not be very sensible.
HTH, Pierre.
--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
<ib****@yahoo.com> a écrit dans le message de news:
11*********************@g49g2000cwa.googlegroups.c om...
非常感谢。
我知道这不是关于DB2的,但我怎样才能在Windows XP下创建一个安全组?
Thnx再次。
Mark A写道:
Thanks a lot.
I know this is not about DB2, but how can I create a security group
under windows XP?
Thnx again.
Mark A wrote:
< ib **** @ yahoo.com>在消息中写道
新闻:11 ********************* @ g44g2000cwa.googlegro ups.com ...
<ib****@yahoo.com> wrote in message
news:11*********************@g44g2000cwa.googlegro ups.com...
> ;大家好,
>
>我是DB2世界的新手。
>
> Win XP上的DB2 8.1企业版。安装(典型方法)很好。我
>以''abc''用户(admin用户)身份登录进行安装。现在我有
> ''db2admin''用户。
>
>作为''abc''用户,我可以打开''控制中心''。但是当我尝试
>从''第一步''创建示例数据库,我得到的错误是
> ''ABC不是有效的授权ID。 SQLSTATE = 42602''。
>
>问题:
>
> 1.我是否必须以''db2admin''用户身份登录才能创建数据库或
>附加实例?
>
> 2.如果是这样,我需要配置什么才能完成全部DBA工作
>作为''abc''用户?
>
>非常感谢!
>
> Hi, all
>
> I''m new to DB2 world.
>
> DB2 8.1 enterprise on Win XP. Installation (typical method) is fine. I
> log in as ''abc'' user (admin user) to do the installation. Now I have
> ''db2admin'' user.
>
> As ''abc'' user I am able to open ''control center''. But when I try to
> create sample database from ''First Steps'', I get the error which is
> ''ABC is not valid authorization ID. SQLSTATE=42602''.
>
> Questions:
>
> 1. Do I have to log in as ''db2admin'' user to create database or
> additional instance?
>
> 2. If so, what do I have to configure in order to do the FULL DBA job
> as ''abc'' user?
>
> Thanks a lot!
>
您可以在Windows中创建一个安全组,并为其创建用户ID(新的或现有的),然后在<...中定义该组br /> sysadm_group数据库管理器配置参数。
请参阅安装DB2通用数据库时的安全问题。在
管理:实施指南
You can create a security group in Windows, and user ids to it (new or
existing), and then define that group in the
sysadm_group database manager configuration parm.
See "Security issues when installing DB2 Universal Database" in the
Administration: Implementation Guide
这篇关于无法创建示例数据库的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!