Connecting to DB2 with no database name

So i have a utility that i use ( written in java) to setup my databases used by my application. It works like a charm on Oracle , Derby, MySQL and SQLServer. Basically it connects to the db drobs the two databases if they exist and re creates them. Problem is that i cant connect to DB2 without specifying a DB name. Ideally I do not want to have the user go into the DB2 control panel and create a dummy db just so my utility can have the db to connect to.
what should the URL be to connect to DB2 as i discribed above?

I'm a db2 dude, so I've never even heard about connecting to a database without specifying a database name. You've just blown my mind sky high.

Any chance you could enlighten me, and show me what the database URL was that you provided when you connected to those other fly-by-night databases you mentioned?

By the way, are you using the IBM db2 app or net driver?

Regards,

-Cameron McKenzie

LOL well atleast im providing some entertainment huh? The URLS i use for the other DBS are as follows:

Oracle : jdbc

racle:thin:@localhost:1521
SQLServer : jdbc:sqlserver://localhost

Basically i want the ability to programtically create a database and users... however that is possible

oh and im using the net driver.

Dude. I've never seen such Haitian Vodoo Magic in my life. How does your code know which database to connect to?

I'm going to be of absolutely no help, I'm afraid. I was going to my grave thinking you had to supply the database name in the URL.

You have rocked my world.

-Cameron

haha. so basically your are telling me there is no way to programtically create a database in DB2?

Noooooooooooooooooo.

Just saying I haven't done it in my limited experience.

Maybe I'll test it out.

Regards,

-Cameron

Originally posted by premesh purayil:
haha. so basically your are telling me there is no way to programtically create a database in DB2?

Not through JDBC. You could use Runtime.exec to call an operating system shell script to do the work.