Prev: Data Studion and autocommit
Next: DB2 UDB V9.1.3, Database crash, crash recovery fail, no backup.
From: T. Paulus on 26 Jun 2010 12:46
On 23 Jun., 14:26, "Mark A" <no...(a)nowhere.com> wrote:
> "T.Paulus" <p...(a)kapau.de> wrote in message
>
> news:ce74a1b8-cd94-49fd-81b6-b747d06c799a(a)b35g2000yqi.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
From: Serge Rielau on 26 Jun 2010 13:59
Paul,

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

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

First  |  Prev  | 
Pages: 1 2 3
Prev: Data Studion and autocommit
Next: DB2 UDB V9.1.3, Database crash, crash recovery fail, no backup.