469,336 Members | 5,480 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,336 developers. It's quick & easy.

drop instance?

How to I drop instance under Linux?
for example i have created db2inst2 instance
i want to completely remove that instance and all database under that
instance
IN winows there is command db2idrop
What is the command in Linux?

thanks in advance

Nov 14 '05 #1
10 6081
Hi,

ca*****@gmail.com wrote:
How to I drop instance under Linux?
for example i have created db2inst2 instance
i want to completely remove that instance and all database under that
instance
IN winows there is command db2idrop
What is the command in Linux?


believe it or not, it's db2idrop in Linux, too :)
(and it's located in /opt/IBM/db2/V<your-version-number>/instance/

regards,
benjamin
--
Please compose your messages as plaintext,
and do not send MS Office attachments:
http://www.efn.no/html-bad.html
http://www.goldmark.org/netrants/no-word/attach.html
Nov 14 '05 #2
Ian
ca*****@gmail.com wrote:
How to I drop instance under Linux?
for example i have created db2inst2 instance
i want to completely remove that instance and all database under that
instance
IN winows there is command db2idrop
What is the command in Linux?


Note, dropping an instance will NOT drop any databases that exist in the
instance (this applies to all supported LUW platforms).

You must physically issue the DROP DATABASE command.

Nov 14 '05 #3
thanks!

another question i just met
for the BLOB,
I have read DB2 documentation that BLOB is used is ideally for storing
large binary object
To create a table that contains a BLOB column, s ROWID column must be
defined
The ROWID functions as a pointer to the actual BLOB data associated
with the specific row,,,,
What I am confused is that there is no such rowid column in the
emp_photo table of sample DB
How the "picture" column allocates the data without rowid?

any help?

Nov 14 '05 #4
ca*****@gmail.com wrote:
I have read DB2 documentation that BLOB is used is ideally for storing
large binary object To create a table that contains a BLOB column, s ROWID
column must be defined


As far as I remember the ROWID thing is used for the JDBC3.0 "blob"
feature in V8.2 only (where BLOB/CLOB are defined as classes).

If you're read and store the BLOB with IO-Streams, its not needed.

Bernd

--
"Ja, alles meine Herren" sprach Fürst Lichnowsky. "Ooch det roochen?"
"Ja, auch das Rauchen." "Ooch im Tiergarten?" "Ja, auch im Tiergarten
darf geraucht werden, meine Herren." Und so endeten die Barrikadenkämpfe
des 18. März in Berlin
Nov 14 '05 #5
Also, see the sample applications (sqllib/samples/c|cpp|java) to see how
BLOBs are used.

--
--------------------
Larry Menard
"Defender of Geese and of All Things Natural"
"Bernd Hohmann" <ho*****@harddiskcafe.de> wrote in message
news:3t************@individual.net...
ca*****@gmail.com wrote:
I have read DB2 documentation that BLOB is used is ideally for storing
large binary object To create a table that contains a BLOB column, s ROWID
column must be defined


As far as I remember the ROWID thing is used for the JDBC3.0 "blob"
feature in V8.2 only (where BLOB/CLOB are defined as classes).

If you're read and store the BLOB with IO-Streams, its not needed.

Bernd

--
"Ja, alles meine Herren" sprach Fürst Lichnowsky. "Ooch det roochen?"
"Ja, auch das Rauchen." "Ooch im Tiergarten?" "Ja, auch im Tiergarten
darf geraucht werden, meine Herren." Und so endeten die Barrikadenkämpfe
des 18. März in Berlin
Nov 14 '05 #6
ca*****@gmail.com wrote:
thanks!

another question i just met
for the BLOB,
I have read DB2 documentation that BLOB is used is ideally for storing
large binary object
To create a table that contains a BLOB column, s ROWID column must be
defined
The ROWID functions as a pointer to the actual BLOB data associated
with the specific row,,,,
What I am confused is that there is no such rowid column in the
emp_photo table of sample DB
How the "picture" column allocates the data without rowid?

any help?


I suspect you have been reading the DB2 for z/OS (mainframe) documentation
as that is how BLOBs are handled on that platform. This is due to some
special characteristics (limitations) in z/OS datasets, which require LOBs
to be handled this way.

In DB2 for LUW (Linux, UNIX and Windows) it is much more straightforward.
Nov 14 '05 #7
below is what i read from the book "Db2 developer guide" chapter 4

"A ROWID must appear in every table that contains a BLOB column or a
UDT based on a BLOB data type."

Also an example is given as follow:

CREATE TABLE userid.MOVIE

(MOVIE_ID INTEGER NOT NULL,

MOVIE_NAME VARCHAR(50) NOT NULL,

MOVIE_REVIEW BLOB(1M),

ROW_ID ROWID GENERATED ALWAYS

) IN database.tablespace;

that is what i am confused

Many thanks!

Nov 17 '05 #8
In article <11**********************@o13g2000cwo.googlegroups .com>,
(ca*****@gmail.com) says...
below is what i read from the book "Db2 developer guide" chapter 4

"A ROWID must appear in every table that contains a BLOB column or a
UDT based on a BLOB data type."


I guess they are talking about DB2 for z/OS ?
Nov 17 '05 #9
So It is not necessary to create a rowid in the table that contains a
blob column
if i am using DB2 UDB under WINDOWS OS

thanks

Nov 17 '05 #10
ca*****@gmail.com wrote:
So It is not necessary to create a rowid in the table that contains a
blob column
if i am using DB2 UDB under WINDOWS OS

thanks

correct

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 17 '05 #11

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Greg Scharlemann | last post: by
reply views Thread by Lauren Quantrell | last post: by
reply views Thread by Mythran | last post: by
7 posts views Thread by aixunix | last post: by
2 posts views Thread by bob_jeffcoat | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.