467,151 Members | 904 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

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

set integrity after load

Hello,

I have loaded a lot of tables into my database - some tables with
foreign keys, so that when I want to access the tables after the load I
get the error message that accessing the table is not possible at the
moment - i have the set the integrity of the table first... I am now
looking for a way to set the integrity for all tables at once after the
loading of many tables. Is there a way to get this done?

another question came just to my mind: is the a way of making the db2
CLP a little more comfortable. A command history would be graet for
starters...

Thanks for any help...

Greetings, Jan
Nov 12 '05 #1
  • viewed: 3974
Share:
4 Replies

"Jan Suchanek" <ja**********@gmx.de> wrote in message
news:41********@news.uni-ulm.de...

another question came just to my mind: is the a way of making the db2
CLP a little more comfortable. A command history would be graet for
starters...

What version of DB2 are you using and what OS are you running? I'm running
DB2 V7.2 on Windows XP and my DB2 CLP has a command history; just use
up-arrow and down-arrow to cycle through them. I thought all recent versions
of DB2 had that feature. (I know Version 2 did not have command history but
I don't think many people are still running Version 2.)

Rhino

Nov 12 '05 #2
hi,

Rhino wrote:
"Jan Suchanek" <ja**********@gmx.de> wrote in message
news:41********@news.uni-ulm.de...
another question came just to my mind: is the a way of making the db2
CLP a little more comfortable. A command history would be graet for
starters...


What version of DB2 are you using and what OS are you running? I'm running
DB2 V7.2 on Windows XP and my DB2 CLP has a command history; just use
up-arrow and down-arrow to cycle through them. I thought all recent versions
of DB2 had that feature. (I know Version 2 did not have command history but
I don't think many people are still running Version 2.)


We talking about a V8.1 - so it should work... But the up-arrow does not
work. Has this feature to be activated?

Greetings, Jan
Nov 12 '05 #3
Jan Suchanek wrote:
hi,

Rhino wrote:
"Jan Suchanek" <ja**********@gmx.de> wrote in message
news:41********@news.uni-ulm.de...
another question came just to my mind: is the a way of making the db2
CLP a little more comfortable. A command history would be graet for
starters...


What version of DB2 are you using and what OS are you running? I'm
running
DB2 V7.2 on Windows XP and my DB2 CLP has a command history; just use
up-arrow and down-arrow to cycle through them. I thought all recent
versions
of DB2 had that feature. (I know Version 2 did not have command
history but
I don't think many people are still running Version 2.)

We talking about a V8.1 - so it should work... But the up-arrow does not
work. Has this feature to be activated?

Greetings, Jan


I have observed the same problem with V7.2 and V8.1, but only on Linux
and not on Win-NT/XP.

On our Linux server, this is what the up-arrow gives: (inside the DB2
CLP; the history feature works fine in sh or csh):

db2 => ^[[A

Is there a DB2 environmental variable to be set, similar to TERM in the
shell?

N. Shamsundar
University of Houston
Nov 12 '05 #4
> I have observed the same problem with V7.2 and V8.1, but only on Linux
and not on Win-NT/XP.

On our Linux server, this is what the up-arrow gives: (inside the DB2
CLP; the history feature works fine in sh or csh):

db2 => ^[[A

Is there a DB2 environmental variable to be set, similar to TERM in the
shell?

N. Shamsundar
University of Houston


The command history is function of windows (up or down arrow), not DB2. UNIX
shells have there own version of command history. Try alt-k on UNIX (that is
what I use on AIX).
Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by maricel | last post: by
5 posts views Thread by Jean-Marc Blaise | last post: by
1 post views Thread by Brian Tkatch | last post: by
2 posts views Thread by Doug | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.