DB2 Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed Forums > Databases > DB2 Development
Reload this Page

Connecting to DB2 via command line over PuTTY (Split from "Uploading a mysql db: Putty or FTP?" in FTP)

Discuss Connecting to DB2 via command line over PuTTY (Split from "Uploading a mysql db: Putty or FTP?" in FTP) in the DB2 Development forum on Dev Shed.
Connecting to DB2 via command line over PuTTY (Split from "Uploading a mysql db: Putty or FTP?" in FTP) DB2 Development forum discussing administration, DB2 queries, SQL/PL, and other DB2-related topics. Covers the entire DB2 line, including UDB (DB2 for Unix and Linux), midrange (AS/400) and mainframe versions.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
Stop making mediocre tutorials.The best tutorials are video! Camtasia Studio makes it easy to create engaging, buzz-building screen videos at any size, in any popular format. Download the free trial!
  #1  
Old April 17th, 2008, 02:55 PM
Gurpreetb78 Gurpreetb78 is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Apr 2008
Posts: 1 Gurpreetb78 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 6 m 15 sec
Reputation Power: 0
New to UNIX and DB2
Dear Members,

I am new to Putty, Unix and DB2 and this is what I am working on right now.
I installed Putty
I got access to username / pwd
I got Unix usrname/Pwd.also got the home directory

once I login into putty I get the screen and it shows $ sign

From here how do I connect to DB2 database?

I have tried db2 "connect to databasename"
but did not help

Please advise

Thankyou,
Gurpreet
Reply With Quote
  #2  
Old April 18th, 2008, 12:22 AM
hiker's Avatar
hiker hiker is offline
They're coming to take me away
Dev Shed Frequenter (2500 - 2999 posts)
  
Join Date: Jan 2005
Location: Florida
Posts: 2,745 hiker User rank is General 3rd Grade (Above 100000 Reputation Level)hiker User rank is General 3rd Grade (Above 100000 Reputation Level)hiker User rank is General 3rd Grade (Above 100000 Reputation Level)hiker User rank is General 3rd Grade (Above 100000 Reputation Level)hiker User rank is General 3rd Grade (Above 100000 Reputation Level)hiker User rank is General 3rd Grade (Above 100000 Reputation Level)hiker User rank is General 3rd Grade (Above 100000 Reputation Level)hiker User rank is General 3rd Grade (Above 100000 Reputation Level)hiker User rank is General 3rd Grade (Above 100000 Reputation Level)hiker User rank is General 3rd Grade (Above 100000 Reputation Level)hiker User rank is General 3rd Grade (Above 100000 Reputation Level)hiker User rank is General 3rd Grade (Above 100000 Reputation Level)hiker User rank is General 3rd Grade (Above 100000 Reputation Level)hiker User rank is General 3rd Grade (Above 100000 Reputation Level)hiker User rank is General 3rd Grade (Above 100000 Reputation Level)hiker User rank is General 3rd Grade (Above 100000 Reputation Level)  Folding Points: 33583 Folding Title: Starter FolderFolding Points: 33583 Folding Title: Starter Folder
Time spent in forums: 1 Month 1 Week 3 Days 15 h 59 m 37 sec
Reputation Power: 1205
Quote:
Originally Posted by Gurpreetb78
Dear Members,

I am new to Putty, Unix and DB2 and this is what I am working on right now.
I installed Putty
I got access to username / pwd
I got Unix usrname/Pwd.also got the home directory

once I login into putty I get the screen and it shows $ sign

From here how do I connect to DB2 database?

I have tried db2 "connect to databasename"
but did not help

Please advise

Thankyou,
Gurpreet


Welcome to Dev Shed.

There's no reason to dig up a 5+ year old thread to add a new problem.

I will ask a mod to split this thread as well as move it to the appropriate forum where you receive better assistance.
Reply With Quote
  #3  
Old April 18th, 2008, 07:48 AM
jharnois's Avatar
jharnois jharnois is offline
mod_dev_shed
Dev Shed God 19th Plane (14000 - 14499 posts)
  
Join Date: Sep 2002
Location: Atlanta, GA
Posts: 14,266 jharnois User rank is Major General (70000 - 90000 Reputation Level)jharnois User rank is Major General (70000 - 90000 Reputation Level)jharnois User rank is Major General (70000 - 90000 Reputation Level)jharnois User rank is Major General (70000 - 90000 Reputation Level)jharnois User rank is Major General (70000 - 90000 Reputation Level)jharnois User rank is Major General (70000 - 90000 Reputation Level)jharnois User rank is Major General (70000 - 90000 Reputation Level)jharnois User rank is Major General (70000 - 90000 Reputation Level)jharnois User rank is Major General (70000 - 90000 Reputation Level)jharnois User rank is Major General (70000 - 90000 Reputation Level)jharnois User rank is Major General (70000 - 90000 Reputation Level)jharnois User rank is Major General (70000 - 90000 Reputation Level)jharnois User rank is Major General (70000 - 90000 Reputation Level)jharnois User rank is Major General (70000 - 90000 Reputation Level) 
Time spent in forums: 1 Month 1 Week 1 Day 23 h 15 m 4 sec
Reputation Power: 744
Welcome to Dev Shed ... thread split and moved from FTP to DB2.
__________________
# Jeremy

Explain your problem instead of asking how to do what you decided was the solution.
Reply With Quote
  #4  
Old April 28th, 2008, 05:48 AM
madhavi_kaza madhavi_kaza is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Apr 2008
Posts: 1 madhavi_kaza User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 16 m 51 sec
Reputation Power: 0
Hi Gurpreet!!

before connecting to database, you need to create database.
At the command prompt just say
step1: "db2sampl" which would create a database.
step2: say db2start.
step3: db2 "connect to sample"

Hope this helps..

Best Regards,
Madhavi.
Reply With Quote
Reply

Viewing: Dev Shed Forums > Databases > DB2 Development > Connecting to DB2 via command line over PuTTY (Split from "Uploading a mysql db: Putty or FTP?" in FTP)

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 3 hosted by Hostway.