Background: I have to transfer VS 2003 and VB6 applications from Windows 7 to a new Windows 10 Home machine. The applications are currently using DB2 9.7, Sql Server or Ms Access via ODBC. I decided to consolidate all dbs to DB2 on the W10 machine, using separate schemas for the different databases. The W10 machine is normally standalone (No Lan or Internet).

Details: I installed DB2 Express V10.5 and IBM Data Studio 4.1 on the W10 machine. DB2 Express gives me enough for my db needs, and I assume that Data Studio will give me similar GUI functionality as DB2 Control Center v9 on the W7 machine. I installed DB2 and Data Studio under at least two different user ids(one being Db2admin), all with windows admin rights, and different credentials. But every time I try to login/connect in Data Studio I'm rejected with SQ4499N, I must be doing something fundamentally Wrong.

when running the following commands from CMD I get the shown results.

db2val

DBI1379I The db2val command is running. This can take several minutes.

DBI1333I Installation file validation for the DB2 copy DB2COPY1 was successful.

DBI1339I The instance validation for the instance DB2 was successful.

DBI1343I The db2val command completed successfully. For details, see the log file C:\Users\User\DOCUME~1\DB2LOG\db2val-Wed Mar 02 16_28_37 2022.log.

DB2LEVEL returns: DB21085I This instance or install (instance name, where applicable: "DB2") uses "32" bits and DB2 code release "SQL10054" with level identifier "0605010E". Informational tokens are "DB2 v10.5.400.191", "s140813", "IP23617", and Fix Pack "4". Product is installed at "C:\PROGRA~2\IBM\SQLLIB" with DB2 Copy Name "DB2COPY1".

DB2Start returns: SQL1026N The database manager is already active.

Switching to DB2 CLP db2 => List Active Databases returns: SQL1611W No data was returned by Database System Monitor.

db2 => List database directory returns: SQL1057W The system database directory is empty. SQLSTATE=01606

db2 => list system odbc data sources returns: DB21037W No data sources found.

Checking Google and stackoverflow didn't yield any suitable help, at least I didn't see it. My experience is as app developer, not db2 admin except what is needed for app dev, and I had no problems with DB2 V9.7 on W7, but I'm lost what to do. Any help is appreciated.

CodePudding user response：

The prerequisites and expected behavior is described at the Configuring the IBM Data Studio client for remote operations link.
You got this error either because of misconfiguration or some DS bug / unexpected behavior.
The solution was to create the database manually and just to register this database in DS afterwards.

CodePudding user response：

In practical terms: DB2 V10.5 SQL-Express failed to install the Sample Database. IBM Data Studio tried to connect to the Sample Database and failed the operation with SQL4499N. Manually creating a database overcame this problem.