DB2 Installation Error

[cboccio@yahoo.com.br]

Hi everybody !!

I am new in DB2 database word, and I am trying to install a DB2
Personal Edition in my notebook to study it, but I have some problems
during the installation.
I have the following situation:
- OS - Win XP Professional
- HW has 192 MB Ram
- Database - DB2 Personal Edition Version 8.1
Error:
1 - SQL1032N Database initialization failed...SQLTAT E=57019
2 - error during the command execution C:\IBM\SQLLIB\b in\db2.exe Create
tools catalog systools use existing database toolsdb force To
initialize the catalog tools of DB2.
Return value is 4.

And then the installation stop and I can´t access the database.

Please, can enybody help me ??

Tks...

Eduardo

[narayana]

Re: DB2 Installation Error

you didn't select the option "create toolsdb" while installation that's
why you are geting error so create that from command window before that
you have to do that after entering into the command window give this
command:

start database manager;

after give this command : create db <database name> on <drive name>

next you have to create the tools database if you want

[sharrisdba]

Re: Re: DB2 Installation Error

"" wrote:[color=blue]
> you didn't select the option "create toolsdb" while
> installation that's
> why you are geting error so create that from command window
> before that
> you have to do that after entering into the command window
> give this
> command:
>
> start database manager;
>
> after give this command : create db <database name> on <drive
> name>
>
> next you have to create the tools database if you want[/color]

Eduardo,

Your db2 instance did not start. That’s what the SQL1032N message
means. I would say it may be due to not enough memory. Although IBM
says 192 MB is enough, I have found installations can fail with this
little amount of memory.

Also, are you running other services too? Maybe other programs are
taking a lot of memory and leaving DB2 almost nothing to run with.
DB2 should be about the only thing running on the box.

What type of processor does the box have? IBM wants at least an Intel
P4 processor. I’ve run on a P3-800 at work and it was pretty slow.

I would suggest at least a 1 GHz or higher processor and at least 1GB
of memory as a minimum. That will allow you to run DB2 and a few
other programs at once. This is of course just for a one user
desktop. A server is a whole other topic.

You might be able to get it to run on 192 MB of ram, but you will be
paging (swapping to disk) like crazy if you do anything more than
simple tiny databases with only the default configurations.

Hope this helps at least a little.

-- Steve

--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/DB2-Installa...ict261850.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=901733

[cboccio@yahoo.com.br]

Re: DB2 Installation Error

I installed the product again and don´t select the option create
toolsdb, like you sad. Then the installation was finished, but I can´t
start database manager. I recieved the following error:

SQL1032N The database command was not sent
SQLSTATE=57019

I was trying to install and run the database with the local
administrator for my machine (not the network/domain administrator). ..
Is there some problem because this ?

Now, what can I do to run the database ?

Tks...

Eduardo

narayana escreveu:
[color=blue]
> you didn't select the option "create toolsdb" while installation that's
> why you are geting error so create that from command window before that
> you have to do that after entering into the command window give this
> command:
>
> start database manager;
>
> after give this command : create db <database name> on <drive name>
>
> next you have to create the tools database if you want[/color]

[Hardy]

Re: DB2 Installation Error

would db2cmd work?
if yes, try "db2ilist" to check if default "DB2" instance is fine;
if fine, try "db2start";
if db2start work, try to create a sample db..

any error info in the process, pls paste here.