473,398 Members | 2,812 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,398 software developers and data experts.

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

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
Feb 21 '08 #1
1 1364
sakumar9
127 Expert 100+
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.

Expand|Select|Wrap|Line Numbers
  1. CONNECT TO <dbname>;
  2. db2 -tvf <scriptname.sql> ---> Check what delimiting character are you using. By default, its a semi-colon(;).
  3.  
Didi I interpreted your problem correctly.. :((

Regards
-- Sanjay
Feb 27 '08 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: pk_pk | last post by:
hi, i've searched quite a bit, but cant find any post relating to sql command for setting database passwords. anyone know how? thanks pk
5
by: garyusenet | last post by:
At least I think it's using an API (i don't totally understand the concept.) I'm using Act 6. I need to interface with the act database and add 'contacts' to the database. The reason I need to...
5
by: Shani | last post by:
I need help setting up a database which includes a list of about 1200 urls. Anyone who accesses the database should be able to input wheather the url is good or bad. I want to share the databse...
3
by: Big Charles | last post by:
Hi, We have developed an ASP.NET web application and are planning to host it in an external Server, which provides us a good bandwidht. We need to put he web application outside because the...
1
by: srikar | last post by:
Hi all, For the class strstream let the object be line. On an 16 bit machine previously of ANSI standard ststream line line.setf(ios::in); What is need for setting the flag to input....
0
by: Ian Toltz | last post by:
I'm working on a program for creating user accounts. I'm having issues with setting the permissions. Here's an example: String homeDir = @"\\SERVER\directory\"+username; //Create the...
1
by: behnaz.behzadi | last post by:
Hi there, I need help with setting up a reminder in my sql. It needs to check the inventory on hand for a product and if it is below 3 unit, it needs to send an e-mail reminder to the user. ...
1
by: rockchicx23 | last post by:
i have to write a program that is a guessing the number game. the user has to choose the number of games they want to play. i need help setting up the loop that will run the number of times the user...
0
by: srgrector | last post by:
Help? with Coding database modification script using a webform & frames... I will have an Amazon book database that is updated regularly, say weekly. I need a program/script that I can run in...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.