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?