Tag Archives: SQLSTATE=58004)

Creating users with DB2, solving the problem of sqlstate=58004)

It looks like DB2 and OS user accounts are associated, so let’s learn how to create a windows account first

 

C:\Documents and Settings\Administrator>net user

User accounts for \\IBM-R8M6A58

——————————————————————————-
ASPNET cyper.yin db2admin
Guest HelpAssistant SUPPORT_388945a0
The command completed successfully.

Add a user named test

D:\>net user test passw0rd /add
The command completed successfully.

View all user groups

D:\>net localgroup

Aliases for \\IBM-R8M6A58

————————————————-
*Administrators
*Backup Operators
*DB2ADMNS
*DB2USERS
*Guests
*HelpServicesGroup
*Network Configuration Operators
*ora_dba
*Power Users
*Remote Desktop Users
*Replicator
*Users
The command completed successfully.

To add the user test to the administrators group.

D:\>net localgroup administrators test /add
The command completed successfully.

At this point, user test is now able to connect to the sample database.

It should be enough to add test to the db2admns group. I suddenly tried to use the db2cc command and it didn’t work.

I think it is possible that the “typical installation” does not have this feature, so I double-click the unpacked setup.exe to “use existing products”, “modify” mode to reinstall

As a result, after the installation, the scene happened again

C:\Documents and Settings\Administrator>db2start
DB2 : The service has returned a service-specific error code.

SQL1042C An unexpected system error has occurred. SQLSTATE=58004

Following the clues here

http://www.ibm.com/developerworks/forums/thread.jspa?messageID=14906211&tstart=0

Re: DB2 ExpressC v.10.1 doesn’t work on Windows xp 32bit (?)
Method 1: We resolved this problem by adding c:\program files\ibm\gsk8\lib to the PATH environment variable.

Method 2: Whenever you type the command db2start if the following error is displayed
DB2 : The service has returned a service-specific error code.
SQL1042C An unexpected system error occurred. SQLSTATE=58004
Create icc64 directory in C:\Program Files\IBM\SQLLIB\BIN\ and copy the contents of C:\Program Files\IBM\gsk8\lib64 to C:\Program Files\IBM\SQLLIB\BIN\icc64 directory (copy only the contents of lib64 directory and also make sure you copy all the contents of lib64 directory)
Option 2 is talking about the 64-bit case, my computer is 32-bit, I copied
C:\Program Files\IBM\gsk8\lib directory all the contents to D:\IBM\SQLLIB\BIN\icc directory, also succeeded! (icc directory does not exist, you need to create it yourself)