some dummy quesitons on DB2

cy163 · #1 (**permalink**) 10-08-10, 04:44

Hi All,

I am totally new to DB2. I am sorry to disturbing you all with the following dummy questions

I wonder
(1) how to show all databases which have been created;
(2) how to show all tables given a database;
(3) please show me or recommend some code snippets on how to connect db2 database from JAVA applications.

Thanks

Daniil.Monin · #2 (**permalink**) 10-08-10, 06:13

Hello. I am not clever with a java, but i try to help you.

(1) how to show all databases which have been created;
Using db2api. Or some analog in java, i guess.

(2) how to show all tables given a database;

Connect to database and run:

Quote:

select NAME, CREATOR from sysibm.systables

Remeber, this script shows you system tables too.

(3) please show me or recommend some code snippets on how to connect db2 database from JAVA applications.
Basic steps

DB2Plus · #3 (**permalink**) 10-08-10, 07:27

If you don't want watch the system table names, use the query:

Code:

select tb.* 
from sysibm.systables tb
where NOT 
tb.name like 'SYSIBM.%'

Kara

cy163 · #4 (**permalink**) 10-08-10, 10:43

Thanks for your reply and help

Actually , I want to know whether there are command line commands at the 'db2' prompt to show all already created databases on a DB2 server

Daniil.Monin · #5 (**permalink**) 10-08-10, 14:32

Quote:

Originally Posted by cy163

Thanks for your reply and help

Actually , I want to know whether there are command line commands at the 'db2' prompt to show all already created databases on a DB2 server

You can use:

LIST DB DIRECTORY

Internet Services

Web Development

Digital Marketing

Consumer Tech