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

set integrity after load

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


P: n/a

"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

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

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

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