Geeks With Blogs

@KodefuGuru
  • KodefuGuru OH: well, I'm Bulgarian so I couldn't resist about 467 days ago
  • KodefuGuru Reddit is complaining about connectiveness of #xboxone, but I think it's awesome. No need for physical discs and my dad can play my games. about 471 days ago
  • KodefuGuru Jared Leto's hair. That's all. about 472 days ago
  • KodefuGuru I wonder what effect 8 hours of dubstep will have on my cats? about 472 days ago

News


Path Notes of a Kodefu Master blog

I needed to get some work finished this weekend. The VPN connection to my clients network is generally very slow and flaky (and doesn't work with my Vista box), so I decided I would install the database on my PC and work without the tethers of Cisco constraint.

The database in question was db2, so I went to IBM's website and downloaded a copy. After everything was in place, I attempted to create a database.

create database mydb
SQL1032N  No start database manager command was issued.  SQLSTATE=57019

SQL1032N  No start database manager command was issued.

Explanation:

The start database manager command has not been processed.  It
must be processed before a stop database manager, any SQL
statement, or utility can be issued. 

 The command cannot be processed. 

I was miffed. Did the installer not actually start the database manager? Well, that's easy enough to start myself.

start database manager
SQL1026N  The database manager is already active.

SQL1026N  The database manager is already active.

Explanation:

A start database manager command is already processed. 

 The command cannot be processed. 

No dice. DB2 thinks its databasemanager is already active when you attempt to activate it, but it doesn't think that when you try to create a database.

I've wasted hours trying to get this to work. I haven't found anything useful through google searches. People have complained about the problem, but there are no legitimate answers to be found. Why can't  I be developing against a SQL Server like a normal person?

Posted on Monday, September 3, 2007 8:12 AM | Back to top


Comments on this post: I Hate DB2

# re: I Hate DB2
Requesting Gravatar...
Which version did you download? Vista is only supported as of DB2 9 fixpack 2.
Left by Marcel on Sep 03, 2007 8:45 PM

# re: I Hate DB2
Requesting Gravatar...
I originally downloaded the 8 Personal Edition. Then I tried out a 90-day trial of 9 Enterprise Edition. I assumed they distributed the most current version for trials, but I didn't check. I'll try it out tonight. Thanks for the tip.
Left by Chris Eargle on Sep 04, 2007 1:16 AM

# re: I Hate DB2
Requesting Gravatar...
I had the same problem, developing asp against a db2 all was well until a few minutes ago, then suddenly the app stopped connecting to the db. From db2 control center I found I couldn't connect either. Having read your post first, I then found the answer on a German site.

Open a db2 command window (the one that looks like DOS) and enter each of the following in turn, (press enter in each case);
db2start
db2stop
db2stop force
db2_kill

For me, this sorted it. Good luck All.
Left by Rob on Mar 30, 2011 8:59 AM

# re: I Hate DB2
Requesting Gravatar...
Try harder boss
Left by Sagar on Aug 25, 2011 5:52 AM

Your comment:
 (will show your gravatar)
 


Copyright © Chris Eargle | Powered by: GeeksWithBlogs.net | Join free