Hi everyone,
I'm learning DB2 and would like to use IBM Data Studio to connect to that local database, which I've been unable to. Re: DB2 Express-C Version 11.1.1.1 in Windows 10. I installed DB2 Express 10.1 on my Windows 7 (64bit) notebook. Now after the installation finished I cannot connect to the database. During the installation I specified 'C: Daten db db2' as the directory to be used for DB2. When trying to connect, I get the following error: SQL1031N The database directory cannot be found on the indicated file. The folder DB2, containing the DB2 databases created with DB2 Express-C 9.7.5, is apparently not recognized. The install procedure doesn't even attempt modifying or updating the SAMPLE database. Seems the previously created DB2 databases aren't accessible at all! I'm new to DB2 database. I installed DB2 Express-C on my local machine (Windows 10) to play with it, and I created a sample database. If I understand correctly, DB2 uses Windows accounts for access to database. The installation created a db2admin user, but this one does not have access to the sample database. However, having all these databases installed on my system is far from ideal, so I rely a lot on Docker for this task. In this article, I’m going to show how easily you can install DB2 on Docker and set up the JDBC connection so that you can run Hibernate tests on DB2. Installing the DB2 Docker container.
I have trouble to install db2 express-c. I can't figure out what is wrong.Would somebody suggest what I can do to fix it. Thanks in advance.
I installed successfully db2 express-c on 2 PCs at the school, but I can't install
it on my PC successfully.
School: Windows XP Prof w/ SP 1, Pentium III 730 MHz, 256MB RAM
My PC: Windows XP Prof w/ SP 2, Pentium 4 2.4G, 1GB RAM (Firewall disabled)
On my PC, I got the following message displayed on the DOS prompt:
[b]SQL10007N Message '-1390' could not be retrieved. Reason code: '5'[/b]
But I found the following before the above message in the db2.log:
[b]1: ERROR:An error occurred while trying to start the 'DB2' instance. The return
code is '4' and the SQL Message is: 'PROCESS_ERROR'[/b]
db2.log excerpt begins
1: Product to install: DB2 Universal Database Express Edition
C Db2 Example
Installation type: Custom
Target directory: D:IBMSQLLIB
Space required: 451 MB
New instances:
Instance name: DB2
Start instance on reboot: Yes
TCP/IP configuration:
Service name: db2c_DB2
Port number: 50000
Instance user information:
User name: db2admin
DB2 Administration server:
Instance user information:
User name: db2admin
DB2 tools catalog:
Name: TOOLSDB
Schema: SYSTOOLS
Instance: DB2
Location: Local
1: Configuring DB2 JDBC Applet Service:.......Success
1: Configuring DB2 Security Service:.......Success
1: Setting environment variables:.......Success
1: Initializing instance list:.......Success
1: Creating the DB2 Administration Server:.......Success
1: The value 'DB2_EXTSECURITY=YES' was set in the Profile Registry.
1: The value 'DB2_ADMINGROUP=DB2ADMNS' was set in the Profile Registry.
1: The value 'DB2_USERSGROUP=DB2USERS' was set in the Profile Registry.
1: Setting default global profile registry variables:.......Success
1: The instance 'DB2' has been created successfully.
1: The value 'SVCENAME=db2c_DB2' was set in the DBM CFG file for the 'DB2'
instance.
1: The value 'DB2COMM=TCPIP' was set in the Profile Registry for the 'DB2'
instance.
1: Creating/migrating DB2 instances:.......Success
C Db2 Connection
1: Configuring DB2 Governor Service:.......Success
1: Updating ODBC driver locations:.......Success
1: Building list of databases to create:.......Success
1: Registering DB2 licenses:.......Success
1: Installing DB2 performance counters:.......Success
1: ERROR:An error occurred while trying to start the 'DB2' instance. The return
code is '4' and the SQL Message is: 'PROCESS_ERROR'
1: ERROR:SQL10007N Message '-1390' could not be retrieved. Reason code: '5'.
1: ERROR:An error occurred while configuring the database 'TOOLSDB'.
1: Creating DB2 databases:.......Failure
1: Configuring the DB2 Administration Server:.......Success
1: Successfully granted complete operating system access to DB2 objects to members
of the 'DB2ADMNS' group.
1: Successfully granted read and execute operating system access to DB2 objects to
members of the 'DB2USERS' group.
1: ERROR:An error occurred while trying to start the 'DB2' instance. The return
code is '4' and the SQL Message is: 'PROCESS_ERROR'
1: Unable to find the string resource 3575:.......Success
1: Updating global profile registry:.......Success
1: ERROR:SQL10007N Message '-1390' could not be retrieved. Reason code: '5'.
1: ERROR:An error occurred while running the command 'D:IBMSQLLIBbindb2.exe
CREATE TOOLS CATALOG SYSTOOLS USE EXISTING DATABASE TOOLSDB FORCE' to
initialize and/or migrate the DB2 tools catalog database. The return value is
'8'.
1: Creating DB2 tools catalog:.......Failure
1: Unable to find the string resource 3574:.......Success
1: Starting all DB2 services:.......Success
1: WARNING:A minor error occurred while installing 'DB2 Universal Database Express
Edition' on this computer. Some features may not function correctly.
1: DB2 Setup wizard has finished copying files to your computer. Please shut down all software programs running on the system now. The programs can then be restarted and DB2 will be ready for use. However, a minor error occurred while installing this computer. Some features may not function correctly and some required system configuration tasks may not be completed successfully. The install logs db2wi.log and db2.log are located in C:Documents and SettingsJacksonMy DocumentsDB2LOG.
1: Failed to start the up and running engine.
db2.log excerpt ends