By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,610 Members | 2,310 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,610 IT Pros & Developers. It's quick & easy.

DB2 Installation Error

P: n/a
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...SQLTATE=57019
2 - error during the command execution C:\IBM\SQLLIB\bin\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

Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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

Nov 12 '05 #2

P: n/a
"" wrote:
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


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
Nov 12 '05 #3

P: n/a
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:
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


Nov 12 '05 #4

P: n/a
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.

Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.