By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,610 Members | 2,332 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,610 IT Pros & Developers. It's quick & easy.

Oracle DBA Inherited DB2 System

P: n/a
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
Share this Question
Share on Google+
8 Replies


P: n/a
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

P: n/a
> 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

P: n/a
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

P: n/a
bka
You're almost certainly running DB2 8.2, fixpak 7. You can check the
instance names by running db2ilist.

Nov 12 '05 #5

P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
Thanks guys.

I need to have:

guide for SQL PL
step by step step procedure for replication

Nov 12 '05 #9

This discussion thread is closed

Replies have been disabled for this discussion.