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...
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.
From Jeremy Rickard@21:1/5 to All on Tue Jun 13 14:44:33 2017
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.