CREATE DATABASE returns SQL ERROR SQL0101N

#11

On 23 Jun., 14:26, "Mark A" <no... (AT) nowhere (DOT) com> wrote:

Quote:

"T.Paulus" <p... (AT) kapau (DOT) de> wrote in message

news:ce74a1b8-cd94-49fd-81b6-b747d06c799a (AT) b35g2000yqi (DOT) googlegroups.com...

Hi folks,

I just installed a fresh OpenSolaris with the latest image available
(uname -a returns $ SunOS host01 5.11 snv_111b i86pc i386 i86pc
Solaris)

After installing OpenSolaris I set up also IBM DB2 Express C V9.7. The
installation process was successful and I tried to login as db2inst1
to create my first database.

$ db2 create database SAMPLE

This command returns an error. The error is:

SQL0101N *The statement is too long or too complex. *SQLSTATE=54001

I didn't any special configuration or setup modifications. Everything
runs straight forward. Do you have any idea what is the reason for
this error?

Cheers,
paul

I realize that this does not solve your problem and that the above statement
should have worked, but is there some reason why you did not create the DB2
supplied sample database with db2sampl command?

Also, was the instance created during installation? What happens when you
run db2ilist?

Are you using the latest DB2 Express-C (9.7.2)? I would highly recommend
that you reinstall with latest version this if you don't have it.

I used the very last version of the DB2 Express-C Database (9.7.2).

The problem is reproduceable. I tried it on different VMWare products
and on a physical workstation. Just setup a new OpenSolaris
installation. Use all default settings during the installation
process. After that install a new DB2 Express-C database, also with
all default parameters.

If this setup is finished, you can try to setup a new database as
db2inst1 user. Now you will see the described error.

Anyway, I changed the server operating system because I need a quick
fix for that problem. I switched to a Linux instance and then it works
like expected. Now I have a working instance of a DB2 Express-C
database but the problem with OpenSolaris isn't solved yet. If you
find a solution, maybe sombody else can use your solution.

Nevertheless thank you very much for your support,
--paul

#12

Paul,

Have you posted this problem in teh Db2 Express C support forum?
http://www.ibm.com/developerworks/fo...pa?forumID=805

--
Serge Rielau
SQL Architect DB2 for LUW
IBM Toronto Lab

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

CREATE DATABASE returns SQL ERROR SQL0101N

comp.databases.ibm-db2 comp.databases.ibm-db2

Re: CREATE DATABASE returns SQL ERROR SQL0101N - 06-26-2010 , 11:46 AM

Re: CREATE DATABASE returns SQL ERROR SQL0101N - 06-26-2010 , 12:59 PM