set integrity after load

Jan Suchanek

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

Rhino

"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

Jan Suchanek

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

N. Shamsundar

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

Mark 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