473,408 Members | 2,477 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,408 software developers and data experts.

Oracle DBA Inherited DB2 System

Just inherited a DB2 system, and I know nothing about it. Actually it
says DB6, which I guess is a variant of DB2, running on Linux?

Is "db2" the command line processor that I want to use?

Any suggestions for docs for dummies would be helpful.
Nov 12 '05 #1
8 1240
Buck Turgidson wrote:
Just inherited a DB2 system, and I know nothing about it. Actually it
says DB6, which I guess is a variant of DB2, running on Linux? DB6 means nothing as a DB2 product. Maybe the instance name or database
name?
Is "db2" the command line processor that I want to use? Yes. You can use it as a prefix to an SQL statement or command or you
can go "interactive" by simply typing db2.
I drive db2 from an xemacs shell (gives me full editing capabilities...)
Any suggestions for docs for dummies would be helpful.

Start here:
http://www-130.ibm.com/developerworks/db2
Information center:
http://publib.boulder.ibm.com/infoce...help/index.jsp

There should be a crash course for Oracle DBA on developerWorks - maybe
under the migration section.

Cheers
Serge


--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #2
> DB6 means nothing as a DB2 product. Maybe the instance name or
database
name?


Thanks. Must be some sort of SAP instance name. This is what I get
when I connect.

"Database server = DB2/LINUX 8.2.0"
Nov 12 '05 #3
Buck Turgidson wrote:
DB6 means nothing as a DB2 product. Maybe the instance name or


database
name?

Thanks. Must be some sort of SAP instance name. This is what I get
when I connect.

"Database server = DB2/LINUX 8.2.0"

DB6 is some kind of OTC db product.
See:
http://www.nicholashall.com/db6database.aspx

--
Anton Versteeg
IBM Netherlands
Nov 12 '05 #4
bka
You're almost certainly running DB2 8.2, fixpak 7. You can check the
instance names by running db2ilist.

Nov 12 '05 #5
congrats.
I am in the same situation. I have to say I miss Oracle when I spend my
time on DB2.

Why doesn't IBM give us all the docs? It's like they wanna keep as
secret.

Nov 12 '05 #6
ib****@yahoo.com wrote:
congrats.
I am in the same situation. I have to say I miss Oracle when I spend my
time on DB2.

Why doesn't IBM give us all the docs? It's like they wanna keep as
secret.

Which docs are you missing?

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #7
ib****@yahoo.com wrote:
congrats.
I am in the same situation. I have to say I miss Oracle when I spend my
time on DB2.

Why doesn't IBM give us all the docs? It's like they wanna keep as
secret.

You can download all the docs in PDF or HTML at:

http://www-306.ibm.com/software/data...manualsv8.html

nothing secret about it.

--
Anton Versteeg
IBM Netherlands
Nov 12 '05 #8
Thanks guys.

I need to have:

guide for SQL PL
step by step step procedure for replication

Nov 12 '05 #9

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: susmita_ganguly | last post by:
Hi I am trying to upgrade from oracle 8i to oracle 9i on the same server ..I don't know much abt migration . Can anyone help me out. Thanks. Susmita
0
by: The Murray Midget | last post by:
I have a simple access database that I run as a scheduled task that simply does the following. Runs queries that pull data from a specific table in oracle and dumps into a table in Access. ...
5
by: premmehrotra | last post by:
I am using Microsoft Access 2000 and Oracle 9.2.0.5 on Windows 2000. When I export a table from Access to Oracle using ODBC I get error: ORA 972 identifier too long I think the error is because...
13
by: Chris Botha | last post by:
The machine is running XP Pro with all the latest service packs, etc. I must access an Oracle database so I installed the Oracle client stuff. I can query Oracle from a Windows app, no problem....
0
by: petro | last post by:
I am trying to deploy an asp.net application to my web server. My application uses system.data.oledb to connect to an oracle database. On my development machine I have the oracle client 10g...
0
by: petro | last post by:
I am trying to deploy an asp.net application to my web server. My application uses system.data.oledb to connect to an oracle database. On my development machine I have the oracle client 10g...
5
by: petro | last post by:
Hello all, My asp.net web application works on my machine but I get the following error on our test web server, There is only one oracle home on the test server. Does anyone know how to resolve...
13
by: Lorne Smith | last post by:
Hi, First, sorry for the crosspost, but it seemed appropriate... :) I've come accross what I consider to be a bug, but I don't know if it's already known or not. (VS .Net 2003 Pro - VB.Net) ...
4
by: asad.naeem | last post by:
hi to all this is the problem about inheritence. I have designed a form with some essential controls which are required for every form which will inherited from it. for example i have Button1 on...
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
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
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
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
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,...

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.