DB2 Express-C Version 11.1.1.1 in Windows 10

[h***@gmail.com]

Hello everyone,

When trying to install DB2 Express-C Version 11.1.1.1 in Windows 10 64 bits, I got the following error when creating the sample database:

---------------------------------------------------------------------
C:\Program Files\IBM\SQLLIB\BIN>db2sampl.exe -force

Starting the DB2 instance...
Creating database "SAMPLE"...
Existing "SAMPLE" database found...
Dropping and recreating database "SAMPLE"...
Connecting to database "SAMPLE"...
Creating tables and data in schema "62000456"...
Creating tables with XML columns and XML data in schema "62000456"...

--ERROR------------------

SQLSTATE = 42604
Native Error Code = -103

[IBM][CLI Driver][DB2/NT64] SQL0103N The numeric literal "62000456.customer" is not valid. SQLSTATE=42604

-------------------------
Stopping the DB2 instance...

'db2sampl' processing complete.


C:\Program Files\IBM\SQLLIB\BIN>

---------------------------------------------------------------------

62000456 is my local username on a Novel network (non-AD). I'm learning DB2 and would like to use IBM Data Studio to connect to that local database, which I've been unable to.

Many thanks.

[Jeremy Rickard]

Hi, a DB2 object name cannot start with a digit unless it is delimited. So, for example...

create table "123".mynumbers(value integer)

...will work but...

create table 123.mynumbers(value integer)

...will not. You need the double quotes.

The problem you are seeing with db2sampl is that it does not delimit the name of the user who invokes the script; it is using that user as the schema name and owner of the created tables.

This is not documented as a restriction with db2sampl so is arguably a bug. You could raise that with IBM if you wish, but the workaround is to use another user to create the sample database.


Jeremy