Creating a new Database

[amoldhingra]

Hi all,
I'm new to DB2 and want to create a new database in DB2.
I tried doing so with the help of DB2 help but it's giving me following error:

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


DBA0102W  Unable to detect nodetype for instance - "STRDB (DB2) 
".  Reason Code: "-1". 


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.  

User Response: 

Issue a start database manager command and resubmit the current 
command.  

 If using multiple logical nodes, ensure the DB2NODE environment 
variable is set correctly.  The DB2NODE environment variable 
indicates the node the application will attempt to connect to.  
DB2NODE must be set to the node number of one of the nodes 
defined on the same host as the application.  

 sqlcode :  -1032 

 sqlstate :  57019

can anybody please help me on that.

Thanks in advance,
Amol

[sakumar9]

The first thing that you have to do is to start the database manager. The error says: Database manager was not started. Use "db2start" command to start the database. Then use "CREATE DATABASE TEST" to create the database.

If you want to play around with sample tables and sample data, then you can use "db2sampl" command. This will create a database with name "SAMPLE" and will create many tables and data for you, which you can use to get hands on with DB2.

Regards
-- Sanjay

[niladri123]

please follow the following steps
1. Connect to a database
2. Force application all / (If not working db2_kill)
3. db2stop
4. db2admin stop
5. db2admin start
6. db2admin start


Now create the database.