DB2 Express-C on Vista/Business

[gimme_this_gimme_that]

Hello,

Looking back on it - knowing what I know now - I should have run
setup.exe by right clicking and explicitly running as an
Administrator.

Well, here I am. I installed DB2 Express-C from an account that is a
member of the Administrators group.

I got a pop-up that said:

One or more errors occurred while creating the DB2 Administration
Server.

The DB2 Administration Server may not function properly

Create the DB2 Administration Server manually.

If the problem persists contact your technical service
representative.

The successive popups displayed:

1. An error occurred while initializing the Profile Registry.

The return value is “-2079391743”. Contact your technical service
representative.

2. An error occurred while setting the registry key “SOFTWARE\Microsoft
\MSDTC\XADLL\C:\Program Files\IBM\SQLLIB\BIN\DB2APP.DLL” to “C:
\Program Files\IBM\SQLLIB\BIN\DB2APP.DLL”.


3. One or more errors occurred while committing the changes to the
user “DB2”. Create or make any changes to this user manually.


4. An error occurred while creating the instance “DB2”. The return
code is “-1918”. Create the instance manually using the command
“db2icrt”.


Now:

A. Is there a registry hack to resolve item 2 (that also resolves item
1)? If there is, could someone be kind enough to step me through it?

B. Should I create a DB2 users and make that user a member of DB2ADMNS
and DB2USERS?

C. I was able to create a DB2 instance using db2icrt - so that worked.

Incidentally, I added my account to DB2ADMNS and DB2USERS.

 

[Serge Rielau]

Hello,

Looking back on it - knowing what I know now - I should have run
setup.exe by right clicking and explicitly running as an
Administrator.

Well, here I am. I installed DB2 Express-C from an account that is a
member of the Administrators group.

I got a pop-up that said:

One or more errors occurred while creating the DB2 Administration
Server.

The DB2 Administration Server may not function properly

Create the DB2 Administration Server manually.

If the problem persists contact your technical service
representative.

The successive popups displayed:

1. An error occurred while initializing the Profile Registry.

The return value is “-2079391743”. Contact your technical service
representative.

2. An error occurred while setting the registry key “SOFTWARE\Microsoft
\MSDTC\XADLL\C:\Program Files\IBM\SQLLIB\BIN\DB2APP.DLL” to “C:
\Program Files\IBM\SQLLIB\BIN\DB2APP.DLL”.


3. One or more errors occurred while committing the changes to the
user “DB2”. Create or make any changes to this user manually.


4. An error occurred while creating the instance “DB2”. The return
code is “-1918”. Create the instance manually using the command
“db2icrt”.


Now:

A. Is there a registry hack to resolve item 2 (that also resolves item
1)? If there is, could someone be kind enough to step me through it?

B. Should I create a DB2 users and make that user a member of DB2ADMNS
and DB2USERS?

C. I was able to create a DB2 instance using db2icrt - so that worked.

Incidentally, I added my account to DB2ADMNS and DB2USERS.

c:\>db2diag -rc -2079391743

Input ZRC string '-2079391743' parsed as 0x840F0001 (-2079391743).

ZRC value to map: 0x840F0001 (-2079391743)
V7 Equivalent ZRC value: 0xFFFFC601 (-14847)

ZRC class :
Non-Critical Media Error (Class Index: 4)
Component:
SQLO ; oper system services (Component Index: 15)
Reason Code:
1 (0x0001)

Identifer:
SQLO_ACCD
Identifer (without component):
SQLZ_RC_ACCD

Description:
Access Denied

Associated information:
Sqlcode -970
SQL0970N The system attempted to write to a read-only file.

Number of sqlca tokens : 0
Diaglog message number: 8701


Best post your question in the DB2 Express C support forum:
http://www.ibm.com/developerworks/forums/forum.jspa?forumID=805

Cheers
Serge