Need Help with setting up a new db2 database v9 wse!!

[kingdombrokers]

Hello Guru's

I am new to db2 and need some help with setting up a new database.
So far I have created the database. "DB2 create database" And was sent the .sql file would this be the DDL? At this point how do I get the 4 .sql files ran or put into that database. The files seem to have all the table info etc when I "more" them. Do I need to create a table in the database before running each of these files and how would I run them. What command would I use. Help!
Any help right now would be appreciated.. This is a unix server and db2 workgroup server edition v 9.5. Please outline any steps in setting up the database I would truly appreciate it. Also have been trying to get the Control Center running on this box. Even though the Administrative server is running I cant seem to get it started. Tried db2cc. Do I need x server or something in order to do this?

Help!!


Lisa P.
Texas

[sakumar9]

If you have created the database, then you can directly run this .sql script which is having the ddls. It will create all the tables for you.

You can use following command to run the .sql script.

CONNECT TO <dbname>;
db2 -tvf <scriptname.sql> ---> Check what delimiting character are you using. By default, its a semi-colon(;).

Didi I interpreted your problem correctly.. :((

Regards
-- Sanjay